druid连接oracle 11G RAC，经常会报告java.net.SocketException: Connection reset

Question

@wenshao 你好，想跟你请教个问题：

我这边连接oracle rac的时候，经常报错2015-01-19 10:09:33.865 [DubboServerHandler-10.10.200.2:20100-thread-184] ERROR c.l.a.s.m.i.BookkeepingServiceImpl -AMS##10200044##OSX980496160572418_10200044##记账失败
org.springframework.dao.RecoverableDataAccessException:
### Error updating database.  Cause: java.sql.SQLRecoverableException: IO Error: Connection reset
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: update        ams.T_AMS_TRANS_ORDER      SET TD_STS=?,       STM_DT=?,        STM_BNO=?            where        UUID=?
### Cause: java.sql.SQLRecoverableException: IO Error: Connection reset
; SQL []; IO Error: Connection reset; nested exception is java.sql.SQLRecoverableException: IO Error: Connection reset
 at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:98) ~[SQLExceptionSubclassTranslator.class:4.0.7.RELEASE]
 at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) ~[AbstractFallbackSQLExceptionTranslator.class:4.0
.7.RELEASE]
 at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) ~[AbstractFallbackSQLExceptionTranslator.class:4.0
.7.RELEASE]
 at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73) ~[MyBatisExceptionTranslator.class:1.2.2]
 at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:371) ~[SqlSessionTemplate$SqlSessionInterceptor.class:1.2.2]
 at com.sun.proxy.$Proxy32.update(Unknown Source) ~[na:na]
 at org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:254) ~[SqlSessionTemplate.class:1.2.2]
 at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:49) ~[MapperMethod.class:3.2.5]
 at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:43) ~[MapperProxy.class:3.2.5]
 at com.suixingpay.common.utils.mybatis.GenericMapperProxy.invoke(GenericMapperProxy.java:43) ~[GenericMapperProxy.class:na]
 at com.suixingpay.common.utils.mybatis.TxMapperProxy.invoke(TxMapperProxy.java:42) ~[TxMapperProxy.class:na]
 at com.sun.proxy.$Proxy40.updateStatus(Unknown Source) ~[na:na]
 at com.lemon.ams.service.AmsNewTrServiceImpl.nTRUpdateTradeFlowStatus(AmsNewTrServiceImpl.java:474) ~[AmsNewTrServiceImpl.class:na]
 at com.lemon.ams.service.AmsNewTrServiceImpl$$FastClassBySpringCGLIB$$c1bc6d16.invoke(<generated>) ~[ReflectUtils.class:na]
 at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) [MethodProxy.class:4.0.7.RELEASE]
 at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:708) [CglibAopProxy$CglibMethodInvocation.class:4.0.5.RELEASE]
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) [ReflectiveMethodInvocation.class:4.0.5.RELEASE]
 at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:98) [TransactionInterceptor$1.class:4.0.7.RELEASE]
 at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:262) [TransactionAspectSupport.class:4.0.7.RELEASE]
 at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:95) [TransactionInterceptor.class:4.0.7.RELEASE]
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [ReflectiveMethodInvocation.class:4.0.5.RELEASE]
 at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) [ExposeInvocationInterceptor.class:4.0.5.RELEASE]
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [ReflectiveMethodInvocation.class:4.0.5.RELEASE]
 at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:644) [CglibAopProxy$DynamicAdvisedInterceptor.class:4.0.5.RELEASE]
 at com.lemon.ams.service.AmsNewTrServiceImpl$$EnhancerBySpringCGLIB$$4d8ff4cb.nTRUpdateTradeFlowStatus(<generated>) ~[ReflectUtils.class:na]
 at com.lemon.ams.service.mq.impl.BookkeepingServiceImpl.doTrade(BookkeepingServiceImpl.java:226) [BookkeepingServiceImpl.class:na]
 at com.lemon.ams.service.mq.impl.BookkeepingServiceImpl.AsyncBookkeeping(BookkeepingServiceImpl.java:110) [BookkeepingServiceImpl.class:na]
 at com.lemon.ams.service.mq.impl.BookkeepingServiceImpl$$FastClassBySpringCGLIB$$e249500d.invoke(<generated>) [ReflectUtils.class:na]
 at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) [MethodProxy.class:4.0.7.RELEASE]
 at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:708) [CglibAopProxy$CglibMethodInvocation.class:4.0.5.RELEASE]
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) [ReflectiveMethodInvocation.class:4.0.5.RELEASE]
 at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:98) [TransactionInterceptor$1.class:4.0.7.RELEASE]
 at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:262) [TransactionAspectSupport.class:4.0.7.RELEASE]
 at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:95) [TransactionInterceptor.class:4.0.7.RELEASE]
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [ReflectiveMethodInvocation.class:4.0.5.RELEASE]
 at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) [ExposeInvocationInterceptor.class:4.0.5.RELEASE]
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [ReflectiveMethodInvocation.class:4.0.5.RELEASE]
 at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:644) [CglibAopProxy$DynamicAdvisedInterceptor.class:4.0.5.RELEASE]
 at com.lemon.ams.service.mq.impl.BookkeepingServiceImpl$$EnhancerBySpringCGLIB$$7c2347e2.AsyncBookkeeping(<generated>) [ReflectUtils.class:na]
 at com.lemon.ams.biz.CommonBizImpl.bookkeeping(CommonBizImpl.java:55) [CommonBizImpl.class:na]
 at com.lemon.ams.biz.CommonBizImpl$$FastClassBySpringCGLIB$$1fa7679e.invoke(<generated>) [ReflectUtils.class:na]
 at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) [MethodProxy.class:4.0.7.RELEASE]
 at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:708) [CglibAopProxy$CglibMethodInvocation.class:4.0.5.RELEASE]
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) [ReflectiveMethodInvocation.class:4.0.5.RELEASE]
 at com.lemon.idemp.common.interceptor.IdempotentInterceptor.invoke(IdempotentInterceptor.java:96) [IdempotentInterceptor.class:na]
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [ReflectiveMethodInvocation.class:4.0.5.RELEASE]
 at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:644) [CglibAopProxy$DynamicAdvisedInterceptor.class:4.0.5.RELEASE]
 at com.lemon.ams.biz.CommonBizImpl$$EnhancerBySpringCGLIB$$d8b526ec.bookkeeping(<generated>) [ReflectUtils.class:na]
 at com.lemon.ams.dubbo.CommonDubboInterfaceImpl.bookKeeping(CommonDubboInterfaceImpl.java:466) [CommonDubboInterfaceImpl.class:na]
 at com.lemon.ams.dubbo.CommonDubboInterfaceImpl$$FastClassBySpringCGLIB$$cb2980a5.invoke(<generated>) [ReflectUtils.class:na]
 at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) [MethodProxy.class:4.0.7.RELEASE]
 at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:708) [CglibAopProxy$CglibMethodInvocation.class:4.0.5.RELEASE]
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) [ReflectiveMethodInvocation.class:4.0.5.RELEASE]
 at com.lemon.idemp.common.interceptor.IdempotentInterceptor.invoke(IdempotentInterceptor.java:61) [IdempotentInterceptor.class:na]
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [ReflectiveMethodInvocation.class:4.0.5.RELEASE]
 at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:644) [CglibAopProxy$DynamicAdvisedInterceptor.class:4.0.5.RELEASE]
 at com.lemon.ams.dubbo.CommonDubboInterfaceImpl$$EnhancerBySpringCGLIB$$f8cb7e13.bookKeeping(<generated>) [ReflectUtils.class:na]
 at com.lemon.ams.dubbo.CommonDubboInterfaceImpl$$FastClassBySpringCGLIB$$cb2980a5.invoke(<generated>) [ReflectUtils.class:na]
 at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) [MethodProxy.class:4.0.7.RELEASE]
 at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:708) [CglibAopProxy$CglibMethodInvocation.class:4.0.5.RELEASE]
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) [ReflectiveMethodInvocation.class:4.0.5.RELEASE]
 at com.lemon.validator.interceptor.ValidatorInterceptor.invoke(ValidatorInterceptor.java:70) [ValidatorInterceptor.class:na]
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [ReflectiveMethodInvocation.class:4.0.5.RELEASE]
 at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:644) [CglibAopProxy$DynamicAdvisedInterceptor.class:4.0.5.RELEASE]
 at com.lemon.ams.dubbo.CommonDubboInterfaceImpl$$EnhancerBySpringCGLIB$$42e5e70b.bookKeeping(<generated>) [ReflectUtils.class:na]
 at com.alibaba.dubbo.common.bytecode.Wrapper1.invokeMethod(Wrapper1.java) [na:2.5.3]
 at com.alibaba.dubbo.rpc.proxy.javassist.JavassistProxyFactory$1.doInvoke(JavassistProxyFactory.java:46) [JavassistProxyFactory$1.class:2.5.3]
 at com.alibaba.dubbo.rpc.proxy.AbstractProxyInvoker.invoke(AbstractProxyInvoker.java:72) [AbstractProxyInvoker.class:2.5.3]
 at com.alibaba.dubbo.rpc.protocol.InvokerWrapper.invoke(InvokerWrapper.java:53) [InvokerWrapper.class:2.5.3]
 at com.alibaba.dubbo.rpc.filter.ExceptionFilter.invoke(ExceptionFilter.java:64) [ExceptionFilter.class:2.5.3]
 at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) [ProtocolFilterWrapper$1.class:2.5.3]
 at com.alibaba.dubbo.monitor.support.MonitorFilter.invoke(MonitorFilter.java:75) [MonitorFilter.class:2.5.3]
 at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) [ProtocolFilterWrapper$1.class:2.5.3]
 at com.alibaba.dubbo.rpc.filter.TimeoutFilter.invoke(TimeoutFilter.java:42) [TimeoutFilter.class:2.5.3]
 at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) [ProtocolFilterWrapper$1.class:2.5.3]
 at com.alibaba.dubbo.rpc.protocol.dubbo.filter.TraceFilter.invoke(TraceFilter.java:78) [TraceFilter.class:2.5.3]
 at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) [ProtocolFilterWrapper$1.class:2.5.3]
 at com.alibaba.dubbo.rpc.filter.ExecuteLimitFilter.invoke(ExecuteLimitFilter.java:50) [ExecuteLimitFilter.class:2.5.3]
 at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) [ProtocolFilterWrapper$1.class:2.5.3]
 at com.alibaba.dubbo.rpc.filter.ContextFilter.invoke(ContextFilter.java:60) [ContextFilter.class:2.5.3]
 at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) [ProtocolFilterWrapper$1.class:2.5.3]
 at com.alibaba.dubbo.rpc.filter.GenericFilter.invoke(GenericFilter.java:112) [GenericFilter.class:2.5.3]
 at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) [ProtocolFilterWrapper$1.class:2.5.3]
 at com.alibaba.dubbo.rpc.filter.ClassLoaderFilter.invoke(ClassLoaderFilter.java:38) [ClassLoaderFilter.class:2.5.3]
 at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) [ProtocolFilterWrapper$1.class:2.5.3]
 at com.alibaba.dubbo.rpc.filter.EchoFilter.invoke(EchoFilter.java:38) [EchoFilter.class:2.5.3]
 at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) [ProtocolFilterWrapper$1.class:2.5.3]
 at com.alibaba.dubbo.rpc.protocol.dubbo.DubboProtocol$1.reply(DubboProtocol.java:108) [DubboProtocol$1.class:2.5.3]
 at com.alibaba.dubbo.remoting.exchange.support.header.HeaderExchangeHandler.handleRequest(HeaderExchangeHandler.java:84) [HeaderExchangeHandler.class:2.5.3]
 at com.alibaba.dubbo.remoting.exchange.support.header.HeaderExchangeHandler.received(HeaderExchangeHandler.java:170) [HeaderExchangeHandler.class:2.5.3]
 at com.alibaba.dubbo.remoting.transport.DecodeHandler.received(DecodeHandler.java:52) [DecodeHandler.class:2.5.3]
 at com.alibaba.dubbo.remoting.transport.dispatcher.ChannelEventRunnable.run(ChannelEventRunnable.java:82) [ChannelEventRunnable.class:2.5.3]
 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_25]
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_25]
 at java.lang.Thread.run(Thread.java:745) [na:1.8.0_25]
Caused by: java.sql.SQLRecoverableException: IO Error: Connection reset
 at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:967) ~[T4CPreparedStatement.class:12.1.0.1.0]
 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1075) ~[OracleStatement.class:12.1.0.1.0]
 at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3820) ~[OraclePreparedStatement.class:12.1.0.1.0]
 at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3923) ~[OraclePreparedStatement.class:12.1.0.1.0]
 at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1385) ~[OraclePreparedStatementWrapper.class:12.1.0.1.0]
 at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2931) ~[FilterChainImpl.class:1.0.5.1]
 at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440) ~[FilterEventAdapter.class:1.0.5.1]
 at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2929) ~[FilterChainImpl.class:1.0.5.1]
 at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:118) ~[PreparedStatementProxyImpl.class:1.0.5.1]
 at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:493) ~[DruidPooledPreparedStatement.class:1.0.5.1]
 at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:41) ~[PreparedStatementHandler.class:3.2.5]
 at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:66) ~[RoutingStatementHandler.class:3.2.5]
 at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:45) ~[SimpleExecutor.class:3.2.5]
 at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:100) ~[BaseExecutor.class:3.2.5]
 at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:75) ~[CachingExecutor.class:3.2.5]
 at sun.reflect.GeneratedMethodAccessor124.invoke(Unknown Source) ~[na:na]
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_25]
 at java.lang.reflect.Method.invoke(Method.java:483) ~[na:1.8.0_25]
 at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:46) ~[Invocation.class:3.2.5]
 at com.lemon.ams.common.lock.LockInterceptor.intercept(LockInterceptor.java:129) ~[LockInterceptor.class:na]
 at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:57) ~[Plugin.class:3.2.5]
 at com.sun.proxy.$Proxy63.update(Unknown Source) ~[na:na]
 at sun.reflect.GeneratedMethodAccessor124.invoke(Unknown Source) ~[na:na]
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_25]
 at java.lang.reflect.Method.invoke(Method.java:483) ~[na:1.8.0_25]
 at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:59) ~[Plugin.class:3.2.5]
 at com.sun.proxy.$Proxy63.update(Unknown Source) ~[na:na]
 at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:148) ~[DefaultSqlSession.class:3.2.5]
 at sun.reflect.GeneratedMethodAccessor275.invoke(Unknown Source) ~[na:na]
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_25]
 at java.lang.reflect.Method.invoke(Method.java:483) ~[na:1.8.0_25]
 at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:358) ~[SqlSessionTemplate$SqlSessionInterceptor.class:1.2.2]
 ... 90 common frames omitted
Caused by: java.net.SocketException: Connection reset
 at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:113) ~[na:1.8.0_25]
 at java.net.SocketOutputStream.write(SocketOutputStream.java:153) ~[na:1.8.0_25]
 at oracle.net.ns.DataPacket.send(DataPacket.java:209) ~[DataPacket.class:12.1.0.1.0]
 at oracle.net.ns.NetOutputStream.flush(NetOutputStream.java:215) ~[NetOutputStream.class:12.1.0.1.0]
 at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:302) ~[NetInputStream.class:12.1.0.1.0]
 at oracle.net.ns.NetInputStream.read(NetInputStream.java:249) ~[NetInputStream.class:12.1.0.1.0]
 at oracle.net.ns.NetInputStream.read(NetInputStream.java:171) ~[NetInputStream.class:12.1.0.1.0]
 at oracle.net.ns.NetInputStream.read(NetInputStream.java:89) ~[NetInputStream.class:12.1.0.1.0]
 at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:123) ~[T4CSocketInputStreamWrapper.class:12.1.0.1.0]
 at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:79) ~[T4CSocketInputStreamWrapper.class:12.1.0.1.0]
 at oracle.jdbc.driver.T4CMAREngineStream.unmarshalUB1(T4CMAREngineStream.java:426) ~[T4CMAREngineStream.class:12.1.0.1.0]
 at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:390) ~[T4CTTIfun.class:12.1.0.1.0]
 at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249) ~[T4CTTIfun.class:12.1.0.1.0]
 at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566) ~[T4C8Oall.class:12.1.0.1.0]
 at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215) ~[T4CPreparedStatement.class:12.1.0.1.0]
 at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:58) ~[T4CPreparedStatement.class:12.1.0.1.0]
 at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:943) ~[T4CPreparedStatement.class:12.1.0.1.0]
 ... 121 common frames omitted
2015-01-19 10:09:33.872 [DubboServerHandler-10.10.200.2:20100-thread-184] ERROR com.lemon.ams.biz.CommonBizImpl -交易失败
com.lemon.ams.common.exception.ServiceException: 记账失败
 at com.lemon.ams.service.mq.impl.BookkeepingServiceImpl.doTrade(BookkeepingServiceImpl.java:230) ~[BookkeepingServiceImpl.class:na]
 at com.lemon.ams.service.mq.impl.BookkeepingServiceImpl.AsyncBookkeeping(BookkeepingServiceImpl.java:110) ~[BookkeepingServiceImpl.class:na]
 at com.lemon.ams.service.mq.impl.BookkeepingServiceImpl$$FastClassBySpringCGLIB$$e249500d.invoke(<generated>) ~[ReflectUtils.class:na]
 at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) [MethodProxy.class:4.0.7.RELEASE]
 at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:708) [CglibAopProxy$CglibMethodInvocation.class:4.0.5.RELEASE]
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) [ReflectiveMethodInvocation.class:4.0.5.RELEASE]
 at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:98) ~[TransactionInterceptor$1.class:4.0.7.RELEASE]
 at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:262) ~[TransactionAspectSupport.class:4.0.7.RELEASE]
 at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:95) ~[TransactionInterceptor.class:4.0.7.RELEASE]
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [ReflectiveMethodInvocation.class:4.0.5.RELEASE]
 at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) ~[ExposeInvocationInterceptor.class:4.0.5.RELEASE]
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [ReflectiveMethodInvocation.class:4.0.5.RELEASE]
 at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:644) [CglibAopProxy$DynamicAdvisedInterceptor.class:4.0.5.RELEASE]
 at com.lemon.ams.service.mq.impl.BookkeepingServiceImpl$$EnhancerBySpringCGLIB$$7c2347e2.AsyncBookkeeping(<generated>) ~[ReflectUtils.class:na]
 at com.lemon.ams.biz.CommonBizImpl.bookkeeping(CommonBizImpl.java:55) ~[CommonBizImpl.class:na]
 at com.lemon.ams.biz.CommonBizImpl$$FastClassBySpringCGLIB$$1fa7679e.invoke(<generated>) [ReflectUtils.class:na]
 at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) [MethodProxy.class:4.0.7.RELEASE]
 at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:708) [CglibAopProxy$CglibMethodInvocation.class:4.0.5.RELEASE]
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) [ReflectiveMethodInvocation.class:4.0.5.RELEASE]
 at com.lemon.idemp.common.interceptor.IdempotentInterceptor.invoke(IdempotentInterceptor.java:96) [IdempotentInterceptor.class:na]
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [ReflectiveMethodInvocation.class:4.0.5.RELEASE]
 at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:644) [CglibAopProxy$DynamicAdvisedInterceptor.class:4.0.5.RELEASE]
 at com.lemon.ams.biz.CommonBizImpl$$EnhancerBySpringCGLIB$$d8b526ec.bookkeeping(<generated>) [ReflectUtils.class:na]
 at com.lemon.ams.dubbo.CommonDubboInterfaceImpl.bookKeeping(CommonDubboInterfaceImpl.java:466) [CommonDubboInterfaceImpl.class:na]
 at com.lemon.ams.dubbo.CommonDubboInterfaceImpl$$FastClassBySpringCGLIB$$cb2980a5.invoke(<generated>) [ReflectUtils.class:na]
 at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) [MethodProxy.class:4.0.7.RELEASE]
 at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:708) [CglibAopProxy$CglibMethodInvocation.class:4.0.5.RELEASE]
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) [ReflectiveMethodInvocation.class:4.0.5.RELEASE]
 at com.lemon.idemp.common.interceptor.IdempotentInterceptor.invoke(IdempotentInterceptor.java:61) [IdempotentInterceptor.class:na]
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [ReflectiveMethodInvocation.class:4.0.5.RELEASE]
 at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:644) [CglibAopProxy$DynamicAdvisedInterceptor.class:4.0.5.RELEASE]
 at com.lemon.ams.dubbo.CommonDubboInterfaceImpl$$EnhancerBySpringCGLIB$$f8cb7e13.bookKeeping(<generated>) [ReflectUtils.class:na]
 at com.lemon.ams.dubbo.CommonDubboInterfaceImpl$$FastClassBySpringCGLIB$$cb2980a5.invoke(<generated>) [ReflectUtils.class:na]
 at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) [MethodProxy.class:4.0.7.RELEASE]
 at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:708) [CglibAopProxy$CglibMethodInvocation.class:4.0.5.RELEASE]
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) [ReflectiveMethodInvocation.class:4.0.5.RELEASE]
 at com.lemon.validator.interceptor.ValidatorInterceptor.invoke(ValidatorInterceptor.java:70) [ValidatorInterceptor.class:na]
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [ReflectiveMethodInvocation.class:4.0.5.RELEASE]
 at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:644) [CglibAopProxy$DynamicAdvisedInterceptor.class:4.0.5.RELEASE]
 at com.lemon.ams.dubbo.CommonDubboInterfaceImpl$$EnhancerBySpringCGLIB$$42e5e70b.bookKeeping(<generated>) [ReflectUtils.class:na]
 at com.alibaba.dubbo.common.bytecode.Wrapper1.invokeMethod(Wrapper1.java) [na:2.5.3]
 at com.alibaba.dubbo.rpc.proxy.javassist.JavassistProxyFactory$1.doInvoke(JavassistProxyFactory.java:46) [JavassistProxyFactory$1.class:2.5.3]
 at com.alibaba.dubbo.rpc.proxy.AbstractProxyInvoker.invoke(AbstractProxyInvoker.java:72) [AbstractProxyInvoker.class:2.5.3]
 at com.alibaba.dubbo.rpc.protocol.InvokerWrapper.invoke(InvokerWrapper.java:53) [InvokerWrapper.class:2.5.3]
 at com.alibaba.dubbo.rpc.filter.ExceptionFilter.invoke(ExceptionFilter.java:64) [ExceptionFilter.class:2.5.3]
 at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) [ProtocolFilterWrapper$1.class:2.5.3]
 at com.alibaba.dubbo.monitor.support.MonitorFilter.invoke(MonitorFilter.java:75) [MonitorFilter.class:2.5.3]
 at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) [ProtocolFilterWrapper$1.class:2.5.3]
 at com.alibaba.dubbo.rpc.filter.TimeoutFilter.invoke(TimeoutFilter.java:42) [TimeoutFilter.class:2.5.3]
 at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) [ProtocolFilterWrapper$1.class:2.5.3]
 at com.alibaba.dubbo.rpc.protocol.dubbo.filter.TraceFilter.invoke(TraceFilter.java:78) [TraceFilter.class:2.5.3]
 at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) [ProtocolFilterWrapper$1.class:2.5.3]
 at com.alibaba.dubbo.rpc.filter.ExecuteLimitFilter.invoke(ExecuteLimitFilter.java:50) [ExecuteLimitFilter.class:2.5.3]
 at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) [ProtocolFilterWrapper$1.class:2.5.3]
 at com.alibaba.dubbo.rpc.filter.ContextFilter.invoke(ContextFilter.java:60) [ContextFilter.class:2.5.3]
 at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) [ProtocolFilterWrapper$1.class:2.5.3]
 at com.alibaba.dubbo.rpc.filter.GenericFilter.invoke(GenericFilter.java:112) [GenericFilter.class:2.5.3]
 at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) [ProtocolFilterWrapper$1.class:2.5.3]
 at com.alibaba.dubbo.rpc.filter.ClassLoaderFilter.invoke(ClassLoaderFilter.java:38) [ClassLoaderFilter.class:2.5.3]
 at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) [ProtocolFilterWrapper$1.class:2.5.3]
 at com.alibaba.dubbo.rpc.filter.EchoFilter.invoke(EchoFilter.java:38) [EchoFilter.class:2.5.3]
 at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) [ProtocolFilterWrapper$1.class:2.5.3]
 at com.alibaba.dubbo.rpc.protocol.dubbo.DubboProtocol$1.reply(DubboProtocol.java:108) [DubboProtocol$1.class:2.5.3]
 at com.alibaba.dubbo.remoting.exchange.support.header.HeaderExchangeHandler.handleRequest(HeaderExchangeHandler.java:84) [HeaderExchangeHandler.class:2.5.3]
 at com.alibaba.dubbo.remoting.exchange.support.header.HeaderExchangeHandler.received(HeaderExchangeHandler.java:170) [HeaderExchangeHandler.class:2.5.3]
 at com.alibaba.dubbo.remoting.transport.DecodeHandler.received(DecodeHandler.java:52) [DecodeHandler.class:2.5.3]
 at com.alibaba.dubbo.remoting.transport.dispatcher.ChannelEventRunnable.run(ChannelEventRunnable.java:82) [ChannelEventRunnable.class:2.5.3]
 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_25]
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_25]
 at java.lang.Thread.run(Thread.java:745) [na:1.8.0_25]

 

按照网上查找的修改，检查网络，没发现有问题，是我设置的有问题，还是其他方面有问题？

我的配置参数如下：

ds.ams.driver=oracle.jdbc.driver.OracleDriver
ds.ams.filters=stat
ds.ams.maxActive=350
ds.ams.initialSize=20
ds.ams.maxWait=90000
ds.ams.minIdle=10
ds.ams.timeBetweenEvictionRunsMillis=10000
ds.ams.minEvictableIdleTimeMillis=30000
ds.ams.validationQuery=SELECT 'x' from dual
ds.ams.testWhileIdle=true
ds.ams.testOnBorrow=false
ds.ams.testOnReturn=false
ds.ams.poolPreparedStatements=true
ds.ams.maxOpenPreparedStatements=100
ds.ams.decryptFlag=true
#u5bf9u4e8eu957fu65f6u95f4u4e0du4f7fu7528u7684u8fdeu63a5u5f3au5236u5173u95ed
ds.ams.removeAbandoned=true
#u8d85u8fc730u5206u949fu5f00u59cbu5173u95edu7a7au95f2u8fdeu63a5
ds.ams.removeAbandonedTimeout=1800
#u5c06u5f53u524du5173u95edu52a8u4f5cu8bb0u5f55u5230u65e5u5fd7
ds.ams.logAbandoned=true
哪位大神来给看看那啊

Answer 1

这个帖子应该可以解决你的问题：

https://blog.csdn.net/xichenguan/article/details/78916467

Answer 2

我也遇到同样的问题，我是这样解决的，
首先出现这样的问题原因是在一定的时候内没有获取到数据库连接，超时所导致的。
在tomcat 下的 catalina.sh
第一行添加 JAVA_OPTS="-Djava.security.egd=file:/dev/./urandom"
你可以试一试。

Answer 3

Solution:
1. Change the setup for your application, so you add the next parameter to the java command:
-Djava.security.egd=file:/dev/../dev/urandom

2. Update $JAVA_HOME/jre/lib/security/java.security, change the following line from:securerandom.source=file:/dev/urandomtosecurerandom.source=file:/dev/./urandom

我试试这个，是否能解决，没人理我啊，这个问题