websphere 配置mysql连接池总是出现连接超时

zhaoshe 2016-03-10 08:37:47

com.ibm.websphere.ce.cm.StaleConnectionException: Communications link failure

The last packet successfully received from the server was 370,819 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:56)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:39)
at java.lang.reflect.Constructor.newInstance(Constructor.java:527)
at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapExceptionHelper(GenericDataStoreHelper.java:626)
at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapException(GenericDataStoreHelper.java:685)
at com.ibm.ws.rsadapter.AdapterUtil.mapException(AdapterUtil.java:2267)
at com.ibm.ws.rsadapter.jdbc.WSJdbcUtil.mapException(WSJdbcUtil.java:1191)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.setAutoCommit(WSJdbcConnection.java:3547)
at com.icsc.dpms.de.sql.dejc301c.setAutoCommit(dejc301c.java:773)
at com.icsc.dpms.de.dejc301.toGetConnection(dejc301.java:682)
at com.icsc.dpms.de.dejc301.toTransaction(dejc301.java:630)
at com.icsc.dpms.de.dejc301.getConnection(dejc301.java:241)
at com.icsc.ums.util.umscDBConn.getConnection(umscDBConn.java:50)
at com.icsc.ums.api.umscApi.sendSm(umscApi.java:52)
at com.icsc.ums.api.umscApi.sendSm(umscApi.java:128)
at com.icsc.sh.di.shjcLoadSHFMER03.sendMessage(shjcLoadSHFMER03.java:1267)
at com.icsc.sh.di.shjcLoadSHFMER03.doSH56VONew(shjcLoadSHFMER03.java:782)
at com.icsc.sh.di.shjcLoadSHFMER03.loadFMSH32(shjcLoadSHFMER03.java:223)
at com.icsc.sh.di.shjcLoadSHFMER03.parseLogic(shjcLoadSHFMER03.java:181)
at com.icsc.zwp.api.zwpcQueueRec02Handler.process(zwpcQueueRec02Handler.java:148)
at com.icsc.zwp.api.zwpcQueueRec02Handler.receiveData(zwpcQueueRec02Handler.java:100)
at com.icsc.sh.di.shjcLoadSHFMER03.xctl(shjcLoadSHFMER03.java:118)
at sun.reflect.GeneratedMethodAccessor9202.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at bsh.Reflect.invokeMethod(Unknown Source)
at bsh.Reflect.invokeObjectMethod(Unknown Source)
at bsh.Name.invokeMethod(Unknown Source)
at bsh.BSHMethodInvocation.eval(Unknown Source)
at bsh.BSHPrimaryExpression.eval(Unknown Source)
at bsh.BSHPrimaryExpression.eval(Unknown Source)
at bsh.BSHBlock.evalBlock(Unknown Source)
at bsh.BSHBlock.eval(Unknown Source)
at bsh.BSHBlock.eval(Unknown Source)
at bsh.BSHTryStatement.eval(Unknown Source)
at bsh.BSHBlock.evalBlock(Unknown Source)
at bsh.BSHBlock.eval(Unknown Source)
at bsh.BSHBlock.eval(Unknown Source)
at bsh.BSHTryStatement.eval(Unknown Source)
at bsh.Interpreter.eval(Unknown Source)
at bsh.Interpreter.eval(Unknown Source)
at bsh.Interpreter.eval(Unknown Source)
at org.rmi.client.BeanShellUtils.exec(BeanShellUtils.java:57)
at org.rmi.client.InstanceWorker.execute(InstanceWorker.java:84)
at sun.reflect.GeneratedMethodAccessor6427.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:320)
at sun.rmi.transport.Transport$1.run(Transport.java:171)
at java.security.AccessController.doPrivileged(AccessController.java:365)
at sun.rmi.transport.Transport.serviceCall(Transport.java:167)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:547)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:802)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:661)
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:784)

2016/03/09 01:05:31.108 SQLException: com.ibm.websphere.ce.cm.StaleConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up. DSRA0010E: SQL 状态：08001，错误码：0。
com.ibm.websphere.ce.cm.StaleConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up. DSRA0010E: SQL 状态：08001，错误码：0。
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:56)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:39)
at java.lang.reflect.Constructor.newInstance(Constructor.java:527)
at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapExceptionHelper(GenericDataStoreHelper.java:626)
at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapException(GenericDataStoreHelper.java:685)
at com.ibm.ws.rsadapter.AdapterUtil.mapException(AdapterUtil.java:2267)
at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSource.java:2145)
at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.getConnection(WSManagedConnectionFactoryImpl.java:1781)
at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:1551)
at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:1107)
at com.ibm.ejs.j2c.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:2160)
at com.ibm.ejs.j2c.FreePool.createOrWaitForConnection(FreePool.java:1838)
at com.ibm.ejs.j2c.PoolManager.reserve(PoolManager.java:3816)
at com.ibm.ejs.j2c.PoolManager.reserve(PoolManager.java:3092)
at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:1548)
at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:1031)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:644)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:611)
at com.icsc.dpms.de.dejc301.toGetConnection(dejc301.java:671)
at com.icsc.dpms.de.dejc301.toTransaction(dejc301.java:630)
at com.icsc.dpms.de.dejc301.getConnection(dejc301.java:241)
at com.icsc.ums.util.umscDBConn.getConnection(umscDBConn.java:50)
at com.icsc.ums.api.umscApi.sendSm(umscApi.java:52)
at com.icsc.ums.api.umscApi.sendSm(umscApi.java:128)
at com.icsc.sh.di.shjcLoadSHFMER03.sendMessage(shjcLoadSHFMER03.java:1268)
at com.icsc.sh.di.shjcLoadSHFMER03.doSH56VONew(shjcLoadSHFMER03.java:782)
at com.icsc.sh.di.shjcLoadSHFMER03.loadFMSH32(shjcLoadSHFMER03.java:223)
at com.icsc.sh.di.shjcLoadSHFMER03.parseLogic(shjcLoadSHFMER03.java:181)
at com.icsc.zwp.api.zwpcQueueRec02Handler.process(zwpcQueueRec02Handler.java:148)
at com.icsc.zwp.api.zwpcQueueRec02Handler.receiveData(zwpcQueueRec02Handler.java:100)
at com.icsc.sh.di.shjcLoadSHFMER03.xctl(shjcLoadSHFMER03.java:118)
at sun.reflect.GeneratedMethodAccessor9202.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at bsh.Reflect.invokeMethod(Unknown Source)
at bsh.Reflect.invokeObjectMethod(Unknown Source)
at bsh.Name.invokeMethod(Unknown Source)
at bsh.BSHMethodInvocation.eval(Unknown Source)
at bsh.BSHPrimaryExpression.eval(Unknown Source)
at bsh.BSHPrimaryExpression.eval(Unknown Source)
at bsh.BSHBlock.evalBlock(Unknown Source)
at bsh.BSHBlock.eval(Unknown Source)
at bsh.BSHBlock.eval(Unknown Source)
at bsh.BSHTryStatement.eval(Unknown Source)
at bsh.BSHBlock.evalBlock(Unknown Source)
at bsh.BSHBlock.eval(Unknown Source)
at bsh.BSHBlock.eval(Unknown Source)
at bsh.BSHTryStatement.eval(Unknown Source)
at bsh.Interpreter.eval(Unknown Source)
at bsh.Interpreter.eval(Unknown Source)
at bsh.Interpreter.eval(Unknown Source)
at org.rmi.client.BeanShellUtils.exec(BeanShellUtils.java:57)
at org.rmi.client.InstanceWorker.execute(InstanceWorker.java:84)
at sun.reflect.GeneratedMethodAccessor6427.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:320)
at sun.rmi.transport.Transport$1.run(Transport.java:171)
at java.security.AccessController.doPrivileged(AccessController.java:365)
at sun.rmi.transport.Transport.serviceCall(Transport.java:167)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:547)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:802)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:661)
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:784)

配置如图