记weblogic JDBC 'No operations allowed after statement closed' 缘由

最新推荐文章于 2025-09-18 15:44:54 发布

原创

最新推荐文章于 2025-09-18 15:44:54 发布 · 5.4k 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#jdbc #connection pool #java

在系统集成测试中，开发人员遇到由于数据库连接关闭导致的测试失败问题。尽管配置了连接池检查，但长时间未使用的连接在第二天测试时失效。原因可能是大量长时间无访问的连接在周期性检查时无法全部测试到，导致连接无效。此问题主要出现在测试环境中，解决方案未给出。

平台应用开发人员向我们平台报了一个issue，说在测试他们应用的时候遇到一个奇怪的问题，系统报了undefinedexception（开发人员自定义的exception，捕捉了jpa exception之后发现无法处理的情况下就抛出未定义异常），他们贴出了weblogic里面报出的异常栈信息：

<Sep 17, 2014 7:56:45 AM SAST> <Error> <org.hibernate.transaction.JDBCTransaction> <BEA-000000> <Could not toggle autocommit
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 33,177,390 milliseconds ago.  The last packet sent successfully to the server was 4 milliseconds ago.
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:395)
	Truncated. see log file for complete stacktrace

Caused By: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
	at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3052)
	at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3503)
	at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3492)
	at com.mysql.jdbc.MysqlIO.checkError

最低0.47元/天解锁文章