DB Connection in Eclipse

Greenhorn

Posts: 7

posted 8 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

Swing.JPG