JTS on JBoss 4.0.5 with Oracle
j_ri Jan 3, 2007 8:05 AMHello,
I'm trying to use JBoss 4.0.5.GA with JTS (jbossts-full-4.2.2GA). I installed as decribed in the install_jts.txt and I found the info
http://www.jboss.com/index.html?module=bb&op=viewtopic&t=97104 that two lines in the install_jts.txt are reversed.....
My applications are deployed like that:
app1 on node1 starts a transaction and insertrs some data to a oracle datasource. within that transaction app2 on node2 gets called and inserts data to another datasource (same database, but differend schema).
I use Oracle thin driver 10.1.0.2 and have the datasources configured as <xa-datasource>.
Unfortujnately I get the following error:
12:23:41,051 WARN [JDBCExceptionReporter] SQL Error: 2051, SQLState: 42000
12:23:41,051 ERROR [JDBCExceptionReporter] ORA-02051: another session in same transaction failed
12:23:41,051 WARN [JDBCExceptionReporter] SQL Error: 2051, SQLState: 42000
12:23:41,051 ERROR [JDBCExceptionReporter] ORA-02051: Eine weitere Session in derselben Transaktion war nicht erfolgreich
12:23:41,051 ERROR [AbstractFlushingEventListener] Could not synchronize database state with session
org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
....
.....
......
12:23:41,082 WARN [loggerI18N] [com.arjuna.ats.internal.jts.orbspecific.coordinator.generror] ArjunaTransactionImple.doBeforeCompletion caught exception: org.omg.CORBA.UNKNOWN: Server-side Exception: vmcid: 0x0 minor code: 0 completed: No
12:23:41,082 WARN [arjLoggerI18N] [com.arjuna.ats.arjuna.coordinator.BasicAction_43] - Transaction -69b8f4be:792:459b9105:91 marked as rollback only. Will abort.
12:23:41,285 WARN [controller] rid: 10 opname: _is_a cannot process request, because object doesn't exist
12:23:41,285 WARN [controller] rid: 10 opname: _is_a request rejected with exception:
12:23:41,301 WARN [controller] rid: 8 opname: rollback cannot process request, because object doesn't exist
12:23:41,301 WARN [controller] rid: 8 opname: rollback request rejected with exception:
Can anybody help me and give me a hint what went wrong?
Thanks
Jochen