I have a question concerning the handling of a transaction timeout:
I am using JBoss 3.0.4 with Oracle9i Release 22.214.171.124.0 (using LocalTxConnectionManager).
Following test scenario: I lock a table and try to access it over EJBs (a CMT Session Bean calls a BMP Entity Bean, all methods with Transaction REQUIRED).
After five minutes (TransactionTimeout in jboss-service.xml), I get the message in server.log
2003-11-07 13:13:32,265 WARN [org.jboss.tm.TxCapsule] Transaction XidImpl [FormatId=257, GlobalId=CSWS5//407, BranchQual=] timed out. status=STATUS_ACTIVE
The thread (the EJB trying to access the table) hangs and will not be released until the lock in the database is released.
Is this the expected behaviour or should the timed out thread terminate with an exception?