4 Replies Latest reply on Aug 6, 2004 9:38 PM by Elias Ross

    jbossmq writes transaction to database even for non-transact

    Justin Haddad Newbie

      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 = ?