Hi All,


I am using hibernate,Mysql and JBOSS server,i want to know how can i keep the database connection alive,i would communication link failure error after some period of time, I am sing c3p0 ,but it dint helped me out.

Can anyone say what configuration i should do to set for production.

Thankx

Hello sams11, this issue it's related to mysql. It's a very common behavior with the connection pool an mysql. Mysql by default closes a connection that it's been idle for a period of ~8 hours. You could tell c3p0 that query the db within a period of time shorter that the one that it's configured in mysql and you'll be fine.

regards,

Hi,

I have used c3p0 to query the db,these r the settings i have done

in hibernate.cfg.xml
<property name="hibernate.c3p0.idle_test_period">25200</property>

and i have c3p0 jar file and property file contains

c3p0.preferredTestQuery=SELECT userName from test.user where userName='admin'
c3p0.testConnectionOnCheckout=true

even with these query its not keeping the mysql connection alive.And i want to know if no one pings within 8hrs whether we need to restart the server?if not how can i manage with c3p0,its not working fine.I have to restart the server if no one pings for 8hrs.

CAn any one suggest me the solution,i want to keep it running.

Thankx.

I too have had the issue you have described and have tried all sorts of hibernate configurations, although I am new to using hibernate. Thus far the only solution I have found is to add these arguments when starting the MySQL server, --connect_timeout and --wait_timeout. Not ideal and I am still looking for a better solution but at least for now it works.