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

    DB connection pool problem.

    awahid

      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