当前位置:编程学习 > JAVA >>

Software caused connection abort: recv failed

各位,我测试数据的时候,出现Software caused connection abort: recv failed错误,一共要同步4个表,前面3个用这个方法成功了(数据量较少),最后一个(同步的数据量较大)报了以下错误。是什么情况??


连接池连接数信息:initNum=1;minNum=1;maxNum=5
连接池时间信息:defaultWaitTime=1000;defaultUseTime=300000;maxIdleTime=600000;detectCycleTime=60000
Create ThreadPool:Db Connect Pool[13086732] Detect Thread
开始同步
t_znzx_studentinfo的FLOW_CODE集合:1727323
source_exchange_sql=:select FLOW_CODE from t_znzx_studentinfo_mod where exchange_time>=to_date('2013-08-25  14:09:33','yyyy-mm-dd hh24:mi:ss')
t_znzx_studentinfo_mod最近一天有过修改的数量:31471
t_znzx_studentinfodelete_sql:delete from t_znzx_studentinfo where FLOW_CODE=?
t_znzx_studentinfocolNameList6.size():31469
java.sql.SQLException: Io 异常: Software caused connection abort: recv failed
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:335)
at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:503)
at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:518)
at oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:210)
at oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:193)
at oracle.jdbc.driver.OracleConnection.privatePrepareStatement(OracleConnection.java:869)
at oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:704)
at com.fleety.util.pool.db.DbConnPool$DbHandle.prepareStatement(DbConnPool.java:856)
at com.fleety.plugins.JiaPeiInfoSynchronizeAction_All.SyncJiapei(JiaPeiInfoSynchronizeAction_All.java:180)
at com.fleety.plugins.SyncByHand.main(SyncByHand.java:23)
delete from t_znzx_studentinfo where FLOW_CODE=?
有连接断开,将重连!21905217 jdbc:oracle:thin:@172.17.1.45:1521:orcl1
java.sql.SQLException: Io 异常: Software caused connection abort: socket write error
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:335)
at oracle.jdbc.driver.OracleConnection.close(OracleConnection.java:1256)
at com.fleety.util.pool.db.DbConnPool$DbInfo.close(DbConnPool.java:713)
at com.fleety.util.pool.db.DbConnPool$DbInfo.updateConn(DbConnPool.java:693)
at com.fleety.util.pool.db.DbConnPool.updateConn(DbConnPool.java:291)
at com.fleety.util.pool.db.DbConnPool.access$2(DbConnPool.java:282)
at com.fleety.util.pool.db.DbConnPool$DbHandle.prepareStatement(DbConnPool.java:860)
at com.fleety.plugins.JiaPeiInfoSynchronizeAction_All.SyncJiapei(JiaPeiInfoSynchronizeAction_All.java:180)
at com.fleety.plugins.SyncByHand.main(SyncByHand.java:23) oracle 同步数据  在线等 --------------------编程问答-------------------- 顶帖。。。。。。。。。。。。。。
补充:Java ,  Java SE
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,