Hi,

I am using MySQL database for my hibernate application. Its working fine on first day, but next day (After 8 hours) when i am sending any request then in first request i am getting exception and in second request its wroking fine.

I have implemented hibernate application using Annotations based API and using EntityManager.

My Database Connections Properties are :

<property name="hibernate.connection.driver_class" value="com.mysql.jdbc.Driver" />
<property name="hibernate.connection.url" value="jdbc:mysql://localhost:3306/mywayinteractive_db?autoReconnect=true" />
<property name="hibernate.connection.username" value="root" />
<property name="hibernate.connection.password" value="admin" />

So, When first request is coming to server i am getting below exception but when second request is coming to server then its working fine.

java.net.SocketException
MESSAGE: Software caused connection abort: recv failed

STACKTRACE:

java.net.SocketException: Software caused connection abort: recv failed
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:129)

So, what is that ? pls reply me.

Thanks in advance.

Do you have a firewall? Perhaps the firewall or proxy is timing out the connection before your database is? Is there a time limit on connections through the proxy?

Just a shot in the dark, but I've seen that cause problems.

No. firewall is off. proxy is there. And i haven't specify any time limit.