Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

MSAccess + JDBC driver issue

843854Mar 22 2004 — edited Jul 13 2004
Hello All.

I am trying to use the reverse engineering tool provided by OJB + am having some issues. I am using a microsoft access database. Here is my connection parameters :

sun.jdbc.odbc.JdbcOdbcDriver
jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\\myDatabase.mdb

It seems to make the connection alright, the problem comes when I try and run the reverse engineering tool. I have attached the output below. It looks like my driver does not provide the funcionality I need. Should I use a differnent version of the sun driver? A differnt driver for MSAccess? I've looked around for a while but could not find any solid information.

Thank you in advance for any recommendation.

>>>
reverse-db:
[reversedb] Using JDBC-ODBC Bridge (odbcjt32.dll) 2.0001 (04.00.6200)
[reversedb] 106:[Microsoft][ODBC Microsoft Access Driver]Optional feature not im
plemented
[reversedb] java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]Opti
onal feature not implemented
[reversedb] at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)
[reversedb] at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
[reversedb] at sun.jdbc.odbc.JdbcOdbc.SQLTables(JdbcOdbc.java:5519)
[reversedb] at sun.jdbc.odbc.JdbcOdbcDatabaseMetaData.getTables(JdbcOdbcData
baseMetaData.java:2395)
[reversedb] at sun.jdbc.odbc.JdbcOdbcDatabaseMetaData.getSchemas(JdbcOdbcDat
abaseMetaData.java:2444)
[reversedb] at org.apache.ojb.tools.mapping.reversedb.DBCatalog.read(Unknown
Source)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 10 2004
Added on Mar 22 2004
8 comments
239 views