Session Beans using JDBC- what are recommended Transaction Attribute
Matthew X. Brown
Joined: Nov 08, 2000
Ok- I've got a stateless session bean deployed in WAS3.5.2. I wanted to specify on the method level what the transaction attribute and isolation levels were, but I was receiving a com.ibm.csi.blah.blah transaction rollback exception. So I changed all of the methods back to the default settings(TX_REQUIRED and TRANSACTION_REPEATABLE_READ) Now it seems to be getting further and working- I'd like to take the time and test with each of the settings- but I'd like to know how others have used these settings with stateless session beans making direct JDBC access. I'm NOT starting a javax.transaction during it. Also, I don't have our DB2 driver JTA enabled(I heard it impacts deployment of EJB's).
Joined: Feb 01, 2002
TX_Required and REPEATABLE_READ should accomodate most usage.
Certified Entperise Developer of Websphere