Re: Postgres jdbc transactions

From: David Johnston <polobo(at)yahoo(dot)com>
To: Olivier Thomas <othomas(at)webtiss(dot)com>
Cc: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Postgres jdbc transactions
Date: 2011-09-05 15:16:43
Message-ID: 8AC720C7-F0B2-47DD-B59F-BFF16641CDE5@yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc


On Sep 5, 2011, at 10:36, Olivier Thomas <othomas(at)webtiss(dot)com> wrote:

> Hi,
>
> I am having a hard time to manage transactions with Postgres 8.3.
>
> I am using latest Postgres jdbc driver and apached dbutils library.
> After getting a connexion I am trying to set Connection objet to autocommit "false" but I get an error message from DB saying that setting autocommit to off is no longer supported.
> Therefore, when I'm trying to call "rollcack" at the en d of my code, I am rejected sayning that my DB is in autocommit true.
> Can you tell me what I am doing wrong or which library I should use ?
> so far I have found no example on the web...
>
> Thanks
> O.

It's hard to point out what you are doing wrong if you don't show exactly what you are doing (and the error message). A vague description doesn't cut it.

David J.

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Johann 'Myrkraverk' Oskarsson 2011-09-07 15:49:39 Patch: Some more state codes
Previous Message Guillaume Cottenceau 2011-09-05 15:13:22 Re: Postgres jdbc transactions