jQuery in Action, 2nd edition*
The moose likes Websphere and the fly likes Session Beans using JDBC- what are recommended Transaction Attribute Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Products » Websphere
Bookmark "Session Beans using JDBC- what are recommended Transaction Attribute" Watch "Session Beans using JDBC- what are recommended Transaction Attribute" New topic
Author

Session Beans using JDBC- what are recommended Transaction Attribute

Matthew X. Brown
Ranch Hand

Joined: Nov 08, 2000
Posts: 165
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
Ranch Hand

Joined: Feb 01, 2002
Posts: 217
TX_Required and REPEATABLE_READ should accomodate most usage.


Simon Song
Certified Entperise Developer of Websphere
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Session Beans using JDBC- what are recommended Transaction Attribute