• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Tim Cooke
  • Campbell Ritchie
  • Ron McLeod
  • Liutauras Vilda
  • Jeanne Boyarsky
Sheriffs:
  • Junilu Lacar
  • Rob Spoor
  • Paul Clapham
Saloon Keepers:
  • Tim Holloway
  • Tim Moores
  • Jesse Silverman
  • Stephan van Hulst
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Piet Souris
  • Frits Walraven

DB Connection in Eclipse

 
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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]
 
Ranch Hand
Posts: 86
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Wei

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

Regards
Riyasat
 
Sheriff
Posts: 22573
122
Eclipse IDE Spring VI Editor Chrome Java Windows
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
You try to load the wrong class. The package is not oracle.jdbc but oracle.jdbc.driver.
 
reply
    Bookmark Topic Watch Topic
  • New Topic