Error Description: 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 ).
At org. logicalcobwebs. proxool. wrappedconnection. Invoke (wrappedconnection. Java: 207)
At org. logicalcobwebs. proxool. wrappedconnection. Intercept (wrappedconnection. Java: 87)
At $ java. SQL. Connection $ enhancerbyproxool $ c663b102. setautocommit (<generated>)
At org. hibernate. transaction. jdbctransaction. toggleautocommit (jdbctransaction. Java: 224)
At org. hibernate. transaction. jdbctransaction. commitandresetautocommit (jdbctransaction. Java: 169)
At org. hibernate. transaction. jdbctransaction. Commit (jdbctransaction. Java: 142)
At org.apache.tomcat.util.net. aprendpoint $ socketprocessor. Run (aprendpoint. Java: 1822)
At java. util. Concurrent. threadpoolexecutor $ worker. runtask (threadpoolexecutor. Java: 886)
At java. util. Concurrent. threadpoolexecutor $ worker. Run (threadpoolexecutor. Java: 908)
At java. Lang. thread. Run (thread. Java: 662)
Error 2013-05-22 18:32:20, 839 org. hibernate. transaction. jdbctransaction: JDBC commit failed
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 ).
At org. logicalcobwebs. proxool. wrappedconnection. Invoke (wrappedconnection. Java: 207)
At org. logicalcobwebs. proxool. wrappedconnection. Intercept (wrappedconnection. Java: 87)
At $ java. SQL. Connection $ enhancerbyproxool $ c663b102. Commit (<generated>)
At org. hibernate. transaction. jdbctransaction. commitandresetautocommit (jdbctransaction. Java: 166)
At org. hibernate. transaction. jdbctransaction. Commit (jdbctransaction. Java: 142)
At org. springframework. Orm. hibernate3.hibernatetransactionmanager. docommit (hibernatetransactionmanager. Java: 656)
At org. springframework. transaction. Support. abstractplatformtransactionmanager. processcommit (abstractplatformtransactionmanager. Java: 754)
At org. Apache. Coyote. http11.20.acthttp11processor. Process (abstracthttp11processor. Java: 1004)
At org. Apache. Coyote. abstractprotocol $ abstractconnectionhandler. Process (abstractprotocol. Java: 589)
At org.apache.tomcat.util.net. aprendpoint $ socketprocessor. Run (aprendpoint. Java: 1822)
At java. util. Concurrent. threadpoolexecutor $ worker. runtask (threadpoolexecutor. Java: 886)
At java. util. Concurrent. threadpoolexecutor $ worker. Run (threadpoolexecutor. Java: 908)
At java. Lang. thread. Run (thread. Java: 662)
Solution: the error means that the connection is automatically closed by proxool for some reasons. This situation is generally caused by the following reasons:
1. It may be because the database connection times out. For example, during debugging, a window remains for too long. (This error occurs when you search for a website created by Lucene ~)
2. Online statement:
<Proxool. minimumconnectioncount> 5 </proxool. minimumconnectioncount> // minimum number of connections
<Proxool. maximumconnectioncount> 150 </proxool. maximumconnectioncount> // maximum number of connections
<Proxool. simultaneousbuildthrottle> 20 </proxool. simultaneousbuildthrottle> // maximum number of simultaneous connections
The number of connections is sufficient, but the maximum number of connections is set to a smaller value. If the connection fails, an error is returned.
Reprinted please indicate: