Web System error after some time online

0

I have a web system on a server, I'm using tomcat and the system is working fine, but when it's a while, without someone getting into the system, it stops working. For example I leave the job and leave the system running on the server, when I come back the next day and try to get into the error.

My doubts are as follows: What can this problem be?

Error excerpt in tomcat log:

25-Jun-2015 08:10:38.757 WARN [http-nio-8080-exec-49] org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logExceptions SQL Error: 0, SQLState: 08S01
25-Jun-2015 08:10:38.757 ERROR [http-nio-8080-exec-49] org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logExceptions Communications link failure due to underlying exception: 

** BEGIN NESTED EXCEPTION ** 

java.net.SocketException
MESSAGE: Software caused connection abort: socket write error

STACKTRACE:

java.net.SocketException: Software caused connection abort: socket write error
    at java.net.SocketOutputStream.socketWrite0(Native Method)
    at java.net.SocketOutputStream.socketWrite(Unknown Source)
    at java.net.SocketOutputStream.write(Unknown Source)
    at java.io.BufferedOutputStream.flushBuffer(Unknown Source)
    at java.io.BufferedOutputStream.flush(Unknown Source)
    at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2744)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1612)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
    at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
    
asked by anonymous 25.06.2015 / 14:25

1 answer

0

I solved the problem by making a Thread that does a one-hour appointment in the bank. That way there is always a "connection" with the bank and the connection does not fall. But recently I got a hint from @rray that would add a property in the hibernate configuration:

<property name="connection.autoReconnect">true</property>
    
08.12.2015 / 12:57