Re: Transactions through JDBC - Mailing list pgsql-general

From Jan de Visser
Subject Re: Transactions through JDBC
Date
Msg-id 200704111421.29550.jdevisser@digitalfairway.com
Whole thread Raw
In response to Re: Transactions through JDBC  ("Alberto Molteni" <alberto.molteni@libero.it>)
List pgsql-general
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!
--------------------------------------------------------------

pgsql-general by date:

Previous
From: "Chris Fischer"
Date:
Subject: Re: SQL - finding next date
Next
From: Jon Sime
Date:
Subject: Re: SQL - finding next date