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