Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Transaction Management when stored procedure calls Java

 
srichakrav chakrav
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic