JSync Conduit and JDBC-ODBC bridge driver
0 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Michael_Taylor
Posted On:   Wednesday, November 14, 2001 06:32 PM

Hi, I have been trying to modify the 'RDBMSCond' JSync example so that it works with MS Access instead of Oracle Lite. Now it looks like Oracle Lite comes with its own Type 3 JDBC driver; I don't have the equivalent for MS Access, so am using Sun's JDBC-ODBC bridge driver. Now I know that I have set-up my ODBC connection correctly, because I have a seperate Java application why can successfully query my Access database. However, when I come to HotSync, I get a whole host of failures. java.sql.SQLException: No data found at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(   More>>

Hi,

I have been trying to modify the 'RDBMSCond' JSync example so that it works
with MS Access instead of Oracle Lite.

Now it looks like Oracle Lite comes with its own Type 3 JDBC driver; I don't
have the equivalent for MS Access, so am using Sun's JDBC-ODBC bridge
driver.

Now I know that I have set-up my ODBC connection correctly, because I have a
seperate Java application why can successfully query my Access database.
However, when I come to HotSync, I get a whole host of failures.

			
java.sql.SQLException: No data found
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcResultSet.getString(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcResultSet.getString(Unknown Source)
at miridor.AccessCond.AccessCond.selectAddresses(AccessCond.java:109)
at miridor.AccessCond.AccessCond.open(AccessCond.java:40)
at palm.conduit.SyncManager.sync(SyncManager.java:132)


This Conduit only has the following changes from RDBMSCond:

RDBMSCond:

			
Class.forName("oracle.pol.poljdbc.POLJDBCDriver");
connection = DriverManager.getConnection("jdbc:Polite:POlite", "SYSTEM",
"My-password");


AccessCond:

			
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
connection = DriverManager.getConnection("jdbc:odbc:AccessCond", "", "");


(and obviously I renamed all entries from RDBMS to Access)

NB: 'AccessCond' has been set-up in the ODBC manager to reflect the correct
database. The database has one table:

ACCESS

and the same fields as the Oracle "address.ddl" file describes.

My question is this. Is there some problem with using the JDBC-ODBC bridge
driver (timeout etc.)? If so, what should I do so that I can get access to
Access? (without spending $500+ on a Type 3 JDBC driver)

Kinds regards,

Michael Taylor

   <<Less
About | Sitemap | Contact