[jboss-jira] [JBoss JIRA] (JBAS-9454) Can not retrive timer from timerHandle stored in application db

Sarang Anajwala (Updated) (JIRA) jira-events at lists.jboss.org
Tue Dec 6 10:02:43 EST 2011 

     [ https://issues.jboss.org/browse/JBAS-9454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Sarang Anajwala updated JBAS-9454:
----------------------------------

    Description: 
We are persisting timerHandle object obtained while creating timers, in our application db so that we can use this handle later on to retrieve timer object and cancel the timer.

However, when I try to retrieve the timer from this timerHandle object (after retrieving it from our application db), I am getting following error.

(pool-11-thread-10) Unknown Exception: : javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Cannot open connection
        at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1215) [:3.6.6.Final]
        at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1148) [:3.6.6.Final]
        at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:255) [:3.6.6.Final]
        at org.jboss.ejb3.timerservice.mk2.TimerServiceImpl.getPersistedTimer(TimerServiceImpl.java:951) [:1.0.0-alpha-13]
        at org.jboss.ejb3.timerservice.mk2.TimerServiceImpl.getTimer(TimerServiceImpl.java:530) [:1.0.0-alpha-13]
        at org.jboss.ejb3.timerservice.mk2.TimerHandleImpl.getTimer(TimerHandleImpl.java:107) [:1.0.0-alpha-13]
........................
........................
........................
Caused by: org.jboss.util.NestedSQLException: Transaction is not active: tx=TransactionImple < ac, BasicAction: 0:ffff9493b5ec:126a:4ede0333:22a status: ActionStatus.ABORTED >; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: 0:ffff9493b5ec:126a:4ede0333:22a status: ActionStatus.ABORTED >)
        at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:95) [:6.1.0.Final]
        at org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionProvider.java:71) [:3.6.6.Final]
        at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446) [:3.6.6.Final]
        ... 66 more
Caused by: javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: 0:ffff9493b5ec:126a:4ede0333:22a status: ActionStatus.ABORTED >
        at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:403) [:6.1.0.Final]
        at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496) [:6.1.0.Final]
        at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941) [:6.1.0.Final]
        at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89) [:6.1.0.Final]
        ... 68 more


  was:
We are persisting timerHandle object obtained while creating timers, in our application db so that we can use this handle later on to retrieve timer object and cancel the timer.

However, when I try to retrieve the timer from this timerHandle object (after retrieving it from our application db), I am getting following error.

(pool-11-thread-10) Unknown Exception: : javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Cannot open connection
        at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1215) [:3.6.6.Final]
        at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1148) [:3.6.6.Final]
        at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:255) [:3.6.6.Final]
        at org.jboss.ejb3.timerservice.mk2.TimerServiceImpl.getPersistedTimer(TimerServiceImpl.java:951) [:1.0.0-alpha-13]
        at org.jboss.ejb3.timerservice.mk2.TimerServiceImpl.getTimer(TimerServiceImpl.java:530) [:1.0.0-alpha-13]
        at org.jboss.ejb3.timerservice.mk2.TimerHandleImpl.getTimer(TimerHandleImpl.java:107) [:1.0.0-alpha-13]





    
> Can not retrive timer from timerHandle stored in application db
> ---------------------------------------------------------------
>
>                 Key: JBAS-9454
>                 URL: https://issues.jboss.org/browse/JBAS-9454
>             Project: Legacy JBoss Application Server 6 
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>    Affects Versions: 6.1.0
>         Environment: default datastore mysql
>            Reporter: Sarang Anajwala
>              Labels: EJB3, TimerService
>
> We are persisting timerHandle object obtained while creating timers, in our application db so that we can use this handle later on to retrieve timer object and cancel the timer.
> However, when I try to retrieve the timer from this timerHandle object (after retrieving it from our application db), I am getting following error.
> (pool-11-thread-10) Unknown Exception: : javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Cannot open connection
>         at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1215) [:3.6.6.Final]
>         at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1148) [:3.6.6.Final]
>         at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:255) [:3.6.6.Final]
>         at org.jboss.ejb3.timerservice.mk2.TimerServiceImpl.getPersistedTimer(TimerServiceImpl.java:951) [:1.0.0-alpha-13]
>         at org.jboss.ejb3.timerservice.mk2.TimerServiceImpl.getTimer(TimerServiceImpl.java:530) [:1.0.0-alpha-13]
>         at org.jboss.ejb3.timerservice.mk2.TimerHandleImpl.getTimer(TimerHandleImpl.java:107) [:1.0.0-alpha-13]
> ........................
> ........................
> ........................
> Caused by: org.jboss.util.NestedSQLException: Transaction is not active: tx=TransactionImple < ac, BasicAction: 0:ffff9493b5ec:126a:4ede0333:22a status: ActionStatus.ABORTED >; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: 0:ffff9493b5ec:126a:4ede0333:22a status: ActionStatus.ABORTED >)
>         at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:95) [:6.1.0.Final]
>         at org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionProvider.java:71) [:3.6.6.Final]
>         at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446) [:3.6.6.Final]
>         ... 66 more
> Caused by: javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: 0:ffff9493b5ec:126a:4ede0333:22a status: ActionStatus.ABORTED >
>         at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:403) [:6.1.0.Final]
>         at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496) [:6.1.0.Final]
>         at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941) [:6.1.0.Final]
>         at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89) [:6.1.0.Final]
>         ... 68 more

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

More information about the jboss-jira mailing list