Transaction Management when stored procedure calls Java
posted 7 years ago
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.