[daveyboy]

I’m having trouble connecting to Oracle 9. Both Eclipse and Oracle are on my local machine. When I use the DB Browser to view schema information, it keeps giving me the error ‘oracle.jdbc.driver.OracleDriver’.

I went through the steps of adding a new driver, pointed it to classes12.jar, and the driver showed up in the list. I selected that driver, supplied a name and a sample URL. Back on the main screen, I entered the oracle connect info that I successfully used an hour before in a java app., and it won’t let me browse….still giving the above mentioned error.

Any ideas?

Thanks.

[Riyad Kalla]

Davey,
Check your log file (workspace dir\.metadata\.log) for a more detailed stack trace and past it here. Also please let us know what version of MyEclipse and Eclipse you are using as well as driver version.

[daveyboy]

The log file says the following:

!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 Dec 10, 2004 10:33:30.421
!MESSAGE Error while trying to login to database
!STACK 0
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:199)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:187)
at net.sourceforge.squirrel_sql.fw.util.MyURLClassLoader.findClass(MyURLClassLoader.java:113)
at java.lang.ClassLoader.loadClass(ClassLoader.java:289)
at java.lang.ClassLoader.loadClass(ClassLoader.java:235)
at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:96)
at com.genuitec.eclipse.sqlexplorer.sessiontree.actions.LoginProgress$Login.run(Unknown Source)
at java.lang.Thread.run(Thread.java:534)

I don’t understand, when I went add a driver from an external source, I gave it the jar, and it picked the driver for me. Then, it says it can’t find it.

I am using eclipse version 3.0.0, and MyEclipse version 3.8.2.

Thanks.

[Riyad Kalla]

You added this on the “Extra JAR” tab of the new driver dialog right?

[daveyboy]

Got it to work. I copied the classes12.jar from c:\ into the web-inf\lib directory, and for some reason it found it there. Can’t explain this one….

[fjuarez]

Where can i download the driver to connect to Oracle8i and what is the sample URL ?

Thanks.. I am new to myeclipse I am using the latest myeclipseide

[Author]

Posts