mysql tomcat jdbc 连接池 8小时_Tomcat5.5连接池配置8小时断开问题

我的连接池是直接在META-INF\目录下新建context.xml中配置的,

auth="Container"

name="jdbc/kml"

type="javax.sql.DataSource"

url="jdbc:mysql://127.0.0.1:3306/mytest?autoReconnect=true&characterEncoding=gbk"

driverClassName="com.mysql.jdbc.Driver"

username="root"

password="root"

maxActive="28"

maxIdle="5"

maxWait="10000"

reconnect="true"

logAbandoned="true"

removeAbandonedTimeout="60"

/>

现在出现了8小时自动断开的问题,请问是不是我的配置问题,如何解决?谢谢!

报错信息如下:

com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.io.EOFException

STACKTRACE:

java.io.EOFException

at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1842)

at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2288)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2784)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)

at com.mysql.jdbc.Connection.execSQL(Connection.java:2370)

at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:525)

at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:331)

at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:317)

.........


版权声明:本文为weixin_32520565原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。