Hi all,

I have a problem when a query takes more than 80 seconds, it automatically gets duplicated and if the duplicated one reaches the 80 seconds generates another thread more. Probably I have something bad configured but I don't know why.

This is my configuration:

<hibernate-configuration>
<session-factory>
<!-- local connection properties -->
<property name="hibernate.connection.url">
jdbc:mysql://localhost/copiaPro
</property>
<property name="hibernate.connection.driver_class">
org.gjt.mm.mysql.Driver
</property>
<!-- property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property> -->
<property name="dialect">
org.hibernate.dialect.MySQLDialect
</property>
<property name="hibernate.connection.username">root</property>
<property name="hibernate.connection.password">root</property>
<property name="hibernate.show_sql">true</property>
<property name="hibernate.transaction.factory_class">
org.hibernate.transaction.JDBCTransactionFactory
</property>
<property name="hibernate.cache.use_second_level_cache">false</property>
<property name="hibernate.cache.use_query_cache">false</property>
<property name="hibernate.max_fetch_depth">3</property>

<!-- configuration pool via c3p0-->
<property name="c3p0.acquire_increment">1</property>
<property name="c3p0.idle_test_period">10800</property> <!-- seconds -->
<property name="c3p0.max_size">40</property>
<property name="c3p0.max_statements">0</property>
<property name="c3p0.min_size">0</property>
<property name="c3p0.timeout">100</property> <!-- seconds -->
<property name="connection.autoReconnectForPools">true</property>
<property name="c3p0.acquireRetryAttempts">2</property>
<property name="c3p0.automaticTestTable">C3P0TestTable</property>
<property name="c3p0.testConnectionOnCheckout">true</property>


Thanks for reading me and hope to hear from you soon... this really desperates me.

Any Idea?

Thank you people!