Welcome to the Java Programming Forums


The professional, friendly Java community. 21,500 members and growing!


The Java Programming Forums are a community of Java programmers from all around the World. Our members have a wide range of skills and they all have one thing in common: A passion to learn and code Java. We invite beginner Java programmers right through to Java professionals to post here and share your knowledge. Become a part of the community, help others, expand your knowledge of Java and enjoy talking with like minded people. Registration is quick and best of all free. We look forward to meeting you.


>> REGISTER NOW TO START POSTING


Members have full access to the forums. Advertisements are removed for registered users.

Results 1 to 1 of 1

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

  1. #1
    Junior Member
    Join Date
    Dec 2011
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Exclamation 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
    Last edited by TomCruse; December 25th, 2011 at 02:22 PM.


Similar Threads

  1. Replies: 2
    Last Post: November 17th, 2011, 08:03 AM
  2. Replies: 1
    Last Post: October 31st, 2011, 01:22 PM
  3. Replies: 1
    Last Post: September 9th, 2011, 03:30 PM
  4. Cannot locate sun.jdbc.odbc.jbcOdbc driver
    By birdlover2010 in forum JDBC & Databases
    Replies: 7
    Last Post: November 6th, 2010, 03:57 PM
  5. Replies: 6
    Last Post: August 30th, 2009, 05:31 AM