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 [EMAIL PROTECTED] Baruk Khazad! Khazad ai-menu! -------------------------------------------------------------- ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly