1 Reply Latest reply on Nov 2, 2005 4:19 PM by Ronald van Kuijk

    JDBC Commit failing ... exception

    Venkat Challagulla Newbie

      Hi all,

      If I keep the server idle or some hours, I am getting JDBC Commit failed exception. I am attaching the log ... Could you please advise what setting needs to be done on the server side.

      Thanks

      ------------------------------------
      2005-11-02 09:48:34,274 DEBUG [org.jbpm.webapp.context.PersistenceContext] beginning transaction
      2005-11-02 09:48:34,274 DEBUG [org.hibernate.impl.SessionImpl] opened session at timestamp: 4632386413666304
      2005-11-02 09:48:34,274 DEBUG [org.hibernate.transaction.JDBCTransaction] begin
      2005-11-02 09:48:34,274 DEBUG [org.hibernate.jdbc.AbstractBatcher] opening JDBC connection
      2005-11-02 09:48:34,274 DEBUG [org.hibernate.transaction.JDBCTransaction] current autocommit status: true
      2005-11-02 09:48:34,274 DEBUG [org.hibernate.transaction.JDBCTransaction] disabling autocommit
      2005-11-02 09:48:34,274 DEBUG [org.jbpm.webapp.context.PersistenceContext] committing transaction
      2005-11-02 09:48:34,274 DEBUG [org.hibernate.transaction.JDBCTransaction] commit
      2005-11-02 09:48:34,274 DEBUG [org.hibernate.impl.SessionImpl] automatically flushing session
      2005-11-02 09:48:34,274 DEBUG [org.hibernate.jdbc.JDBCContext] before transaction completion
      2005-11-02 09:48:34,275 DEBUG [org.hibernate.impl.SessionImpl] before transaction completion
      2005-11-02 09:48:34,279 DEBUG [org.hibernate.transaction.JDBCTransaction] committed JDBC Connection
      2005-11-02 09:48:34,279 DEBUG [org.hibernate.jdbc.JDBCContext] after transaction completion
      2005-11-02 09:48:34,279 DEBUG [org.hibernate.impl.SessionImpl] after transaction completion
      2005-11-02 09:48:34,279 DEBUG [org.hibernate.transaction.JDBCTransaction] re-enabling autocommit
      2005-11-02 09:48:34,279 DEBUG [org.hibernate.impl.SessionImpl] closing session
      2005-11-02 09:48:34,279 DEBUG [org.hibernate.jdbc.AbstractBatcher] closing JDBC connection (open PreparedStatements: 0, globally: 0) (open Result
      Sets: 0, globally: 0)
      2005-11-02 09:48:34,287 ERROR [org.hibernate.transaction.JDBCTransaction] JDBC commit failed
      com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

      ** BEGIN NESTED EXCEPTION **

      java.io.EOFException

      STACKTRACE:

      java.io.EOFException
      at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1902)
      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2348)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2858)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1570)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
      at com.mysql.jdbc.Connection.execSQL(Connection.java:2972)
      at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:4870)
      at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkTransaction(BaseWrapperManagedConnection.java:419)
      at org.jboss.resource.adapter.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:722)
      at org.jboss.resource.adapter.jdbc.WrappedConnection.commit(WrappedConnection.java:450)
      at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:95)
      at org.jbpm.db.JbpmSession.commitTransaction(JbpmSession.java:103)
      at org.jbpm.db.JbpmSession.commitTransactionAndClose(JbpmSession.java:129)
      at org.jbpm.webapp.context.PersistenceContext.endTransaction(PersistenceContext.java:30)
      at org.jbpm.webapp.filter.PersistenceFilter.doFilter(PersistenceFilter.java:40)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at org.jbpm.webapp.filter.ContextFilter.doFilter(ContextFilter.java:19)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at org.jbpm.webapp.filter.LogFilter.doFilter(LogFilter.java:38)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
      at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
      at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:153)
      at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
      at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
      at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
      at java.lang.Thread.run(Thread.java:595)


      ** END NESTED EXCEPTION **



      Last packet sent to the server was 10 ms ago.
      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2560)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2858)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1570)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
      at com.mysql.jdbc.Connection.execSQL(Connection.java:2972)
      at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:4870)
      at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkTransaction(BaseWrapperManagedConnection.java:419)
      at org.jboss.resource.adapter.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:722)
      at org.jboss.resource.adapter.jdbc.WrappedConnection.commit(WrappedConnection.java:450)
      at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:95)
      at org.jbpm.db.JbpmSession.commitTransaction(JbpmSession.java:103)
      at org.jbpm.db.JbpmSession.commitTransactionAndClose(JbpmSession.java:129)
      at org.jbpm.webapp.context.PersistenceContext.endTransaction(PersistenceContext.java:30)
      at org.jbpm.webapp.filter.PersistenceFilter.doFilter(PersistenceFilter.java:40)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at org.jbpm.webapp.filter.ContextFilter.doFilter(ContextFilter.java:19)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at org.jbpm.webapp.filter.LogFilter.doFilter(LogFilter.java:38)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
      at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
      at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:153)
      at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
      at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
      at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
      at java.lang.Thread.run(Thread.java:595)
      at org.jbpm.webapp.filter.PersistenceFilter.doFilter(PersistenceFilter.java:40)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at org.jbpm.webapp.filter.ContextFilter.doFilter(ContextFilter.java:19)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at org.jbpm.webapp.filter.LogFilter.doFilter(LogFilter.java:38)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
      at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
      at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:153)
      at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
      at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
      at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
      at java.lang.Thread.run(Thread.java:595)
      2005-11-02 09:48:34,287 DEBUG [org.hibernate.jdbc.JDBCContext] after transaction completion
      2005-11-02 09:48:34,287 DEBUG [org.hibernate.impl.SessionImpl] after transaction completion
      2005-11-02 09:48:34,288 DEBUG [org.hibernate.transaction.JDBCTransaction] re-enabling autocommit
      2005-11-02 09:48:34,288 ERROR [org.jbpm.db.JbpmSession] org.hibernate.TransactionException: JDBC commit failed