56,677
社区成员
发帖
与我相关
我的任务
分享mysql链接问题
各位大神好！第一次请求帮帮忙。下面是问题描述：java程序每天从0点开始，每隔三小时跑一个批量，0点报错，3点正常，6点错误，9点正常，以此类推。服务器用的was，数据库链接用的是was数据源方式。mysql的wait_timeout=72小时。程序报错信息如下：
2017-11-19 00:00:00 26462930 INFO com.cdc.monitor.action.ConnectionLiveBatchJob - 任务：保持连接开始……
2017-11-19 00:00:00 26462947 INFO com.cdc.core.dao.JdbcTemplate - queryForInt(String): SELECT COUNT(ID) FROM MONITOR_CONF
2017-11-19 00:00:00 26462949 ERROR com.cdc.monitor.dao.ClientBatchJobDao - 2017-11-19 00:00:00.026调用ClientBatchJobDao的connectionLive方法出错：org.springframework.dao.DataAccessResourceFailureException: StatementCallback; SQL [ SELECT COUNT(ID) FROM MONITOR_CONF ]; Communications link failure
The last packet successfully received from the server was 10,799,717 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.; nested exception is com.ibm.websphere.ce.cm.StaleConnectionException: Communications link failure
The last packet successfully received from the server was 10,799,717 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.
2017-11-19 00:00:00 26462949 ERROR com.cdc.monitor.action.ConnectionLiveBatchJob - 保持连接失败!错误原因如下：
java.lang.RuntimeException: org.springframework.dao.DataAccessResourceFailureException: StatementCallback; SQL [ SELECT COUNT(ID) FROM MONITOR_CONF ]; Communications link failure
The last packet successfully received from the server was 10,799,717 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.; nested exception is com.ibm.websphere.ce.cm.StaleConnectionException: Communications link failure
The last packet successfully received from the server was 10,799,717 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.
at com.cdc.monitor.dao.ClientBatchJobDao.connectionLive(ClientBatchJobDao.java:34)
at com.cdc.monitor.dao.ClientBatchJobDao$$FastClassByCGLIB$$545a3a9b.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:617)
at com.cdc.monitor.dao.ClientBatchJobDao$$EnhancerByCGLIB$$661de0.connectionLive(<generated>)
at com.cdc.monitor.service.impl.JobServiceImpl.connectionLive(JobServiceImpl.java:79)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196)
at $Proxy113.connectionLive(Unknown Source)
at com.cdc.monitor.action.ConnectionLiveBatchJob.connLive(ConnectionLiveBatchJob.java:28)
at com.cdc.monitor.action.ConnectionLiveBatchJob$$FastClassByCGLIB$$bf9c9578.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:688)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:621)
at com.cdc.monitor.action.ConnectionLiveBatchJob$$EnhancerByCGLIB$$29e31a1b.connLive(<generated>)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:273)
at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:264)
at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:86)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525)
Caused by: org.springframework.dao.DataAccessResourceFailureException: StatementCallback; SQL [ SELECT COUNT(ID) FROM MONITOR_CONF ]; Communications link failure
The last packet successfully received from the server was 10,799,717 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.; nested exception is com.ibm.websphere.ce.cm.StaleConnectionException: Communications link failure
The last packet successfully received from the server was 10,799,717 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:104)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:406)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:455)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:463)
at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:471)
at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:476)
at org.springframework.jdbc.core.JdbcTemplate.queryForInt(JdbcTemplate.java:485)
at com.cdc.core.dao.JdbcTemplate.queryForInt(JdbcTemplate.java:32)
at com.cdc.monitor.dao.ClientBatchJobDao.connectionLive(ClientBatchJobDao.java:31)
... 32 more
Caused by: com.ibm.websphere.ce.cm.StaleConnectionException: Communications link failure
The last packet successfully received from the server was 10,799,717 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:56)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:39)
at java.lang.reflect.Constructor.newInstance(Constructor.java:527)
at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapExceptionHelper(GenericDataStoreHelper.java:607)
at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapException(GenericDataStoreHelper.java:666)
at com.ibm.ws.rsadapter.AdapterUtil.mapException(AdapterUtil.java:2271)
at com.ibm.ws.rsadapter.jdbc.WSJdbcUtil.mapException(WSJdbcUtil.java:1185)
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.executeQuery(WSJdbcStatement.java:1032)
at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:440)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:395)
... 39 more
2017-11-19 03:00:00 37262931 INFO com.cdc.monitor.action.ConnectionLiveBatchJob - 任务：保持连接开始……
2017-11-19 03:00:00 37262932 INFO com.cdc.core.dao.JdbcTemplate - queryForInt(String): SELECT COUNT(ID) FROM MONITOR_CONF
2017-11-19 03:00:00 37262987 INFO com.cdc.monitor.action.ConnectionLiveBatchJob - 任务：保持连接结束……
2017-11-19 00:00:00 26462930 INFO com.cdc.monitor.action.ConnectionLiveBatchJob - 任务：保持连接开始……
2017-11-19 00:00:00 26462947 INFO com.cdc.core.dao.JdbcTemplate - queryForInt(String): SELECT COUNT(ID) FROM MONITOR_CONF
2017-11-19 00:00:00 26462949 ERROR com.cdc.monitor.dao.ClientBatchJobDao - 2017-11-19 00:00:00.026调用ClientBatchJobDao的connectionLive方法出错：org.springframework.dao.DataAccessResourceFailureException: StatementCallback; SQL [ SELECT COUNT(ID) FROM MONITOR_CONF ]; Communications link failure
The last packet successfully received from the server was 10,799,717 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.; nested exception is com.ibm.websphere.ce.cm.StaleConnectionException: Communications link failure
The last packet successfully received from the server was 10,799,717 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.
2017-11-19 00:00:00 26462949 ERROR com.cdc.monitor.action.ConnectionLiveBatchJob - 保持连接失败!错误原因如下：
java.lang.RuntimeException: org.springframework.dao.DataAccessResourceFailureException: StatementCallback; SQL [ SELECT COUNT(ID) FROM MONITOR_CONF ]; Communications link failure
The last packet successfully received from the server was 10,799,717 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.; nested exception is com.ibm.websphere.ce.cm.StaleConnectionException: Communications link failure
The last packet successfully received from the server was 10,799,717 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.
at com.cdc.monitor.dao.ClientBatchJobDao.connectionLive(ClientBatchJobDao.java:34)
at com.cdc.monitor.dao.ClientBatchJobDao$$FastClassByCGLIB$$545a3a9b.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:617)
at com.cdc.monitor.dao.ClientBatchJobDao$$EnhancerByCGLIB$$661de0.connectionLive(<generated>)
at com.cdc.monitor.service.impl.JobServiceImpl.connectionLive(JobServiceImpl.java:79)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196)
at $Proxy113.connectionLive(Unknown Source)
at com.cdc.monitor.action.ConnectionLiveBatchJob.connLive(ConnectionLiveBatchJob.java:28)
at com.cdc.monitor.action.ConnectionLiveBatchJob$$FastClassByCGLIB$$bf9c9578.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:688)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:621)
at com.cdc.monitor.action.ConnectionLiveBatchJob$$EnhancerByCGLIB$$29e31a1b.connLive(<generated>)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:273)
at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:264)
at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:86)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525)
Caused by: org.springframework.dao.DataAccessResourceFailureException: StatementCallback; SQL [ SELECT COUNT(ID) FROM MONITOR_CONF ]; Communications link failure
The last packet successfully received from the server was 10,799,717 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.; nested exception is com.ibm.websphere.ce.cm.StaleConnectionException: Communications link failure
The last packet successfully received from the server was 10,799,717 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:104)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:406)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:455)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:463)
at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:471)
at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:476)
at org.springframework.jdbc.core.JdbcTemplate.queryForInt(JdbcTemplate.java:485)
at com.cdc.core.dao.JdbcTemplate.queryForInt(JdbcTemplate.java:32)
at com.cdc.monitor.dao.ClientBatchJobDao.connectionLive(ClientBatchJobDao.java:31)
... 32 more
Caused by: com.ibm.websphere.ce.cm.StaleConnectionException: Communications link failure
The last packet successfully received from the server was 10,799,717 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:56)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:39)
at java.lang.reflect.Constructor.newInstance(Constructor.java:527)
at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapExceptionHelper(GenericDataStoreHelper.java:607)
at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapException(GenericDataStoreHelper.java:666)
at com.ibm.ws.rsadapter.AdapterUtil.mapException(AdapterUtil.java:2271)
at com.ibm.ws.rsadapter.jdbc.WSJdbcUtil.mapException(WSJdbcUtil.java:1185)
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.executeQuery(WSJdbcStatement.java:1032)
at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:440)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:395)
... 39 more
2017-11-19 03:00:00 37262931 INFO com.cdc.monitor.action.ConnectionLiveBatchJob - 任务：保持连接开始……
2017-11-19 03:00:00 37262932 INFO com.cdc.core.dao.JdbcTemplate - queryForInt(String): SELECT COUNT(ID) FROM MONITOR_CONF
2017-11-19 03:00:00 37262987 INFO com.cdc.monitor.action.ConnectionLiveBatchJob - 任务：保持连接结束……
...全文
请发表友善的回复…
发表回复
阳泉酒家小当家 2017-11-30
- 打赏
- 举报
从报错信息也看不出是什么原因，能不能在执行任务之前，判断一下当前连接是否有效，有效的化就执行任务，无效的化，让程序重新初始化一个连接，在执行任务
