2025年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

大家好,我是讯享网,很高兴认识大家。

数据库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)<br /> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)<br /> at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:829)<br /> at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1049)<br /> at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:854)<br /> at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1154)<br /> at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)<br /> at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3476)<br /> at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:498)<br /> at sun.reflect.GeneratedMethodAccessor81.invoke(Unknown Source)<br /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br /> at java.lang.reflect.Method.invoke(Method.java:498)<br /> at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)<br /> at com.sun.proxy.$Proxy61.execute(Unknown Source)<br /> at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:62)<br /> at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:78)<br /> at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)<br /> at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:303)<br /> at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:154)<br /> at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:102)<br /> at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:82)<br /> at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:120)<br /> at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:113)<br /> at sun.reflect.GeneratedMethodAccessor79.invoke(Unknown Source)<br /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br /> at java.lang.reflect.Method.invoke(Method.java:498)<br /> at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:408)<br /> at com.sun.proxy.$Proxy11.selectList(Unknown Source)<br /> 

讯享网



&lt;task:annotation-driven/&gt;


讯享网

讯享网&lt;task:scheduled-tasks&gt;<br /> &lt;task:scheduled ref&#61;&#34;testController&#34; method&#61;&#34;testMakeDate&#34; cron&#61;&#34;0 0/5 * * * ?&#34;/&gt;<br /> &lt;/task:scheduled-tasks&gt;<br /> 


&lt;dependency&gt;

 &lt;groupId&gt;com.alibaba&lt;/groupId&gt;<br /> &lt;artifactId&gt;druid&lt;/artifactId&gt;<br /> &lt;version&gt;1.1.8&lt;/version&gt;<br /> 

&lt;/dependency&gt;

小讯
上一篇 2025-06-05 19:18
下一篇 2025-05-23 19:46

相关推荐

版权声明:本文内容由互联网用户自发贡献,该文观点仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容,请联系我们,一经查实,本站将立刻删除。
如需转载请保留出处:https://51itzy.com/kjqy/206719.html