File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Transaction Management when stored procedure calls Java

srichakrav chakrav
Posts: 2
  • 0
  • 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.

I agree. Here's the link:
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic