Multiple applications having c3p0 configuration gives warning

Question

Hi
I have two web application under one tomcat. Both are using hibernate 3.2.1 and c3p0 0.9.1.2. While the second application gets deployed, I always get the following warning message.
Tomcat: apache-tomcat-6.0.28

WARN 2010-11-06 19:04:37,270 A C3P0Registry mbean is already registered. This probably means that an application using c3p0 was undeployed, but not all PooledDataSources were closed prior to undeployment. This may lead to resource leaks over time. Please take care to close all PooledDataSources.

Please help in this regard.

Thanks in advance
Goura

score 10 · Answer 1 · answered Nov 07 '10 at 09:44

To avoid the C3P0Registry from being loaded and registered multiple times (when deploying multiple webapps, when reloading a given webapp), my recommendation would be to move the C3P0 JAR (and the JDBC driver) from the Webapp classloader (WebappX/WEB-INF/lib) to the Common classloader ($TOMCAT_HOME/lib).

score 5 · Answer 2 · answered Nov 06 '10 at 15:42

5

If you dont want c3p0 exposed through JMX then you could do:

com.mchange.v2.c3p0.management.ManagementCoordinator=com.mchange.v2.c3p0.management.NullManagementCoordinator

answered Nov 06 '10 at 15:42

cherouvim

31,725
15
104
153

Thanks for the reply. where should I add this ManagementCoordinator param? – Goura Nov 06 '10 at 19:38
In your c3p0.properties or c3p0-config.xml. Don't know how to do it in the hibernate.cfg.xml though. – cherouvim Nov 06 '10 at 19:46
I think it's not doable via hibernate. Simply add a c3p0.properties with just the configuration line above. – cherouvim Nov 08 '10 at 16:40

Multiple applications having c3p0 configuration gives warning

2 Answers2

Linked