"Broken Pipe" in JDBC due session autorefresh
Hi!
I have a Tomcat application with two database connecctions: JDBC and Hibernate ones. The Hibernate connection fails after 20 hours of inactivity due c3po session auto-refresh (free memory: 213412744 at that moment). Here is a stack trace:
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2652)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1554)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3176)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1153)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1266)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:116)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:80)
... 44 more
Could you help me with that? Hibernate forim said that it is clearly MySQL case. I have tryed to use DataSource and several sets of c3po properties with no effect. Help me please?
Subject
Written By
Posted
"Broken Pipe" in JDBC due session autorefresh
March 24, 2018 01:43AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.