Hi All,

I am trying to execute a stored procedure using the Ibatis framework
with the Jboss EJB 3.0 container.
I am able to successfully invoke a procedure, which has simple select
statements.

eg DELIMITER $$;

DROP PROCEDURE IF EXISTS `msp_platform`.`getCount`$$

CREATE DEFINER=`mspplatform`@`localhost` PROCEDURE `getCount`()
BEGIN
select count(*) from libraryelement;
END$$

DELIMITER ;$$


However, on trying to execute a procedure which updates the database,
there appears to be some kind of a lock
and the java client hangs. The procedure that I am trying to execute is
listed below.

DELIMITER $$;

DROP PROCEDURE IF EXISTS `msp_platform`.`testUpdate`$$

CREATE DEFINER=`mspplatform`@`localhost` PROCEDURE `testUpdate`()
BEGIN
update libraryelement set elementName = 'test' where elementName =
'smitha';
END$$

DELIMITER ;$$


Would appreaciate any inputs regarding this issue?

Thanks,
Smitha