Testing loading Oracle JDBC driver ... Failed:

876213 Apr 20, 2014 4:10 AM

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

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.

1. Re: Testing loading Oracle JDBC driver ... Failed:

Gary Graham-Oracle Apr 20, 2014 9:09 AM (in response to 876213)

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
Like Show 0 Likes(0)

Actions
2. Re: Testing loading Oracle JDBC driver ... Failed:

876213 Apr 21, 2014 12:49 PM (in response to Gary Graham-Oracle)

Yes, solution resolved issue. Thank you.
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.