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

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 autocommit
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 -JDBC rollback failed
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).


[2014-09-15 11:59:25] ERROR org.springframework.transaction.interceptor.TransactionInterceptor -Application exception overridden by rollback exception
org.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 more
Caused 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

上一篇:sql CString 转int 问题


下一篇:分布式数据库架构--排序、分页、分组、实现