I'm having a problem with XATransaction on Firebird JDBC/JCA.
I saw that some people have had the same problem with Oracle.
My program executes de follow steps:
GET USER_TRANSACTION
BEGIN TRANSACTION
GET CONNECTION VIA JDBC
EXECUTE A QUERY
CLOSE CONNECTION
OPEN A HIBERNATE SESSION
EXECUTE A INSERT VIA HIBERNATE SESSION
ERROR !!!!!!!!!!!
The trace is below:
15:13:30,795 INFO [TxConnectionManager] Could not enlist in transaction on entering
meta-aware object!
javax.transaction.SystemException: enlistResource failed
at
org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.enlist(TxConnectionManager.java:456)
at
org.jboss.resource.connectionmanager.TxConnectionManager.managedConnectionReconnected(TxConnectionManager.java:343)
at
org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:483)
at
org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:814)
at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:79)
at
net.sf.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:59)
at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:278)
at net.sf.hibernate.impl.SessionImpl.connect(SessionImpl.java:3264)
at net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java:3244)
at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:65)
at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:704)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:185)
at
net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)
at net.sf.hibernate.loader.Loader.doList(Loader.java:950)
at net.sf.hibernate.loader.Loader.list(Loader.java:941)
at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:834)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1512)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1491)
at net.sf.hibernate.impl.SessionImpl.delete(SessionImpl.java:1633)
at net.sf.hibernate.impl.SessionImpl.delete(SessionImpl.java:1623)
at
br.com.b2brasil.redefacil.model.CacheRelatoriosModel.limpar(CacheRelatoriosModel.java:102)
.....
15:13:30,795 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: HY000
15:13:30,795 ERROR [JDBCExceptionReporter] Problem getting connection:
javax.resource.ResourceException: Could not enlist in transaction on entering
meta-aware object!javax.transaction.SystemException: enlistResource failed
15:13:30,795 ERROR [JDBCExceptionReporter] Cannot open connection
org.firebirdsql.jdbc.FBSQLException: Problem getting connection:
javax.resource.ResourceException: Could not enlist in transaction on entering
meta-aware object!javax.transaction.SystemException: enlistResource failed
at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:82)
at
net.sf.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:59)
at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:278)
at net.sf.hibernate.impl.SessionImpl.connect(SessionImpl.java:3264)
at net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java:3244)
at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:65)
at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:704)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:185)
at
net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)
at net.sf.hibernate.loader.Loader.doList(Loader.java:950)
at net.sf.hibernate.loader.Loader.list(Loader.java:941)
at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:834)
.....
Can some help me, please?
Thanks
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3846185#3846185
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3846185
-------------------------------------------------------
SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
