Re: Transactions through JDBC - Mailing list pgsql-general

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

I will change as you told me!

Thanks!








>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly



--
--------------------------------------------------------------
Jan de Visser jdevisser@digitalfairway.com

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


pgsql-general by date:

Previous
From: Andrew Edson
Date:
Subject: Dumping part (not all) of the data in a database...methods?
Next
From: Magnus Hagander
Date:
Subject: Re: [pgsql-www] programmatic way to fetch latest release for a given major.minor version