* does the stored procedure work fine when called from standalone java program ?
* You can post the jstack of the glassfish process when you see the hang.
* You can enable wrap-jdbc-objects and statement-timeout attributes of jdbc-connection-pool.
(statement timeout will try to abort the statement if the timeout happens. This need to be supported by the driver vendor)
[Message sent by forum member 'jr158900' (jr158900)]
http://forums.java.net/jive/thread.jspa?messageID=349794