Hi

You must look the logs (Tomcat logs, MySQL logs, OS logs ...), maybe there is something there. Tomcat maintain a pool of database connections. I.e. there are some already established permanent connections to the database. It is possible to configure the OS and/or the database (I don't know exactly how on MySQL) to close any TCP/IP connection unused for a certain timeout. The description of your problem seems to indicate this behavior. I think it would be useful to check your database parameters and your OS settings for that.

Hope it helps
mihai


Madhav Yadav a écrit :

Hi All,

I have a site in which I am using hibernate for the database connection.

I am using hibernate3, mysql5, tomcat5.


All is working fine for one day but when I open the site next day then it is showing the database connection error.

I restart the sever and it is working but next day site showing me same problem.

Please help me.

Thanks

--
You received this message because you are subscribed to the Google
Groups "Java EE (J2EE) Programming with Passion!" group.
To post to this group, send email to
java-ee-j2ee-programming-with-passion@googlegroups.com
To unsubscribe from this group, send email to
java-ee-j2ee-programming-with-passion+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/java-ee-j2ee-programming-with-passion?hl=en?hl=en

--
You received this message because you are subscribed to the Google
Groups "Java EE (J2EE) Programming with Passion!" group.
To post to this group, send email to
java-ee-j2ee-programming-with-passion@googlegroups.com
To unsubscribe from this group, send email to
java-ee-j2ee-programming-with-passion+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/java-ee-j2ee-programming-with-passion?hl=en?hl=en

Reply via email to