The moose likes JDBC and Relational Databases 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 and Relational Databases
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
It's not a secret anymore!