jbossmq writes transaction to database even for non-transact

jhaddad Aug 5, 2004 4:40 PM

I've got a MDB with the trans-attribute set to 'Supports.' Some database reads and writes are performed within the onMessage method.

I'm running with p6spy, which shows me all SQL statements executed by the application. This shows that jbossmq issues 3 additional database writes every time onMessage is invoked. This is performance problem for me. I don't understand why its even executing these transaction-related statements when my bean isn't even transactional.

Could someone please help me make whatever config changes are necessary to disable this behavior. Thanks in advance.

The 3 SQL statements are:
INSERT INTO JMS_TRANSACTIONS (TXID) values(?)
DELETE FROM JMS_MESSAGES WHERE TXID=? AND TXOP=?
DELETE FROM JMS_TRANSACTIONS WHERE TXID = ?

1. Re: jbossmq writes transaction to database even for non-tran

genman Aug 5, 2004 5:28 PM (in response to jhaddad)

There is a NoLogging Persistence Manager configuration. Do a search for this.
Actions
2. Re: jbossmq writes transaction to database even for non-tran

dannyyates Aug 6, 2004 4:58 AM (in response to jhaddad)

The only valid transaction modes for MDBs are NotSupported and Required. Perhaps by using an invalid mode, JBoss has defaulted to Required?
Actions
3. Re: jbossmq writes transaction to database even for non-tran

jhaddad Aug 6, 2004 1:51 PM (in response to jhaddad)

Thanks for the suggestions. I tried setting the trans-attribute to NotSupported and get the same results.

As for the NoLogging PeristenceManager configuration, I am unable to find anything on this. Is it a separate implementation of the PersistenceManager or a setting on one of the documented ones (perhaps the file one)?
Actions
4. Re: jbossmq writes transaction to database even for non-tran

genman Aug 6, 2004 9:38 PM (in response to jhaddad)

Take a look at the Wiki, under the gold Community bar.
Actions

Go to original post