es mi primer dia a nivel productivo, y ha salido esta exception de manera continua en el dia:
Código PHP:
Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
tengo configurado la capa de persistencia con Hibernate y c3p0 pongo la configuracion:
Código PHP:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="hibernate.connection.url">?autoReconnect=true</property>
<property name="hibernate.connection.username"> </property>
<property name="hibernate.connection.password"> </property>
<!-- <property name="hibernate.connection.pool_size">5</property>-->
<property name="connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property>
<property name="c3p0.min_size">10</property>
<property name="c3p0.max_size">50</property>
<property name="c3p0.acquire_increment">15</property>
<property name="c3p0.timeout">300</property>
<property name="c3p0.max_statements">0</property>
<property name="c3p0.idle_test_period">120</property>
<property name="hibernate.show_sql">true</property>
<property name="connection.autoReconnect">true</property>
<property name="hibernate.current_session_context_class">thread</property>
<mapping resource="dao/hibernate/Tecnologias.hbm.xml"/>
<mapping resource="dao/hibernate/Servicios.hbm.xml"/>
<mapping resource="dao/hibernate/Tiposerv.hbm.xml"/>
<mapping resource="dao/hibernate/Evalservicios.hbm.xml"/>
<mapping resource="dao/hibernate/Subtiposerv3.hbm.xml"/>
</hibernate-configuration>
quedo al pendiente de sus comentarios!!!