Re: Postgres jdbc transactions - Mailing list pgsql-jdbc

From Guillaume Cottenceau
Subject Re: Postgres jdbc transactions
Date
Msg-id m339gbc99p.fsf@mnc.ch
Whole thread Raw
In response to Postgres jdbc transactions  (Olivier Thomas <othomas@webtiss.com>)
List pgsql-jdbc
Show your code. I'm suspecting the same problem as
http://postgresql.1045698.n5.nabble.com/SET-AUTOCOMMIT-TO-OFF-no-longer-supported-td2169957.html
quoting the glorious Kris:

  Check your classpath.  I'd bet you've got two versions of the driver in
  there.  Try adding this line somewhere in your app.

  org.postgresql.util.PSQLDriverVersion.main(null);

  It will print where it finds the driver on stdout.

(an old version of the driver biting you)


Olivier Thomas <othomas 'at' webtiss.com> writes:

> 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.

--
Guillaume Cottenceau

pgsql-jdbc by date:

Previous
From: David Johnston
Date:
Subject: Re: Postgres jdbc transactions
Next
From: "Johann 'Myrkraverk' Oskarsson"
Date:
Subject: Patch: Some more state codes