hi all,
i have a webapp taht uses Hibernate and MYSQL, running on top of tomcat.
i am letting Hibernate handle the connections to mysql db, since i have no connection pools defined in tomcat.
after running the application for nearly 9 hours, when i tried to use my app to connect to the database i got following exception:

Caused by: net.sf.hibernate.JDBCException: Could not execute query
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1476)
at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:45)
at com.myapp.hibernate.HibernatePersistenceManager.query(HibernatePersistenceManager.java:205)
... 31 more
Caused by: java.sql.SQLException: Communication link failure: java.net.SocketException, underlying cause: Software caused connection abort: recv failed

** BEGIN NESTED EXCEPTION **

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

STACKTRACE:

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

i searched the web and found two solutions:
one was to add following properties to hibernate config file

<property name="connection.autoReconnect">true</property>
<property name="connection.autoReconnectForPools">true</property>
<property name="connection.is-connection-validation-required">true</property>

that didnt worked.

the other one was to add autoReconnect=true to jdbc URL.

and unfortunately that didnt work either, coz i left the applicatoin running for 11 hours and then i got same exception

Please, can anyone help me out?

thanx and regards
marco



but this does not work, as ihave added thos eproperties to hibernate properties file and i am still getting same exception

anyone can help on theissue?

thanx in advance adn regards
marco


--------------------------------------------------------------------------------

Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First

Try adding the following to your hibernate.xml:



Make sure you also have the following set in your hibernate.xml: