Hi guys...
I'm getting this when i'm trying to run a scheduler from a
servlet.
ERROR org.hibernate.util.JDBCExceptionReporter - The last packet successfully received from the server was86384 seconds ago.The last packet sent successfully to the server was 86384 seconds ago, which is longer than the server configured value of 'wait_timeout'.
You should consider either expiring and/or
testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
in my hibernate-config file i have these settings
<property name="hibernate.c3p0.idle_test_period">10</property>
<property name="hibernate.c3p0.timeout">18000</property>
any by default mysql server's wait_timeout=28800.
Can you guys figure out where i'm going wrong?