Stored Procedures migration to JTA model
843854Feb 21 2003 — edited Feb 24 2003Hi,
My scenario is the following:
I'm trying to migrate an application that used to be java stand-alone to J2EE model, in this particular case using JTA.
I have stored procedures in DB2, Oracle and SQL Server that are called by the application. These stored procedures have a lot of conditions all over to commit and/or rollback. I'm trying to decide what changes should be done within them so they support JTA and global transactions.
So far I guess the only solution I can think of is getting rid of all commit and rollback commands (what is necessary if we don't want to get exceptions for using local transactions in a global tm) and make the stored procedures return a status value to indicate success or failure.
Is it another way to make stored procedures and global transactions (JTA) aware of each other?
I'll really appreciate any suggestion on the subject.
Thanks in advance.
- Jose A. -