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)