File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Problem with Tomcat/Data Source Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Problem with Tomcat/Data Source " Watch "Problem with Tomcat/Data Source " New topic
Author

Problem with Tomcat/Data Source

nextweek
Greenhorn

Joined: May 18, 2007
Posts: 2
Hello,

I have a problem in that Tomcat does not seem to be recognising my DB Driver. I have tried linking a global data source to my application as well as adding a project specific one with no luck. Here is some of my files:




I also have my DB drivers in the commons/lib file. I know the connect string works fine because I can access the DB from Eclipse when writing standard Java code.

This seems common problem and I have been searching Google for the last 3 hours but nothing I have tried has fixed my problem.

I am using Tomcat 5.5 and J2EE 5. I am creating the links and resources in Tomcat admin.

I don't get any logs or stacktrace, the only error I get is as follows in the returned JSP page:


DataSource Example
Cannot create JDBC driver of class '' for connect URL 'null'


And the console output below

What am I doing wrong?

Cheers




I am using ojdbc14.jar driver and as I mentioned it is in commons/lib
sathish kumar
Ranch Hand

Joined: Feb 14, 2007
Posts: 47
Think it should be

oracle.jdbc.pool.OracleConnectionPoolDataSource

instead of
oracle.jdbc.driver.OracleDriver
nextweek
Greenhorn

Joined: May 18, 2007
Posts: 2
Originally posted by sathish kumar:
Think it should be

oracle.jdbc.pool.OracleConnectionPoolDataSource

instead of


Sounds logical, I can't test it until later though. Thanks for your time.
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

"nextweek",
Welcome to the JavaRanch.

We're a friendly group, but we do require members to have valid display names.

Display names must be two words: your first name, a space, then your last name. Fictitious names are not allowed.

Please edit your profile and correct your display name since accounts with invalid display names get deleted, often without warning

thanks,
Dave
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Problem with Tomcat/Data Source