我的连接池是直接在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)
.........