Forum Stats

  • 3,825,285 Users
  • 2,260,497 Discussions


Testing loading Oracle JDBC driver ... Failed:

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-\instantclient_11_2

Testing client directory ... OK

Testing loading Oracle JDBC driver ... Failed:

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

I downloaded and extracted the instantclient-jdbc-nt- zip file from Oracle Technology Network, several times.  Still, receiving the same odd error message from Oracle SQL Developer Version 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, 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



    SQL Developer Team


This discussion has been closed.