Make your own free website on Tripod.com

InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

InstantDB: Import from JDBC/ODBC source, problem!


Hi guys,
I'm having trouble importing data from Access or SQLServer.
It says the SQL statement is wrong.
 
The code is:
Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:SandeeppSm30");
Statement stmt = con.createStatement();
 
Class.forName ("org.enhydra.instantdb.jdbc.idbDriver");
Connection con2 = DriverManager.getConnection("jdbc:idb:sample.prp");
Statement stmt2 = con2.createStatement();
 
// stmt2.execute("IMPORT jproduct FROM 'jdbc:odbc:SandeeppSm30' USING 'SELECT * FROM jproduct' BUFFER 2048");
   stmt.execute("IMPORT jproduct FROM 'jdbc:odbc:SandeeppSm30'");
 
I tried both of the last statements. Both don't work for me :-0.
Could someone please tell me what I'm doing wrong?
 
cheers,
Kam.