wood burning stoves 2.0*
The moose likes EJB and other Java EE Technologies and the fly likes Transaction Management when stored procedure calls Java Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "Transaction Management when stored procedure calls Java" Watch "Transaction Management when stored procedure calls Java" New topic
Author

Transaction Management when stored procedure calls Java

srichakrav chakrav
Greenhorn

Joined: Feb 25, 2010
Posts: 2
We have current architecture as follows:-

1. A Stateless Session EJB calls Java Method A to perform business logic.
2. The Java Method A calls a Stored Procedure A to persist data to a database.
3. The Stored Procedure A calls again a Java Method B to perform some other business logic.

How can I make all three calls fall within the same transaction so that If anyone breaks in the flow the whole transaction will be rolled back. We are using Oracle 10g version.

Thanks,
SC
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Transaction Management when stored procedure calls Java