DB connection pool problem.
awahid Dec 11, 2016 9:30 AMDear friends,
We are getting the connection pool issue with our production environment. Can someone give the solution to this issue.
Jboss version:- jboss-as-7.1.1.Final
JDK version:- jdk1.7.0_80
22:14:19,011 WARN [org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory] (Timer-9) Destroying connection that is not valid, due to the following exception:
- oracle.jdbc.driver.T4CConnection@6fd3d743: java.sql.SQLException: pingDatabase failed status=-2
at org.jboss.jca.adapters.jdbc.extensions.oracle.OracleValidConnectionChecker.isValidConnection(OracleValidConnectionChecker.java:74)
at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnectionFactory.isValidConnection(BaseWrapperManagedConnectionFactory.java:1151)
at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.checkValid(BaseWrapperManagedConnection.java:461)
at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.matchManagedConnections(LocalManagedConnectionFactory.java:507)
at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:282)
at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:397)
at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:365)
at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:329)
at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:368)
at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:464)
at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:129)
at com.pi.fwk.util.EJBHomeFactory.getDbConnection(EJBHomeFactory.java:486) [framework.jar:]
at com.pi.fwk.util.TableControlBeanLookupUtil.getDbConnection(TableControlBeanLookupUtil.java:325) [framework.jar:]
at com.pi.fwk.util.TableControlBeanLookupUtil.getMaxID(TableControlBeanLookupUtil.java:99) [framework.jar:]
at com.pi.dynamicentitymanagement.dataaccesslayer.classes.TableControlBeanLookup.getMaxID(TableControlBeanLookup.java:260) [dynamicentitymanagement-ejb.jar:]
at com.tpp.components.util.classes.BaseDAO.getMaxId(BaseDAO.java:327) [util.jar:]
at com.tpp.components.tickler.runtime.classes.TicklerRuntimeDAO.updateHistory(TicklerRuntimeDAO.java:574) [tickler.jar:]
at com.tpp.components.tickler.runtime.classes.TicklerRuntimeDelegate.updateHistory(TicklerRuntimeDelegate.java:292) [tickler.jar:]
at com.tpp.components.tickler.runtime.classes.TicklerTimerTask.insertTicklerHistory(TicklerTimerTask.java:288) [tickler.jar:]
at com.tpp.components.tickler.runtime.classes.TicklerTimerTask.run(TicklerTimerTask.java:132) [tickler.jar:]
at java.util.TimerThread.mainLoop(Timer.java:555) [rt.jar:1.7.0_80]
at java.util.TimerThread.run(Timer.java:505) [rt.jar:1.7.0_80]
Thanks,
Abdul Wahid