[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Stored Procedure call from a EJB 3.0 Stateless bean

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 View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3988050#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...