高手一定要帮忙啊。。。关于数据库连接问题

org.springframework.dao.DataAccessResourceFailureException: StatementCallback; SQL [select * from T_MOBILE_INFO order by id]; I/O Error: Connection reset; ne
sted exception is java.sql.SQLException: I/O Error: Connection reset
Caused by: java.sql.SQLException: I/O Error: Connection reset
        at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1049)
        at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:406)
        at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1258)
        at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205)
        at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:389)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:342)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:404)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:412)
        at cn.com.jrj.g.service.suit.MobileSuitMobileInfoService.getAllMobileInfo(MobileSuitMobileInfoService.java:51)
        at cn.com.jrj.g.service.suit.MobileSuitMobileInfoService$$FastClassByCGLIB$$26f77311.invoke(<generated>)
        at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
        at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:695)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
        at cn.com.jrj.g.base.db.CustomerRoutingDataSourceInterceptor.invoke(CustomerRoutingDataSourceInterceptor.java:20)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
        at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:630)
        at cn.com.jrj.g.service.suit.MobileSuitMobileInfoService$$EnhancerByCGLIB$$29fbe6d9.getAllMobileInfo(<generated>)
        at cn.com.jrj.g.job.suit.MobileXMLWork.executeInternal(MobileXMLWork.java:107)
        at cn.com.jrj.g.base.work.gAppWork.execute(gAppWork.java:39)
        at cn.com.jrj.g.base.work.gAppRunnable.run(gAppRunnable.java:19)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
        at java.lang.Thread.run(Thread.java:619)
Caused by: java.net.SocketException: Connection reset
        at java.net.SocketInputStream.read(SocketInputStream.java:168)
        at java.io.DataInputStream.readFully(DataInputStream.java:178)
        at java.io.DataInputStream.readFully(DataInputStream.java:152)
        at net.sourceforge.jtds.jdbc.SharedSocket.readPacket(SharedSocket.java:826)

谁有办法解决掉这个异常啊。

我同时跑了5个job 每一分钟 执行一次。

Spring 的db 配置 也都加了 连接验证。

为什么会出现这个异常呢。

有什么办法可以解决掉呢?

转载于:https://my.oschina.net/douxia/blog/10892

  • 0
    点赞
  • 0
    评论
  • 0
    收藏
  • 扫一扫,分享海报

表情包
插入表情
评论将由博主筛选后显示,对所有人可见 | 还能输入1000个字符
©️2022 CSDN 皮肤主题:编程工作室 设计师:CSDN官方博客 返回首页
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、C币套餐、付费专栏及课程。

余额充值