java.sql.SQLException: Error in allocating a connection. Cause: In-use connections equal max-pool-size and expired max-wait-time. Cannot allocate more connections.

Oracle Community | peppeme | 8 years ago
  1. 0

    query log for derby (__TimerPool connection)

    Oracle Community | 8 years ago | peppeme
    java.sql.SQLException: Error in allocating a connection. Cause: In-use connections equal max-pool-size and expired max-wait-time. Cannot allocate more connections.
  2. 0

    OpenESB Community Forum - Connection where not closed

    nabble.com | 6 months ago
    javax.jbi.messaging.MessagingException: Error occured while executing sql.Reason: Error in allocating a connection. Cause: In-use connections equal max-pool-size and expired max-wait-time. Cannot allocate more connections. SQLState: null ErrorCode: 0
  3. 0

    JDBC MySql Connection Pooling practices

    soso.io | 1 year ago
    java.sql.SQLException: Error in allocating a connection. Cause: In-use connections equal max-pool-size and expired max-wait-time. Cannot allocate more connections.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    JDBC MySql Connection Pooling practices

    itquestionz.com | 1 year ago
    java.sql.SQLException: Error in allocating a connection. Cause: In-use connections equal max-pool-size and expired max-wait-time. Cannot allocate more connections.
  6. 0

    how to release connections back to the connection pool

    Oracle Community | 9 years ago | hughacland
    java.sql.SQLException: Error in allocating a connection. Cause: In-use connections equal max-pool-size and expired max-wait-time. Cannot allocate more connections.

    1 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      Error in allocating a connection. Cause: In-use connections equal max-pool-size and expired max-wait-time. Cannot allocate more connections.

      at com.sun.gjc.spi.base.DataSource.getConnection()
    2. Embedded GlassFish Web
      DataSource.getConnection
      1. com.sun.gjc.spi.base.DataSource.getConnection(DataSource.java:115)
      1 frame
    3. com.sun.jdo
      QueryImpl.executeWithArray
      1. com.sun.jdo.spi.persistence.support.sqlstore.ejb.TransactionHelperImpl.getConnection(TransactionHelperImpl.java:212)
      2. com.sun.jdo.spi.persistence.support.sqlstore.ejb.EJBHelper.getConnection(EJBHelper.java:197)
      3. com.sun.jdo.spi.persistence.support.sqlstore.impl.TransactionImpl.getConnectionInternal(TransactionImpl.java:1447)
      4. com.sun.jdo.spi.persistence.support.sqlstore.impl.TransactionImpl.getConnection(TransactionImpl.java:1358)
      5. com.sun.jdo.spi.persistence.support.sqlstore.SQLStoreManager.executeQuery(SQLStoreManager.java:447)
      6. com.sun.jdo.spi.persistence.support.sqlstore.SQLStoreManager.retrieve(SQLStoreManager.java:376)
      7. com.sun.jdo.spi.persistence.support.sqlstore.impl.PersistenceManagerImpl.retrieve(PersistenceManagerImpl.java:1118)
      8. com.sun.jdo.spi.persistence.support.sqlstore.query.QueryImpl.doExecute(QueryImpl.java:689)
      9. com.sun.jdo.spi.persistence.support.sqlstore.query.QueryImpl.executeWithArray(QueryImpl.java:607)
      9 frames
    4. Embedded GlassFish Web
      TimerBean.ejbHomeSelectTimersByContainer
      1. com.sun.ejb.containers.TimerBean_2100919770_ConcreteImpl.ejbSelectTimersByContainer(TimerBean_2100919770_ConcreteImpl.java:1458)
      2. com.sun.ejb.containers.TimerBean.ejbHomeSelectTimersByContainer(TimerBean.java:665)
      2 frames
    5. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    6. com.sun.enterprise
      EJBSecurityManager.runMethod
      1. com.sun.enterprise.security.application.EJBSecurityManager.runMethod(EJBSecurityManager.java:1067)
      1 frame
    7. Security Core Classes
      SecurityUtil.invoke
      1. com.sun.enterprise.security.SecurityUtil.invoke(SecurityUtil.java:176)
      1 frame
    8. Embedded GlassFish Web
      EJBLocalHomeInvocationHandler.invoke
      1. com.sun.ejb.containers.BaseContainer.invokeTargetBeanMethod(BaseContainer.java:2895)
      2. com.sun.ejb.containers.EJBLocalHomeInvocationHandler.invoke(EJBLocalHomeInvocationHandler.java:242)
      2 frames
    9. Unknown
      $Proxy22.selectTimersByContainer
      1. $Proxy22.selectTimersByContainer(Unknown Source)
      1 frame
    10. Embedded GlassFish Web
      StatelessSessionContainer.undeploy
      1. com.sun.ejb.containers.EJBTimerService.destroyTimers(EJBTimerService.java:729)
      2. com.sun.ejb.containers.BaseContainer.destroyTimers(BaseContainer.java:1610)
      3. com.sun.ejb.containers.BaseContainer.undeploy(BaseContainer.java:2931)
      4. com.sun.ejb.containers.StatelessSessionContainer.undeploy(StatelessSessionContainer.java:744)
      4 frames
    11. com.sun.enterprise
      ApplicationManager.applicationUndeployed
      1. com.sun.enterprise.server.AbstractLoader.unloadEjbs(AbstractLoader.java:411)
      2. com.sun.enterprise.server.ApplicationLoader.unload(ApplicationLoader.java:236)
      3. com.sun.enterprise.server.TomcatApplicationLoader.unload(TomcatApplicationLoader.java:213)
      4. com.sun.enterprise.server.ApplicationManager.applicationUndeployed(ApplicationManager.java:525)
      5. com.sun.enterprise.server.ApplicationManager.applicationUndeployed(ApplicationManager.java:699)
      5 frames
    12. admin-util
      AdminEventMulticaster.multicastEvent
      1. com.sun.enterprise.admin.event.AdminEventMulticaster.invokeApplicationDeployEventListener(AdminEventMulticaster.java:930)
      2. com.sun.enterprise.admin.event.AdminEventMulticaster.handleApplicationDeployEvent(AdminEventMulticaster.java:912)
      3. com.sun.enterprise.admin.event.AdminEventMulticaster.processEvent(AdminEventMulticaster.java:461)
      4. com.sun.enterprise.admin.event.AdminEventMulticaster.multicastEvent(AdminEventMulticaster.java:176)
      4 frames
    13. com.sun.enterprise
      ApplicationsConfigMBean.stop
      1. com.sun.enterprise.admin.server.core.DeploymentNotificationHelper.multicastEvent(DeploymentNotificationHelper.java:308)
      2. com.sun.enterprise.deployment.phasing.DeploymentServiceUtils.multicastEvent(DeploymentServiceUtils.java:226)
      3. com.sun.enterprise.deployment.phasing.ServerDeploymentTarget.sendStopEvent(ServerDeploymentTarget.java:332)
      4. com.sun.enterprise.deployment.phasing.ApplicationStopPhase.runPhase(ApplicationStopPhase.java:136)
      5. com.sun.enterprise.deployment.phasing.DeploymentPhase.executePhase(DeploymentPhase.java:108)
      6. com.sun.enterprise.deployment.phasing.PEDeploymentService.executePhases(PEDeploymentService.java:919)
      7. com.sun.enterprise.deployment.phasing.PEDeploymentService.stop(PEDeploymentService.java:652)
      8. com.sun.enterprise.deployment.phasing.PEDeploymentService.stop(PEDeploymentService.java:699)
      9. com.sun.enterprise.admin.mbeans.ApplicationsConfigMBean.stop(ApplicationsConfigMBean.java:767)
      9 frames
    14. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    15. GlassFish Admin
      MBeanHelper.invokeOperationInBean
      1. com.sun.enterprise.admin.MBeanHelper.invokeOperationInBean(MBeanHelper.java:375)
      2. com.sun.enterprise.admin.MBeanHelper.invokeOperationInBean(MBeanHelper.java:358)
      2 frames
    16. com.sun.enterprise
      BaseConfigMBean.invoke
      1. com.sun.enterprise.admin.config.BaseConfigMBean.invoke(BaseConfigMBean.java:464)
      1 frame
    17. Java RT
      Method.invoke
      1. com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:836)
      2. com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:761)
      3. sun.reflect.GeneratedMethodAccessor15.invoke(Unknown Source)
      4. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      5. java.lang.reflect.Method.invoke(Method.java:597)
      5 frames
    18. admin-util
      ProxyClass.invoke
      1. com.sun.enterprise.admin.util.proxy.ProxyClass.invoke(ProxyClass.java:90)
      1 frame
    19. Unknown
      $Proxy1.invoke
      1. $Proxy1.invoke(Unknown Source)
      1 frame
    20. com.sun.enterprise
      RemoteJmxConnectorServlet.doPost
      1. com.sun.enterprise.admin.server.core.jmx.SunoneInterceptor.invoke(SunoneInterceptor.java:304)
      2. com.sun.enterprise.interceptor.DynamicInterceptor.invoke(DynamicInterceptor.java:174)
      3. com.sun.enterprise.admin.jmx.remote.server.callers.InvokeCaller.call(InvokeCaller.java:69)
      4. com.sun.enterprise.admin.jmx.remote.server.MBeanServerRequestHandler.handle(MBeanServerRequestHandler.java:155)
      5. com.sun.enterprise.admin.jmx.remote.server.servlet.RemoteJmxConnectorServlet.processRequest(RemoteJmxConnectorServlet.java:122)
      6. com.sun.enterprise.admin.jmx.remote.server.servlet.RemoteJmxConnectorServlet.doPost(RemoteJmxConnectorServlet.java:193)
      6 frames
    21. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:738)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
      2 frames
    22. Glassfish Core
      StandardPipeline.doInvoke
      1. org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:411)
      2. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:290)
      3. org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:271)
      4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:202)
      5. org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:632)
      6. org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:577)
      6 frames
    23. Glassfish
      WebPipeline.invoke
      1. com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:94)
      1 frame
    24. Glassfish Core
      ContainerBase.invoke
      1. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:206)
      2. org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:632)
      3. org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:577)
      4. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:571)
      5. org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1080)
      6. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:150)
      7. org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:632)
      8. org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:577)
      9. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:571)
      10. org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1080)
      10 frames
    25. org.apache.coyote
      CoyoteAdapter.service
      1. org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:272)
      1 frame
    26. Glassfish Core
      WorkerThreadImpl.run
      1. com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.invokeAdapter(DefaultProcessorTask.java:637)
      2. com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.doProcess(DefaultProcessorTask.java:568)
      3. com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.process(DefaultProcessorTask.java:813)
      4. com.sun.enterprise.web.connector.grizzly.DefaultReadTask.executeProcessorTask(DefaultReadTask.java:341)
      5. com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:263)
      6. com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:214)
      7. com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:265)
      8. com.sun.enterprise.web.connector.grizzly.WorkerThreadImpl.run(WorkerThreadImpl.java:116)
      8 frames