Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Transaction Management when stored procedure calls Java

srichakrav chakrav
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.

  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic