1 Reply Latest reply on Jul 22, 2005 8:39 AM by stundzig

    database update only inside of transactions

    stundzig Newbie

      Hi all,

      I wish to setup my datasource so that update operations only from within transactions are really change persistent datas.

      Therefore I've tested with local-tx-datasource, xa-datasource and no-tx-datasource. DB ist Oracle9i, JBoss 4.0.2RC1.

      I've a simple SLSB with container managed transaction and 'NotSupported' as transaction type on all methods. This SLSB calls the MyEBHome.create() method on my CMP Entity Bean which also has container managed transaction and 'NotSupported'.

      But If I call the create method, an entry is made in the DB. Can I suppress this an ResourceManager-level?

      Another approach could by to set the transaction type on all 'set' and 'create'-methods to mandatory, but this is a lot of XDoclet-code to write.

      Any other ideas or did I missed something?

      Regards
      Steffen...

        • 1. Re: database update only inside of transactions
          stundzig Newbie

          Hi all,

          why didn't answer anybody? Is my question to stupid or to difficult? Has nobody out there the same problem?

          I've tested now with 'autoCommit' = false on the Oracle JCA configuration. Now the db updates were not executed. Unless I'm shutdown the server. Then the connections to the db were closed and all the stuff is written to it.

          Next try was 'commitOnClose' = false. But this changed nothing.

          What can I do? Can please someone helps me?

          Regards
          Steffen...