We are using EJB2.0 along with EJB-QL embided in the entitiy, when using with Oracle JDBC XA driver, throwing exception shown below and rolling back the transaction.
java.sql.SQLException: ORA-02044: transaction manager login denied: transaction in progress
ORA-06512: at "SYS.JAVA_XA", line 0
ORA-06512: at line 1
Here's the text re: the error via oerr (Oracle's Unix utility)
02044, 00000, "transaction manager login denied: transaction in progress"
// *Cause: a remote transaction manager tried to log in while a distributed
// transaction is in progress.
// *Action: end the current transaction (this is a protocol error from a
// remote transaction manager)
Looks like you may have an uncommited transaction. I would recommend that you pose the same question on Oracle's technet discussion forums: otn.oracle.com