0 Replies Latest reply on Nov 22, 2006 11:58 PM by Smitha Naik

    Stored Procedure call from a EJB 3.0 Stateless bean

    Smitha Naik Newbie

      I am trying to execute a stored procedure using the ibatis framework.
      The invocation of the procedure is within a stateless bean.

      A procedure with a "only select statements" work fine.

      However, if a proecdure has an update statement, then there appears to be a deadlock. When this happens, I am not able to manually update the table as well. I get a lock wait timeout error.

      My database is Mysql 5.x version.

      Any insights into this problem would be appreciated