hibernate c3p0 close_wait connection - connessioni che non si chiudono

[ciro78]

ciao ragazzi
come da oggetto ho una web app che utilizza hibernate e c3p0
ma certe connessioni non si chiudono restano nello stato wait_close

in rete se ne dicono di cotte e di crude tr cui bug della versione della jvm e altri

questa è la parte che riguarda il c3p0

<property name="hibernate.c3p0.min_size">10</property>
<property name="hibernate.c3p0.max_size">100</property>
<property name="hibernate.c3p0.timeout">200</property>
<property name="hibernate.c3p0.max_statements">100</property>
<property name="hibernate.c3p0.idle_test_period">200</property>
<property name="hibernate.c3p0.validate">true</property>
<property name="hibernate.c3p0.preferredTestQuery">select 1;</property>
<property name="current_session_context_class">thread</property>
<property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>    
<property name="show_sql">false</property>
<property name="hbm2ddl.auto">validate</property>

questi i parametri di mysql

interactive_timeout=1180
wait_timeout=1180

consigli?


aggiungo i seguenti messaggi di errore dal file catalina.out

GRAVE: The web application [/xxxx] created a ThreadLocal with key of type [java.lang.ThreadLocal] (value 
[java.lang.ThreadLocal@52b9e383]) and a value of type [com.opensymphony.xwork2.inject.ContainerImpl] (value 
[com.opensymphony.xwork2.inject.ContainerImpl@6a9e752c]) but failed to remove it when the web application was 
stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.

GRAVE: The web application [/mobile] registered the JDBC driver [com.mysql.jdbc.Driver] but failed to unregister it 
when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.