Problem in MySQL/Hibernate

[Duleep Thivanka]

Hi all

We have developed a web application using hibernate/MySQL 5 running on a tomcat 6 server.Application works fine but we have a problem when login to the system every morning.It gives a java.net.SocketException Broken Pipe Exception.When we restart tomcat server it works fine again.What can be the cause for this exception ?

Thanks in advance

[Mark Spritzler]

Actually, MySQL is known for this and there is an entry in Hibernate's FAQ about this very question.

https://www.hibernate.org/117.html#A15

Mark

[Ram Para]

Try using Connection Pool.

I was also facing the same problem but now the things are working fine. You can refer https://www.hibernate.org/214.html

[Duleep Thivanka]

Thanks a lot.