Session Beans using JDBC- what are recommended Transaction Attribute

[Matthew X. Brown]

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).

[Simon Song]

TX_Required and REPEATABLE_READ should accomodate most usage.