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

[Sarang Anajwala (JIRA)]

    [ https://issues.jboss.org/browse/JBAS-9454?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12690477#comment-12690477 ] 

Sarang Anajwala commented on JBAS-9454:
---------------------------------------

Fix this issue - The link to source code and fixed jar is available on my blog @ http://oakgreen.blogspot.com/2012/05/jboss-timerservice-bug-fix.html
                
> Can not retrive timer from timerHandle stored in application db
> ---------------------------------------------------------------
>
>                 Key: JBAS-9454
>                 URL: https://issues.jboss.org/browse/JBAS-9454
>             Project: Application Server 3  4  5 and 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