[jboss-user] [EJB 3.0] - EJB3 Persistence Layer and MySQL Timeout

[go_rags]

Hi,

We are using EJB3 Persistence with MySQL.  We are having an issue where the connection is closed by MySQL after the default 8 hours of inactivity.  Is there a property that can be set in JBOSS/EJB3 that can keep the connection active using keep alive or something similar.

I have tried setting the following properties in the EJB3 persistence.properties file. But it did not seem to fix the problem.

hibernate.connection.autoReconnect=true
hibernate.connection.autoReconnectForPool=true
hibernate.connection.is-connection-validation-required=true

We are using the mysql 3.1 connector, we tried using the mysql 5.0.7 connector as well but still the timeout causes a socket error on the jboss side.

Can you please let me know what parameters should be set or point me to the right literature.

Thanks,
Raghu.

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4092082#4092082

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4092082