Hi again.

I am sorry if you categorize me as impatient now, but... I did not
receive any answers on this thread.

Is it unclear? Do I need to provide more info? What can I do to solve
it myself (debug code)...What can be wrong? What are the possible
scenarios?

I am not into the internal workings of either JBoss (on using
resource adapters) or on Jaybird.

Hope to get feedback. *Anything* would be helpful I guess.

/Henrik


--- In Firebird-Java@yahoogroups.com, "hgoettig" <hgoettig@y...>
wrote:

> Hi group.
>
> Sorry it took some time to report this. Dunno, if it is a Jaybird
> error, but
> the fact is that my app runs fine with 1.5.0 and the error occurs

in

> 1.5.1
> (after a while). It might have something to do with cleaning up
> connections.
>
> My webapp is hosted on JBoss 3.2.5 and a Firebird 1.5.1 database
> server.
>
> Has anyone experienced similar problem, or can anyone confirm this

is

> a bug
> in the 1.5.1 driver?
> Or better... does anyone have a solution. So far I am running 1.5.0
> without
> problems.
>
> Thanks in advance.
>
>
> Stack trace below (if it helps you "debugging")
>
> Best regards
>
> Henrik
>
> --------------------------
>
> 2004-09-22 11:29:43,227 DEBUG
> [org.jboss.resource.connectionmanager.IdleRemover] run: IdleRemover
> notifying pools, interval: 450000
> 2004-09-22 11:29:44,508 DEBUG
> [org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.SystemLink#findAll]
> Executing SQL: SELECT DISTINCT t0_l.id, t0_l.sortorder FROM
> T_SYSTEMLINK
> t0_l ORDER BY t0_l.sortorder ASC
> 2004-09-22 11:29:44,508 INFO
> [org.jboss.resource.connectionmanager.TxConnectionManager] Could

not

> enlist
> in transaction on entering meta-aware object!
> javax.transaction.SystemException: Could not register

synchronization

> with
> tx: javax.transaction.RollbackException: Already marked for rollback
> at
>

org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionE

> ventLi
> stener.enlist(TxConnectionManager.java:469)
> at
>

org.jboss.resource.connectionmanager.TxConnectionManager.managedConnec

> tionRe
> connected(TxConnectionManager.java:337)
> at
>

org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateCo

> nnecti
> on(BaseConnectionManager2.java:502)
> at
> org.jboss.resource.connectionmanager.BaseConnectionManager2
> $ConnectionManage
> rProxy.allocateConnection(BaseConnectionManager2.java:887)
> at org.firebirdsql.jdbc.FBDataSource.getConnection
> (FBDataSource.java:85)
> at
> org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute
> (JDBCAbstract
> QueryCommand.java:181)
> at
> org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute
> (JDBCAbstract
> QueryCommand.java:117)
> at
> org.jboss.ejb.plugins.cmp.jdbc.JDBCFindEntitiesCommand.execute
> (JDBCFindEntit
> iesCommand.java:38)
> at
> org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.findEntities
> (JDBCStoreManage
> r.java:587)
> at
> org.jboss.ejb.plugins.CMPPersistenceManager.findEntities
> (CMPPersistenceManag
> er.java:285)
> at
>

org.jboss.resource.connectionmanager.CachedConnectionInterceptor.findE

> ntitie
> s(CachedConnectionInterceptor.java:322)
> at org.jboss.ejb.EntityContainer.findLocal

(EntityContainer.java:614)

>
> ....... more
>
> 2004-09-22 11:29:44,539 WARN [org.jboss.tm.TransactionImpl]
> XAException:
> tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=KVIKBOOK//1017,
> BranchQual=] errorCode=XAER_NOTA
> org.firebirdsql.jca.FBXAException: Unrecognized transaction
> at
> org.firebirdsql.jca.FBManagedConnection.internalEnd
> (FBManagedConnection.java
> :455)
> at
> org.firebirdsql.jca.FBManagedConnection.end
> (FBManagedConnection.java:427)
> at org.jboss.tm.TransactionImpl.endResource
> (TransactionImpl.java:1253)
> at org.jboss.tm.TransactionImpl.delistResource
> (TransactionImpl.java:549)
> at
>

org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionE

> ventLi
> stener.delist(TxConnectionManager.java:486)
> at
>

org.jboss.resource.connectionmanager.TxConnectionManager.managedConnec

> tionDi
> sconnected(TxConnectionManager.java:352)
> at
>

org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateCo

> nnecti
> on(BaseConnectionManager2.java:506)
> at
> org.jboss.resource.connectionmanager.BaseConnectionManager2
> $ConnectionManage
> rProxy.allocateConnection(BaseConnectionManager2.java:887)
> at org.firebirdsql.jdbc.FBDataSource.getConnection
> (FBDataSource.java:85)
> at
> org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute
> (JDBCAbstract
> QueryCommand.java:181)
> at
> org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute
> (JDBCAbstract
> QueryCommand.java:117)
> at
> org.jboss.ejb.plugins.cmp.jdbc.JDBCFindEntitiesCommand.execute
> (JDBCFindEntit
> iesCommand.java:38)
> at
> org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.findEntities
> (JDBCStoreManage
> r.java:587)
> at
> org.jboss.ejb.plugins.CMPPersistenceManager.findEntities
> (CMPPersistenceManag
> er.java:285)
>
> ....... more
>
> 2004-09-22 11:29:44,571 DEBUG
>

[org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.SystemLink#findAll]

> Find
> failed
> org.firebirdsql.jdbc.FBSQLException: Problem getting connection:
> javax.resource.ResourceException: Failure to delist resource
> at org.firebirdsql.jdbc.FBDataSource.getConnection
> (FBDataSource.java:88)
> at
> org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute
> (JDBCAbstract
> QueryCommand.java:181)
> at
> org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute
> (JDBCAbstract
> QueryCommand.java:117)
> at
> org.jboss.ejb.plugins.cmp.jdbc.JDBCFindEntitiesCommand.execute
> (JDBCFindEntit
> iesCommand.java:38)
> at
> org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.findEntities
> (JDBCStoreManage
> r.java:587)
> at
> org.jboss.ejb.plugins.CMPPersistenceManager.findEntities
> (CMPPersistenceManag
> er.java:285)
> at
>

org.jboss.resource.connectionmanager.CachedConnectionInterceptor.findE

> ntitie
> s(CachedConnectionInterceptor.java:322)
> at org.jboss.ejb.EntityContainer.findLocal

(EntityContainer.java:614)

>
> ....... more
>
> 2004-09-22 11:29:44,586 INFO [STDOUT] getLinks, SystemLinks: Find
> failed:
> org.firebirdsql.jdbc.FBSQLException: Problem getting connection:
> javax.resource.ResourceException: Failure to delist resource
> 2004-09-22 11:29:44,586 DEBUG
>

[org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.CompanyLink#findByWeb

> Name]
> Executing SQL: SELECT DISTINCT t0_l.id, t0_l.sortorder FROM
> T_COMPANYLINK
> t0_l, T_COMPANY t1_l_company WHERE (t1_l_company.webname = ? AND
> t0_l.fk_webname=t1_l_company.webname) ORDER BY t0_l.sortorder ASC
> 2004-09-22 11:29:44,586 INFO
> [org.jboss.resource.connectionmanager.TxConnectionManager] Could

not

> enlist
> XAResource!
> javax.transaction.RollbackException: Already marked for rollback
> at org.jboss.tm.TransactionImpl.enlistResource
> (TransactionImpl.java:596)
> at
>

org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionE

> ventLi
> stener.enlist(TxConnectionManager.java:448)
> at
>

org.jboss.resource.connectionmanager.TxConnectionManager.managedConnec

> tionRe
> connected(TxConnectionManager.java:337)
> at
>

org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateCo

> nnecti
> on(BaseConnectionManager2.java:502)
> at
> org.jboss.resource.connectionmanager.BaseConnectionManager2
> $ConnectionManage
> rProxy.allocateConnection(BaseConnectionManager2.java:887)
> at org.firebirdsql.jdbc.FBDataSource.getConnection
> (FBDataSource.java:85)
> at
> org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute
> (JDBCAbstract
> QueryCommand.java:181)
> at
> org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute
> (JDBCAbstract
> QueryCommand.java:117)