Re: TRANSACTIONS IN INFORMIX (AGAIN)

Hello, I could advise you to try to approaches, althoug I'm not sure which of them will work: 1. Use the Connection setAutoCommit()-> commit() (rollback()), i.e.: myConnection.setAutoCommit(false); .... if(noError) myConnection.commit(); else myConnection.rollback(); myConnection.setAutoCommit(true); 2. Prepare the statements: "BEGIN WORK" , "COMMIT WORK" and "ROLLBACK WORK" and use them as you need. The last method is just to incorporate the "BEGIN WORK", "COMMIT WORK" and "ROLLBACK WORK" into your stored procedure. Hope this will give you at least a starting point. Bye, Octav On Fri, Feb 05, 1999 at 01:07:48PM +0100, ASC wrote: > Hello, > I am developing a db management application in Java, and I am using > stored procedures. > The system is an Informix Online Dynamic Server 7.2 . I would like to > make each execution of an stored procedure a transaction, so, if > anything was wrong, I can rollback the updates. The db is created with > log. How can I achieve this? > > Regards, > -- Octav Chiriac Phone: (373) 2 21 20 96 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 24 00 83 Moldova, Republic of mailto:com@netinfo-moldova.com