Search Postgresql Archives

Re: Transactions through JDBC

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxxxxxx

                Baruk Khazad! Khazad ai-menu!
--------------------------------------------------------------


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux