0 Replies Latest reply on Dec 11, 2016 9:30 AM by Abdul Wahid

    DB connection pool problem.

    Abdul Wahid Newbie

      Dear 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:

      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