This week's book giveaway is in the Testing forum. We're giving away four copies of The Way of the Web Tester: A Beginner's Guide to Automating Tests and have Jonathan Rasmusson on-line! See this thread for details.
Transaction Management when stored procedure calls Java
posted 6 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.