C3P0连接池异常处理

异常信息：

1. org.hibernate.exception.JDBCConnectionException: could not execute query
2. at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java: 74 )
3. at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java: 43 )
4. .......
5. Caused by: com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: No operations allowed after connection closed.Connection was implicitly closed due to underlying exception/error:
8. ** BEGIN NESTED EXCEPTION **
10. com.mysql.jdbc.CommunicationsException
11. MESSAGE: Communications link failure due to underlying exception:
13. ** BEGIN NESTED EXCEPTION **
15. java.net.SocketException
16. MESSAGE: Broken pipe
18. STACKTRACE:
20. java.net.SocketException: Broken pipe
21. at java.net.SocketOutputStream.socketWrite0(Native Method)
22. ......
23. ** END NESTED EXCEPTION **

 

处理方法:

 

C3P0增加以下配置信息:

1. //获取connnection时测试是否有效
2. testConnectionOnCheckin = true
3. //自动测试的table名称
   
4. automaticTestTable=C3P0TestTable
   
5. //set to something much less than wait_timeout, prevents connections from going stale
6. idleConnectionTestPeriod = 18000
7. //set to something slightly less than wait_timeout, preventing 'stale' connections from being handed out
8. maxIdleTime = 25000
9. //if you can take the performance 'hit', set to "true"
10. testConnectionOnCheckout = true