我的申请似乎在一夜之间遇到了异常。
我的环境是一个使用Tomcat的Java Web应用程序,用Java6编写并在MySQL上运行,使用Hibernate3连接到数据库(使用MySQL连接器5.0.3 - mysql-connector-java-5.0.3-bin.jar)
有一个预定的作业整夜运行(使用quartz作为调度程序),并且在凌晨3点运行时,在尝试访问数据库时会出现以下异常(注意,我已将堆栈跟踪的位重命名为“xxx”)是我工作的公司的内部代码):
03:00:00 ERROR bernate.transaction.JDBCTransaction: JDBC begin failed
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:1913)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2304)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2803)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3118)
at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:5215)
at org.apache.commons.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:331)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:317)
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:63)
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)
at xxx.HibernateSession.beginThreadTransaction(HibernateSession.java:75)
at xxx.HibernateSession.beginTransaction(HibernateSession.java:141)
at xxx.TestCaseManager.runAllTestsInBackground(TestCaseManager.java:228)
at xxx.scheduler.Job.execute(Job.java:42)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
** END NESTED EXCEPTION **
Last packet sent to the server was 0 ms ago.
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2803)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3118)
at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:5215)
at org.apache.commons.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:331)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:317)
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:63)
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)
at xxx.HibernateSession.beginThreadTransaction(HibernateSession.java:75)
at xxx.HibernateSession.beginTransaction(HibernateSession.java:141)
at xxx.TestCaseManager.runAllTestsInBackground(TestCaseManager.java:228)
at xxx.scheduler.Job.execute(Job.java:42)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
03:00:00 ERROR bernate.transaction.JDBCTransaction: JDBC begin failed
com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:
早上,当登录应用程序(也需要访问数据库)时,它给出了类似的异常,但等待大约 5 分钟并重试后,我们可以进入应用程序。
我已经检查了数据库,并且可以在它尝试连接的表上执行简单的 SELECT。任何帮助,将不胜感激。
您的 DBCP 连接池超时,请使用以下配置...
简单的解决方案是让 DBCP 在将连接提供给调用者之前验证连接。
将以下属性添加到您的 BasicDataSource 配置中:
<property name="testOnBorrow" value="true"/>
<property name="validationQuery" value="SELECT 1"/>
有关所有选项的列表,请参见此处:http://commons.apache.org/dbcp/configuration.html http://commons.apache.org/dbcp/configuration.html
编辑:
对于正在发生的事情的轻微修正,请参阅下面 MJB 的评论。
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)