0 Replies Latest reply on Jan 3, 2006 4:56 AM by Chetan Aggarwal

    Calling DB Stored procedure from SessionBean method

    Chetan Aggarwal Newbie

      Hi all,

      I am calling a Stored procedure from stateless session bean method. Stateless bean's method is having Transaction attribute as RequiresNew. I have not done any commit/rollback in Stored procedure expecting ejb container to do it.

      But the db changes made by stored procedure are not getting commited.

      Is there any restriction of calling stored procedures from EJBs???

      Is there any work around to control transaction from ejb,yet doing updations in stored procedure?

      I am using Jboss 4.0.2.

      Please suggest.
      Thanks
      Chetan