[ShaneCoder]

I have a web project that I have worked with in Eclipse for years. Just downloaded myEcclipse to give it a shot. Configured Tomcat5.x to point to a fresh 5.5.28 download. Added ojdbc14.jar (oracle JDBC Drivers jar) to $CATALINA_HOME/common/lib. Deployed my web project to the tomcat 5.5 server in myEclipse. When I start that server, I get errors in the console like such:

Cannot create JDBC driver of class ‘oracle.jdbc.driver.OracleDriver’ for connect URL ‘jdbc:oracle:thin@192.168.1.4:1521:orcl’
java.sql.SQLException: No suitable driver
…

What is the correct method to make the ojdbc.jar file available to tomcat when it runs inside myEclipse?

[support-shalini]

ShaneCoder,
You can add the JDBC jar files to your project using “Add External JARs”. Right click on your project and from the context menu select Build Path > Configure Build Path. Under the libraries tab click “Add External JARs” and select the jar files you wish to add.
Let me know if that helps.

[ShaneCoder]

Thanks for the help. Changing Build Path didn’t fix the problem.

In troubleshooting, realized same problem in standalone Tomcat outside of MyEclipse. I’ll post this issue to some Tomcat boards.

[Author]

Posts