On Wednesday 11 April 2007 14:01:55 Alberto Molteni wrote:
> >You should use
> >
> > conn.setAutoCommit(false);
> > conn.execute(...)
> > conn.execute(...)
> > conn.execute(...)
> > conn.commit();
> >
> >
> > Thanks!
>
> jan
>
> Then, conn.setAutoCommit(false); has to be regarded as a begin statement?
I think BEGIN is implicitly send when you execute the first statement in a new
transaction. You shouldn't worry about it.
> I had already put the autocommit flag to false soon after the creation of
> the connection, since I saw an improvement in the performances without that
> flag and moreover I wanted to make transactions on my own.
Makes sense.
>
> I will change as you told me!
>
> Thanks!
jan
--
--------------------------------------------------------------
Jan de Visser jdevisser@digitalfairway.com
Baruk Khazad! Khazad ai-menu!
--------------------------------------------------------------