mysql怎么创建会话_在mysql的wait_timeout之后创建会话时出现问题

最新推荐文章于 2023-08-11 10:47:51 发布

weixin_39598568

最新推荐文章于 2023-08-11 10:47:51 发布

阅读量153

点赞数

文章标签： mysql怎么创建会话

本文链接：https://blog.csdn.net/weixin_39598568/article/details/113950909

版权

我使用的是hibernate 3和mysql 5.1。当我通过mysql的wait_timeout连接到数据库时，我无法创建新的会话。它给了我以下例外。

ERROR - Communications link failure

Last packet sent to the server was 0 ms ago.

ERROR - JDBC rollback failed

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Connection.close() has already been called. Invalid operation in this state.

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

at java.lang.reflect.Constructor.newInstance(Constructor.java:513)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)

at com.mysql.jdbc.Util.getInstance(Util.java:381)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)

at com.mysql.jdbc.ConnectionImpl.getMutex(ConnectionImpl.java:3032)

at com.mysql.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:4606)

at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:183)

at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:162)

at com.arosys.hibernateDao.HibernateFactory.rollback(HibernateFactory.java:95)

at com.arosys.hibernateDao.AbstractDao.handleException(AbstractDao.java:171)

at com.arosys.hibernateDao.AbstractDao.fetchUserData(AbstractDao.java:209)

at com.arosys.beansDao.CredentialsDao.fetchUserData(CredentialsDao.java:83)

at org.ArosysLogin.server.GWTLoginImpl.myMethod(GWTLoginImpl.java:87)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:569)

at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:208)

at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:248)

at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)

at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)

at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)

at java.lang.Thread.run(Thread.java:662)

ERROR - Couldn't rollback Transaction

org.hibernate.TransactionException: JDBC rollback failed

at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:170)