Testing loading Oracle JDBC driver ... Failed:

876213

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.

Gary Graham-Oracle

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

Gary Graham-Oracle

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

876213

Yes, solution resolved issue.  Thank you.