Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

DB Connection in Eclipse

 
Riyasat Tabrez
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
[Thumbnail for Swing.JPG]
 
Wei Dai
Ranch Hand
Posts: 86
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
>java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver"
Try oracle.jdbc.driver.OracleDriver
 
Riyasat Tabrez
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Wei

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

Regards
Riyasat
 
Rob Spoor
Sheriff
Pie
Posts: 20751
68
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You try to load the wrong class. The package is not oracle.jdbc but oracle.jdbc.driver.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic