java.sql.SQLException: Couldn't perform the operation setAutoCommit

標籤：style   blog   color   io   os   java   for   2014   div   

java.sql.SQLException: Couldn‘t perform the operation setAutoCommit: You can‘t perform any operations on this connection. It has been automatically closed by Proxool for some reason (see logs).[2014-09-15 11:59:25] ERROR org.hibernate.transaction.JDBCTransaction -Could not toggle autocommitjava.sql.SQLException: Couldn‘t perform the operation setAutoCommit: You can‘t perform any operations on this connection. It has been automatically closed by Proxool for some reason (see logs).[2014-09-15 11:59:25] ERROR org.hibernate.transaction.JDBCTransaction -JDBC rollback failedjava.sql.SQLException: Couldn‘t perform the operation rollback: You can‘t perform any operations on this connection. It has been automatically closed by Proxool for some reason (see logs).[2014-09-15 11:59:25] ERROR org.springframework.transaction.interceptor.TransactionInterceptor -Application exception overridden by rollback exceptionorg.springframework.transaction.TransactionSystemException: Could not commit JDBC transaction; nested exception is java.sql.SQLException: Couldn‘t perform the operation commit: You can‘t perform any operations on this connection. It has been automatically closed by Proxool for some reason (see logs).Caused by: org.hibernate.TransactionException: JDBC rollback failed    at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:200)    at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:676)    ... 87 moreCaused by: java.sql.SQLException: Couldn‘t perform the operation rollback: You can‘t perform any operations on this connection. It has been automatically closed by Proxool for some reason (see logs).    at org.logicalcobwebs.proxool.WrappedConnection.invoke(WrappedConnection.java:207)    at org.logicalcobwebs.proxool.WrappedConnection.intercept(WrappedConnection.java:87)    at $java.sql.Connection$$EnhancerByProxool$$9ebf70db.rollback(<generated>)    at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:213)    at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:192)    ... 88 more

由spring 控制事務。。並且事務是有時間限制的。。。在寫程式的時候開啟事務，又去調用webservices ..造成事務逾時。

java.sql.SQLException: Couldn't perform the operation setAutoCommit