weblogic连接池重置（Connection reset）问题解决方案(2)

日期：2020-06-02 栏目：程序人生浏览：次

####<2017-8-8 下午07时29分43秒 CST> <Info> <JDBC> <scyy1> <AdminServer> <pool-4514-thread-165> <<anonymous>> <> <> <1502191783427> <BEA-001156> <Stack trace associated with message 001129 follows:

java.sql.SQLRecoverableException: IO 错误: Connection reset

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:467)

at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)

at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)

at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)

at weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(ConnectionEnvFactory.java:357)

at weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(ConnectionEnvFactory.java:239)

at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1310)

at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1227)

at weblogic.common.resourcepool.ResourcePoolImpl.reserveResourceInternal(ResourcePoolImpl.java:451)

at weblogic.common.resourcepool.ResourcePoolImpl.reserveResource(ResourcePoolImpl.java:343)

at weblogic.common.resourcepool.ResourcePoolImpl.reserveResource(ResourcePoolImpl.java:330)

at weblogic.jdbc.common.internal.ConnectionPool.reserve(ConnectionPool.java:469)

at weblogic.jdbc.common.internal.ConnectionPool.reserve(ConnectionPool.java:363)

at weblogic.jdbc.common.internal.ConnectionPoolManager.reserve(ConnectionPoolManager.java:125)

at weblogic.jdbc.common.internal.ConnectionPoolManager.reserve(ConnectionPoolManager.java:158)

at weblogic.jdbc.pool.Driver.connect(Driver.java:132)

at weblogic.jdbc.jts.Driver.getNonTxConnection(Driver.java:658)

at weblogic.jdbc.jts.Driver.connect(Driver.java:127)

at weblogic.jdbc.common.internal.RmiDataSource.getConnectionInternal(RmiDataSource.java:533)

at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:498)

at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:491)

at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)

at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79)

at com.bocom.jump.bp.service.sqlmap.support.SqlSessionUtils.getSqlSession(SourceFile:116)

at com.bocom.jump.bp.service.sqlmap.impl.SqlMapImpl.a(SourceFile:56)

at com.bocom.jump.bp.service.sqlmap.impl.SqlMapImpl.a(SourceFile:67)

at com.bocom.jump.bp.service.sqlmap.impl.SqlMapImpl.queryForList(SourceFile:108)

at com.bocom.cams.core.base.commons.BaseDao.find(BaseDao.java:60)

at com.bocom.cams.core.base.commons.PersistableDao.findByBizKeys(PersistableDao.java:76)

at com.bocom.cams.core.base.commons.PersistableService.queryByBizKeys(PersistableService.java:192)

at com.bocom.cams.core.base.commons.PersistableService.getByBizKeysFromDataBase(PersistableService.java:321)

at com.bocom.cams.core.base.commons.PersistableService.getByBizKeys(PersistableService.java:223)

at com.bocom.cams.core.cd.calcandclearinterest.service.InterestCalculateService.calcTypeOfFixedtimeProductInts(InterestCalculateService.java:1388)

at com.bocom.cams.core.cd.calcandclearinterest.service.InterestCalculateService.interestCalculate(InterestCalculateService.java:371)

at com.bocom.cams.core.cd.calcandclearinterest.service.InterestCalculateService$3.toProcess(InterestCalculateService.java:2241)

at com.bocom.cams.core.base.commons.support.AsynchronousProcessor.run(AsynchronousProcessor.java:65)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)

at java.lang.Thread.run(Thread.java:662)

Caused By: java.net.SocketException: Connection reset

at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:96)

at java.net.SocketOutputStream.write(SocketOutputStream.java:136)

at oracle.net.ns.DataPacket.send(DataPacket.java:210)

at oracle.net.ns.NetOutputStream.flush(NetOutputStream.java:230)

at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:312)

at oracle.net.ns.NetInputStream.read(NetInputStream.java:260)

at oracle.net.ns.NetInputStream.read(NetInputStream.java:185)

at oracle.net.ns.NetInputStream.read(NetInputStream.java:102)

at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:124)

at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:80)

at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1137)

at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:290)

at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)

at oracle.jdbc.driver.T4CTTIoauthenticate.doOSESSKEY(T4CTTIoauthenticate.java:404)

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:385)