Couldn't perform the operation setautocommit: You can't perform any operations on this c

Source: Internet
Author: User

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:

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.