Sounds to me the site is "leaking" connection, i.e. connection is being established and never released. So you have to check the code where the connection is being is established. Since you are using hibernate this means most like you are not resuning session and/or calling "session.close()" when you are done with a session. Hope that helps.
On Feb 19, 3:51 am, Mihai DINCA <mihai.di...@free.fr> wrote: > 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?...- > >Hide quoted text - > > - Show quoted text - -- 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
