druiddatasource卡住(druid close statement error)

druiddatasource卡住(druid close statement error)数据库 sqlserver 和 oracle 框架是 springmvc spring mybatis 框架配置 5 分钟一次自动执行任务 把 alibaba 的 druid 从 1 0 16 升级到 1 1 8 后 运行一段时间就出现下面异常 偶尔异常 oracle 数据库访问异常 2019 03 27 15 35 03 774 ERROR impl testImpl queryAll 40 Exception

数据库sqlserver和oracle ,框架是springmvc + spring +mybatis 框架配置5分钟一次自动执行任务,把alibaba 的 druid 从1.0.16升级到1.1.8后,运行一段时间就出现下面异常(偶尔异常):



oracle数据库访问异常:


2019-03-27 15:35:03,774 ERROR impl.testImpl.queryAll(40) - Exception


Error querying database. Cause: java.sql.SQLException: ORA-01013: ユーザーによって現行の操作の取消しがリクエストされました



sqlserver 数据库异常:


ERROR pool.DruidDataSource.handleFatalError(1595) - discard connection


java.sql.SQLException: I/O例外です。: Connection reset by peer: socket write error


at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)


at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)


at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)


at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:829)


at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1049)


at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:854)


at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1154)


at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)


at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3476)


at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:498)


at sun.reflect.GeneratedMethodAccessor81.invoke(Unknown Source)


at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)


at java.lang.reflect.Method.invoke(Method.java:498)


at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)


at com.sun.proxy.$Proxy61.execute(Unknown Source)


at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:62)


at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:78)


at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)


at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:303)


at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:154)


at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:102)


at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:82)


at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:120)


at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:113)


at sun.reflect.GeneratedMethodAccessor79.invoke(Unknown Source)


at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)


at java.lang.reflect.Method.invoke(Method.java:498)


at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:408)


at com.sun.proxy.$Proxy11.selectList(Unknown Source)




<task:annotation-driven/>


<task:scheduled-tasks>


<task:scheduled ref="testController" method="testMakeDate" cron="0 0/5 * * * ?"/>


</task:scheduled-tasks>



<dependency>


<groupId>com.alibaba</groupId>


<artifactId>druid</artifactId>


<version>1.1.8</version>


</dependency>



今天的文章 druiddatasource卡住(druid close statement error)分享到此就结束了,感谢您的阅读。


















































编程小号
上一篇 2025-12-06 18:40
下一篇 2025-03-26 20:01

相关推荐

版权声明:本文内容由互联网用户自发贡献,该文观点仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 举报,一经查实,本站将立刻删除。
如需转载请保留出处:https://bianchenghao.cn/bian-cheng-ri-ji/27440.html