File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Transaction Management when stored procedure calls Java
 
Similar Threads
MVC or DAO?
System exception on UserTransaction.commit() , followed by RollbackException
Synchronizing on a static method
Can we call java program from a Oracle stored procedure?
Business logic in DB or EJB ?????