java断开管道异常,Io 异常: 断开的管道 和 Io 异常: Connection reset

本帖最后由 wangluochongzi 于 2015-12-15 16:14 编辑

程序访问数据库【写库】过程中，会偶尔出现IO 异常报错如下：oracle 11.2.0.4 RAC1、

java.sql.SQLException:Io 异常: 断开的管道

atoracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)

atoracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334)

atoracle.jdbc.driver.OracleStatement.close(OracleStatement.java:704)

atoracle.jdbc.driver.OraclePreparedStatement.privateClose(OraclePreparedStatement.java:489)

atoracle.jdbc.driver.OraclePreparedStatement.close(OraclePreparedStatement.java:396)

atcn.cheering.createuid.util.DBUtil.Insert2ActionData(DBUtil.java:255)

atcn.cheering.createuid.util.FileUtil.readZipFile(FileUtil.java:188)

atcn.cheering.createuid.util.FileUtil.getFileList(FileUtil.java:119)

atcn.cheering.createuid.service.ProcessService.start(ProcessService.java:54)

at sun.reflect.GeneratedMethodAccessor22.invoke(UnknownSource)

atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

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

atorg.springframework.util.MethodInvoker.invoke(MethodInvoker.java:273)

atorg.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:311)

atorg.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:113)

atorg.quartz.core.JobRunShell.run(JobRunShell.java:202)

atorg.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525)

2、

java.sql.BatchUpdateException:Io异常: Connection reset

atoracle.jdbc.dbaccess.DBError.throwBatchUpdateException(DBError.java:459)

atoracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:4133)

at cn.cheering.createuid.util.DBUtil.Insert2ActionData(DBUtil.java:247)

atcn.cheering.createuid.util.FileUtil.readZipFile(FileUtil.java:188)

atcn.cheering.createuid.util.FileUtil.getFileList(FileUtil.java:119)

at cn.cheering.createuid.service.ProcessService.start(ProcessService.java:54)

at sun.reflect.GeneratedMethodAccessor22.invoke(UnknownSource)

atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

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

atorg.springframework.util.MethodInvoker.invoke(MethodInvoker.java:273)

atorg.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:311)

at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:113)

atorg.quartz.core.JobRunShell.run(JobRunShell.java:202)

atorg.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525)

麻烦各位大侠支持下