MySQL Forums
Forum List  »  Connector/J, JDBC and Java

Advanced Search
New Topic

Re: Hanging threads on com.mysql.jdbc.ConnectionImpl.setAutoCommit
Posted by: Filipe Silva
Date: May 16, 2018 11:52AM

This looks like socket glitches. Somehow the socket gets disconnected in one side without notifying the other.

My advice would be to:

1. Check if you are using the connection porperty 'tcpKeepAlive=false'.

2. Try different values for connection property 'socketTimeout'.

3. Analyze sockets state when this occurs (both in client and server).

4. Try to tweak c3p0 connection validation timeout.

IHTH

Navigate: Previous Message• Next Message
Options: Reply• Quote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.