Calling stored procedures from Session bean's business methods

[Tejas Bavishi]

Hi,
I am curious as to what is the effect of calling stored procedures that start and commit/rollback transactions within the database tier.
The session bean business methods that call this kind of stored procedures, should they take any special precautions ? How session beans will behave under bean managed transaction / container managed transaction that call this stored procedures?
Thanks in advance for your replies.

[Sujatha Kumar]

Calling Stored Procedures from EJB is not recommended.
In fact J2EE architecture never recommends to do that.

[Tejas Bavishi]

Hi,
Could you point me to official J2EE recommendation/white papers that discourage calling stored procedures from the session beans.
Thanks for your response.

[Pradeep bhatt]

Do not commit in the stored procedure leave it to the container. SP are discouraged because they are not portable across databases.