It's not a secret anymore!
The moose likes Tomcat and the fly likes Oracle Drivers under Tomcat 5.5 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Tomcat
Bookmark "Oracle Drivers under Tomcat 5.5" Watch "Oracle Drivers under Tomcat 5.5" New topic

Oracle Drivers under Tomcat 5.5

Jim Cross

Joined: Nov 20, 2003
Posts: 17
Hi guys,

I'm experiencing a problem connecting to Oracle 9 from Tomcat 5.5. Have found loads of posts on the net describing the problem, but none of the solutions work for me.

The exception I get is:
Cannot create JDBC driver of class '' for connect URL 'null'
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getDriver(

Having run this through the debugger in Tomcat, it's definitely a problem loading the class - when I step into DriverManager.loadInitialDrivers(), I can see that drivers in the following snippet is always null:

I've put ojdbc14.jar under common/lib. I have the following in server.xml:

And in web.xml:

I know the classname is correct, as I have a standalone project which loads the driver and connects to the database fine - the problem only occurs under Tomcat.

I'm really tearing my hair out with this one, so any help greatly appreciated!


Jim Cross

Joined: Nov 20, 2003
Posts: 17
After a bit more investigation, it's definitely not a driver loading issue, as I can query the db from a Servlet in the same instance by explicitly loading the driver using
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Sirish Kumar Gongal Reddy
Ranch Hand

Joined: Oct 25, 2004
Posts: 109

Have you copied classes111.jar or classes12.jar to tomcat/common/lib?

Problem is tomcat is not able to find OracleDriver class which will come along with classes111/12.jar.

Move your .jar file to tomcat lib. It will work.

I agree. Here's the link:
subject: Oracle Drivers under Tomcat 5.5
It's not a secret anymore!