"Broken Pipe" in JDBC due session autorefresh
Posted by: Ekaterina Ivanova
Date: March 24, 2018 01:43AM

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?

Options: ReplyQuote

Written By
"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.