File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Websphere and the fly likes Whose handling transactions? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Products » Websphere
Bookmark "Whose handling transactions?" Watch "Whose handling transactions?" New topic

Whose handling transactions?

Veera Maria

Joined: Sep 04, 2003
Posts: 2
If I have a stateless session bean that is calling stored procedure or
a chain of stored procedures, whose transaction is used? Is it bean's or what, can anyone explain me how this works in WebSphere?
David O'Meara

Joined: Mar 06, 2001
Posts: 13459

You'd need to pick up a J2EE book and have a look at transactions, but in the broadest of terms:
J2EE supports the 2-phase protocol, which allows the server to gather and combine transactions from multiple '2-phase transaction supporting locations'. Taking this back to your question, as long as the database and drivers are XA compliant (a clever way of saying 'we do that 2-phase thingy') the server maintains a transaction context, and any external transactions (like those in the database) are considered part of the server transaction.
I'm going to stop here, since I've exhausted my knowledge on the area
I agree. Here's the link:
subject: Whose handling transactions?
It's not a secret anymore!