java.sql.BatchUpdateException: Io 异常: Software caused connection abort: recv fai

最新推荐文章于 2022-08-02 19:10:31 发布

原创最新推荐文章于 2022-08-02 19:10:31 发布 · 1.1k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#java #数据库

本文记录了一次在使用Oracle数据库进行批量更新操作时遇到的异常情况，包括Software caused connection abort错误、关闭的连接异常及连接释放失败等问题，并详细展示了异常堆栈跟踪。

2012-07-26 10:35:40,085 ERROR com.sitech.core.architecture.log.logstat.format.AccessBatchSqlFormatter -
java.sql.BatchUpdateException: Io 异常: Software caused connection abort: recv failed
at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10656)
at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
at com.sitech.core.architecture.log.logstat.format.AccessBatchSqlFormatter.write(AccessBatchSqlFormatter.java:72)
at com.sitech.core.architecture.log.logstat.thread.InfoWriter.run(InfoWriter.java:49)
at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:748)
at java.lang.Thread.run(Thread.java:619)
2012-07-26 10:35:40,086 ERROR com.sitech.core.architecture.log.logstat.format.AccessBatchSqlFormatter -
java.sql.SQLException: 关闭的连接
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:208)
at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:1133)
at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:328)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:312)
at com.sitech.core.architecture.log.logstat.format.AccessBatchSqlFormatter.write(AccessBatchSqlFormatter.java:85)
at com.sitech.core.architecture.log.logstat.thread.InfoWriter.run(InfoWriter.java:49)
at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:748)
at java.lang.Thread.run(Thread.java:619)
2012-07-26 10:35:40,087 ERROR com.sitech.core.architecture.log.logstat.format.AccessBatchSqlFormatter - 连接释放失败
java.sql.SQLException: Already closed.
at org.apache.commons.dbcp.PoolableConnection.close(PoolableConnection.java:84)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:181)
at com.sitech.core.architecture.log.logstat.format.AccessBatchSqlFormatter.write(AccessBatchSqlFormatter.java:98)
at com.sitech.core.architecture.log.logstat.thread.InfoWriter.run(InfoWriter.java:49)
at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:748)
at java.lang.Thread.run(Thread.java:619)