DB Connection in Eclipse

[Riyasat Tabrez]

Hi

I have JDK 1.7.0.40
Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production
PL/SQL Release 11.2.0.2.0 - Production
"CORE 11.2.0.2.0 Production"
TNS for 32-bit Windows: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
OS: Windows XP
Eclipse Helios

Requirement: I want to retrieve data from the default schema in SQL developer called HR which has 21 tables in it through Eclipse. I have changed the perspective to DB in eclipse. However when I go through the "New Connection Profile" wizard I noticed that the default settings are not the same as it is given on the below link.

OracleDocs

After following instructions on the above page I could not find the required .jar file named oracle.eclipse.tools.database.jdbc.driver*.jar mentioned in the instruction. The path to my eclipse folder is D:\eclipse.

The error that I get on Eclipse is attached as an Image it says ping failed "java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver". I am not sure about what username and password to be entered in the connection wizard. I have tried User name as hr and password as hr does not works

How do I resolve this, any help will be appreciated

Thanks

[Wei Dai]

>java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver"
Try oracle.jdbc.driver.OracleDriver

[Riyasat Tabrez]

Hi Wei

Could you please elaborate more on your suggestion. Will wait for you reply

Regards
Riyasat

[Rob Spoor]

You try to load the wrong class. The package is not oracle.jdbc but oracle.jdbc.driver.