Several c3p0 applications give a warning

Question

Hello
I have two web applications under one com. Both use sleep mode 3.2.1 and c3p0 0.9.1.2. While the second application is deploying, I always get the following warning message.
Tomcat: apache-tomcat-6.0.28

WARN 2010-11-06 19: 04: 37,270 C3P0Registry mbean is already registered. This probably means that the application using c3p0 was not deployed, but not all PooledData sources were closed before deployment. This can lead to a drain of resources over time. Please take care to close all sources of PooledData.

Please help with this.

Thanks in advance Goura

Answer 1

In order not to download and register C3P0Registry several times (when deploying several web applications while reloading this web application), my recommendation was to move JAR C3P0 (and JDBC driver) from Webapp classloader ( WebappX/WEB-INF/lib ) in the Common classloader ( $TOMCAT_HOME/lib ).

Answer 2

If you do not want c3p0 to be exposed via JMX , you could do:

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