Hibernate is holding the changes in its cache, and not committing those changes to the database until the Session is closed or the transaction is committed. Since this is happening after the procedue, you see the procedure going first, and then the updates.
So, commit your changes earlier, and it should all work!
posted 12 years ago
Thanks for reply.
You mean Once completed the insertion, commit the changes. then, again call the procedures with new transaction.
We're pleased to have you here with us here on the ranch, but there are a few rules that need to be followed, and one is that proper names are required. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it.
In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious. Initials are OK for the first and middle names but not the last. You can change it here [ July 25, 2008: Message edited by: Ben Souther ]