File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and the fly likes c3p0, Tomcat and ComboPooledDataSource Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "c3p0, Tomcat and ComboPooledDataSource" Watch "c3p0, Tomcat and ComboPooledDataSource" New topic

c3p0, Tomcat and ComboPooledDataSource

William Hardwick

Joined: Dec 03, 2008
Posts: 1
I am trying to create a c3p0 connection pool in Tomcat.

In my context.xml, I have the following:

In my web.xml, I have the following:

And in my class, I am accessing using the following:

I am getting the following exception:

My question is, why is Tomcat casting this to an instance of org.apache.tomcat.dbcp.dbcp.BasicDataSource (why isn't it staying as a ComboPooledDataSource) and what can I do to get it as a PooledDataSource object so that I can call the getNumConnections() method on it?

I agree. Here's the link:
subject: c3p0, Tomcat and ComboPooledDataSource