Druid连接,事务控制开启,commit的时候报connection holder is null
时间: 2016-03-15来源:开源中国
前景提要
具体报错信息:
java.sql.SQLException: connection holder is null
at com.alibaba.druid.pool.DruidPooledConnection.checkState(DruidPooledConnection.java:1090) ~[druid-1.0.11.jar:1.0.11]
at com.alibaba.druid.pool.DruidPooledConnection.commit(DruidPooledConnection.java:712) ~[druid-1.0.11.jar:1.0.11]
at com.zr.dataservice.server.db.DBbean.WithTransactionReturn(DBbean.java:168) [JGDataServer_Lab.jar:?]
at com.zr.dataservice.server.job.LabDataLoaderJob$1.run(LabDataLoaderJob.java:152) [JGDataServer_Lab.jar:?]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_71]
at java.util.concurrent.FutureTask.runAndReset(Unknown Source) [?:1.8.0_71]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(Unknown Source) [?:1.8.0_71]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source) [?:1.8.0_71]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_71]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_71]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_71]
Caused by: java.sql.BatchUpdateException: ORA-03106: 致命的双工通信协议错误

at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10070) ~[ojdbc6-11.jar:11.2.0.1.0]
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:213) ~[ojdbc6-11.jar:11.2.0.1.0]
at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeBatch(DruidPooledPreparedStatement.java:559) ~[druid-1.0.11.jar:1.0.11]
at com.zr.dataservice.server.service.lab.LabDAO.executeAndCommit(LabDAO.java:250) ~[JGDataServer_Lab.jar:?]
at com.zr.dataservice.server.service.lab.LabDAO.batchInsert(LabDAO.java:222) ~[JGDataServer_Lab.jar:?]
at com.zr.dataservice.server.service.lab.ProcessLoader.loadBatch(ProcessLoader.java:47) ~[JGDataServer_Lab.jar:?]
at com.zr.dataservice.server.job.LabDataLoaderJob$1.lambda$0(LabDataLoaderJob.java:153) ~[JGDataServer_Lab.jar:?]
at com.zr.dataservice.server.db.DBbean.WithTransactionReturn(DBbean.java:167) ~[JGDataServer_Lab.jar:?]
... 8 more
Druid的版本是1.0.11,配置是这样
<driverClassName>oracle.jdbc.driver.OracleDriver</driverClassName>
<initialSize>6</initialSize>
<MaxActive>6</MaxActive>
<maxWait>6</maxWait>
<validateQuery>select 1 from dual</validateQuery>
<removeAbandoned>false</removeAbandoned>
<removeAbandonedTimeout>1800</removeAbandonedTimeout>
具体业务就是在一个preparestatment执行exeuteBatch()之后,执行commit就报上面错误,哪位大神可以指点一二

科技资讯:

科技学院:

科技百科:

科技书籍:

网站大全:

软件大全:

热门排行