com.sun.jdo.api.persistence.support.JDODataStoreException: JDO77006: SQL exception: state = null, error code = 0. NestedException: java.sql.SQLException: Error in allocating a connection. Cause: Connection could not be allocated because: Communications link failure Last packet sent to the server was 0 ms ago.

Oracle Community | sol1001 | 7 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    EJB Timer service & Database failure

    Oracle Community | 7 years ago | sol1001
    com.sun.jdo.api.persistence.support.JDODataStoreException: JDO77006: SQL exception: state = null, error code = 0. NestedException: java.sql.SQLException: Error in allocating a connection. Cause: Connection could not be allocated because: Communications link failure Last packet sent to the server was 0 ms ago.

    Root Cause Analysis

    1. com.sun.jdo.api.persistence.support.JDODataStoreException

      JDO77006: SQL exception: state = null, error code = 0. NestedException: java.sql.SQLException: Error in allocating a connection. Cause: Connection could not be allocated because: Communications link failure Last packet sent to the server was 0 ms ago.

      at com.sun.jdo.spi.persistence.support.sqlstore.impl.TransactionImpl.getConnectionInternal()
    2. com.sun.jdo
      PersistenceManagerWrapper.getObjectById
      1. com.sun.jdo.spi.persistence.support.sqlstore.impl.TransactionImpl.getConnectionInternal(TransactionImpl.java:1465)
      2. com.sun.jdo.spi.persistence.support.sqlstore.impl.TransactionImpl.getConnection(TransactionImpl.java:1358)
      3. com.sun.jdo.spi.persistence.support.sqlstore.SQLStoreManager.executeQuery(SQLStoreManager.java:447)
      4. com.sun.jdo.spi.persistence.support.sqlstore.SQLStoreManager.retrieve(SQLStoreManager.java:376)
      5. com.sun.jdo.spi.persistence.support.sqlstore.SQLStateManager.retrieve(SQLStateManager.java:2059)
      6. com.sun.jdo.spi.persistence.support.sqlstore.SQLStateManager.reload(SQLStateManager.java:1197)
      7. com.sun.jdo.spi.persistence.support.sqlstore.SQLStateManager.reload(SQLStateManager.java:1153)
      8. com.sun.jdo.spi.persistence.support.sqlstore.impl.PersistenceManagerImpl.getObjectById(PersistenceManagerImpl.java:658)
      9. com.sun.jdo.spi.persistence.support.sqlstore.impl.PersistenceManagerWrapper.getObjectById(PersistenceManagerWrapper.java:276)
      9 frames
    3. Embedded GlassFish Web
      TimerBean_2100919770_ConcreteImpl.ejbFindByPrimaryKey
      1. com.sun.ejb.containers.TimerBean_2100919770_ConcreteImpl.ejbFindByPrimaryKey(TimerBean_2100919770_ConcreteImpl.java:1066)
      1 frame
    4. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor156.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      3. java.lang.reflect.Method.invoke(Method.java:597)
      3 frames
    5. com.sun.enterprise
      EJBSecurityManager.runMethod
      1. com.sun.enterprise.security.application.EJBSecurityManager.runMethod(EJBSecurityManager.java:1011)
      1 frame
    6. Security Core Classes
      SecurityUtil.invoke
      1. com.sun.enterprise.security.SecurityUtil.invoke(SecurityUtil.java:175)
      1 frame
    7. Embedded GlassFish Web
      EJBLocalHomeInvocationHandler.invoke
      1. com.sun.ejb.containers.BaseContainer.invokeTargetBeanMethod(BaseContainer.java:2920)
      2. com.sun.ejb.containers.EntityContainer.invokeFindByPrimaryKey(EntityContainer.java:803)
      3. com.sun.ejb.containers.EJBLocalHomeInvocationHandler.invoke(EJBLocalHomeInvocationHandler.java:233)
      3 frames
    8. Unknown
      $Proxy12.findByPrimaryKey
      1. $Proxy12.findByPrimaryKey(Unknown Source)
      1 frame
    9. Embedded GlassFish Web
      WorkAdapter.doWork
      1. com.sun.ejb.containers.EJBTimerService.findTimer(EJBTimerService.java:1180)
      2. com.sun.ejb.containers.EJBTimerService.removeTimerBean(EJBTimerService.java:1278)
      3. com.sun.ejb.containers.EJBTimerService.expungeTimer(EJBTimerService.java:982)
      4. com.sun.ejb.containers.EJBTimerService.deliverTimeout(EJBTimerService.java:1470)
      5. com.sun.ejb.containers.EJBTimerService.access$100(EJBTimerService.java:99)
      6. com.sun.ejb.containers.EJBTimerService$TaskExpiredWork.run(EJBTimerService.java:1952)
      7. com.sun.ejb.containers.EJBTimerService$TaskExpiredWork.service(EJBTimerService.java:1948)
      8. com.sun.ejb.containers.util.WorkAdapter.doWork(WorkAdapter.java:75)
      8 frames
    10. glassfish-corba-orbgeneric
      ThreadPoolImpl$WorkerThread.run
      1. com.sun.corba.ee.impl.orbutil.threadpool.ThreadPoolImpl$WorkerThread.run(ThreadPoolImpl.java:555)
      1 frame