Forum Stats

  • 3,825,285 Users
  • 2,260,497 Discussions
  • 7,896,481 Comments

Discussions

Testing loading Oracle JDBC driver ... Failed:

876213
876213 Member Posts: 32
edited Apr 21, 2014 8:49AM in SQL Developer

Testing the Oracle Home located at C:\app\oracle\product\11.2.0\instantclient-basic-nt-11.2.0.4.0\instantclient_11_2

Testing client directory ... OK

Testing loading Oracle JDBC driver ... Failed:

  C:\app\oracle\product\11.2.0\instantclient-basic-nt-11.2.0.4.0\instantclient_11_2\jdbc\lib\ojdbc6.jar is not a valid jar file

I downloaded and extracted the instantclient-jdbc-nt-11.2.0.4.0 zip file from Oracle Technology Network, several times.  Still, receiving the same odd error message from Oracle SQL Developer Version 4.0.1.14 test.  The ojdbc6.jar file was extracted into the instantclient_11_2 subdirectory, not the lib subdirectory.  There is no jdbc or lib subdirectories.  Where in configuration is the jdbc and lib subdirectories defined?  I need Oracle SQL Developer 4 to look in the instantclient_11_2 subdirectory.

Best Answer

  • Gary Graham-Oracle
    Gary Graham-Oracle Member Posts: 3,256 Bronze Crown
    Answer ✓

    Hi,

    ...is not a valid jar file
    

    This message is quite misleading. It is not due to a corrupt download.  If in Database > Advanced > Use Oracle Client > Configure... you select

    Client Type: Oracle Home 
    Client Location: <point at an Instant Client>
    

    then click on Test... this error will occur.  Instead you need to select

    Client Type: Instant Client
    

    Regards,

    Gary

    SQL Developer Team

Answers

This discussion has been closed.