Thread: ODBC- Microsoft Access Driver Optional feature not implemented in JDeveloper 10.1.3

Hello everyone,

I had started to do my project in JDeveloper 10.1.3 named "Conference Management System". I decided to use the following tools:

1. JDK 6
2. JDeveloper 10.1.3 as editor
3. WebLogic 8.1 as application server
4. Microsoft Access 2007 as db

I had installed all these on a single machine & trying to configure them with each other. I set PATH variable in environment variable targeting JDK6 bin directory.

I had created data source name from control panel->admin tool-> data source. The data source named "ACCESS_DSN" was connected properly--- answered by db configuration wizard; when I clicked on "Test Connection" button.

The connection name DBConnection1 is appeared in "database" folder in connection tree. When I clicked on "connect" in pop-up menu; appeared when right-clicked on "DBConnection1" the following exception occurs:-


oracle.javatools.db.DBException: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented
at oracle.javatools.db.JdbcDatabase.loadSchemas(JdbcD atabase.java:544)
at oracle.javatools.db.JdbcDatabase.listSchemas(JdbcD atabase.java:488)
at oracle.jdevimpl.cm.dt.browser.jdbc.JdbcBrowser.loa dChildren(JdbcBrowser.java:287)
at oracle.jdevimpl.cm.dt.browser.jdbc.JdbcBrowser.ope nConnectionBrowser(JdbcBrowser.java:232)
at oracle.jdeveloper.cm.dt.ConnectionNode$NodeOpen.do Work(ConnectionNode.java:423)
at oracle.ide.dialogs.ProgressRunnable.run(ProgressRu nnable.java:159)
at oracle.ide.dialogs.ProgressBar.run(ProgressBar.jav a:551)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc .java:6958)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java :7115)
at sun.jdbc.odbc.JdbcOdbc.SQLTables(JdbcOdbc.java:551 9)
at sun.jdbc.odbc.JdbcOdbcDatabaseMetaData.getTables(J dbcOdbcDatabaseMetaData.java:2395)
at sun.jdbc.odbc.JdbcOdbcDatabaseMetaData.getSchemas( JdbcOdbcDatabaseMetaData.java:2444)
at oracle.javatools.db.JdbcDatabase.loadSchemas(JdbcD atabase.java:529)
... 7 more

When I tried all the above things on the same configuration except Microsoft Access 2007, instead I used Microsoft Access 2003 as database, the whole stuff works fine. I can connect with db & program works. But I want to use MS-Access 2007 bcoz I m not comfortable with MS-Access 2003.

Can anyone please suggest what to do for above problem ?

Any help would be greatly appreciated......


Thanks to forum, all members & viewers