线程往数据库里插数据时偶尔会报错
16lz
2021-01-22
org.springframework.jdbc.UncategorizedSQLException:Hibernateflushing:CouldnotexecuteJDBCbatchupdate;uncategorizedSQLExceptionforSQL[insertintoSPC.MCEVENT_T(LINEMCID,EVENTDATE,EVENTCODE,MAIN_MSG,SUB_MSG)values(?,?,?,?,?)];SQLstate[null];errorcode[17002];Ioexception:Connectionresetbypeer:socketwriteerror;nestedexceptionisjava.sql.BatchUpdateException:Ioexception:Connectionresetbypeer:socketwriteerror
atorg.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
atorg.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
atorg.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
atorg.springframework.orm.hibernate3.HibernateTransactionManager.convertJdbcAccessException(HibernateTransactionManager.java:801)
atorg.springframework.orm.hibernate3.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:787)
atorg.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:663)
atorg.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:732)
atorg.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:701)
atorg.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321)
atorg.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116)
atorg.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
atorg.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
atorg.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
atorg.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
atcom.sun.proxy.$Proxy3.save(UnknownSource)
atserviceImpl.McEventServiceImpl.save(McEventServiceImpl.java:26)
atserviceImpl.McEventServiceImpl.saveAll(McEventServiceImpl.java:19)
atwatchtool.Watcher.run(Watcher.java:87)
atjava.util.concurrent.ThreadPoolExecutor.runWorker(UnknownSource)
atjava.util.concurrent.ThreadPoolExecutor$Worker.run(UnknownSource)
atjava.lang.Thread.run(UnknownSource)
Causedby:java.sql.BatchUpdateException:Ioexception:Connectionresetbypeer:socketwriteerror
atoracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
atoracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10656)
atorg.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
atorg.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
atorg.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
atorg.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
atorg.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
atorg.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
atorg.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
atorg.hibernate.impl.SessionImpl.flush(SessionImpl.java:1028)
atorg.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:366)
atorg.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)
atorg.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:655)
...15more
上面是异常报告，百度了一下发现有的帖子说是oracle的配置问题有的说是sql语句问题但是相同的程序放到别的机子上跑也不会报错...有点奇怪求大神们帮忙看看我用了Spring和hibernate
C3P0连接池中有没有配置maximum-active-time，配置了的话把这个值加大
atorg.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
atorg.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
atorg.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
atorg.springframework.orm.hibernate3.HibernateTransactionManager.convertJdbcAccessException(HibernateTransactionManager.java:801)
atorg.springframework.orm.hibernate3.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:787)
atorg.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:663)
atorg.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:732)
atorg.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:701)
atorg.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321)
atorg.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116)
atorg.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
atorg.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
atorg.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
atorg.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
atcom.sun.proxy.$Proxy3.save(UnknownSource)
atserviceImpl.McEventServiceImpl.save(McEventServiceImpl.java:26)
atserviceImpl.McEventServiceImpl.saveAll(McEventServiceImpl.java:19)
atwatchtool.Watcher.run(Watcher.java:87)
atjava.util.concurrent.ThreadPoolExecutor.runWorker(UnknownSource)
atjava.util.concurrent.ThreadPoolExecutor$Worker.run(UnknownSource)
atjava.lang.Thread.run(UnknownSource)
Causedby:java.sql.BatchUpdateException:Ioexception:Connectionresetbypeer:socketwriteerror
atoracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
atoracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10656)
atorg.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
atorg.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
atorg.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
atorg.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
atorg.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
atorg.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
atorg.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
atorg.hibernate.impl.SessionImpl.flush(SessionImpl.java:1028)
atorg.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:366)
atorg.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)
atorg.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:655)
...15more
上面是异常报告，百度了一下发现有的帖子说是oracle的配置问题有的说是sql语句问题但是相同的程序放到别的机子上跑也不会报错...有点奇怪求大神们帮忙看看我用了Spring和hibernate
5 个解决方案
#1
C3P0连接池中有没有配置maximum-active-time，配置了的话把这个值加大
更多相关文章
- 大神求解，hibernate4.2.1的一个HelloWorld例子配置搞了两天
- 求android大神指点
- 在java自动生成hashCode代码问题？ 请大神赐教
- javafx 和netty 混合使用出现线程不一致问题，求大神指点
- mvn依赖的jar，在项目中无法引用，求大神指点啊
- java中两个事物，怎么设置，能让一个事物出现异常，另一个也回滚？哪位大