Thanks Dag. I found it's true I can issue commit and rollback, however the document derbydev.pdf shows in "Controlling Derby application behavior->Transaction->Using autocommit" that:
"Procedures that use nested connections are not permitted to turn auto-commit on or off or to commit or roll back." Is that out of date? On Tue, Feb 26, 2008 at 12:05 AM, Dag H. Wanvik <[EMAIL PROTECTED]> wrote: > "sin(EaTing)," <[EMAIL PROTECTED]> writes: > > > Hi, > > > > I got some new confusion about Derby transactions in server side > procedure. > > Could anyone help on whether these statements are right or not? > > > > 1. In server side procedure, we CANNOT change autocommit, issue > commit or > > rollback? > > You can issue commit or rollback. > > > 2. In server side procedure, we CAN change isolation level and this > will > > cause the transaction be committed? > > I believe so. > > Dag >
