From: | Guillaume Cottenceau <gc(at)mnc(dot)ch> |
---|---|
To: | Olivier Thomas <othomas(at)webtiss(dot)com> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Postgres jdbc transactions |
Date: | 2011-09-05 15:13:22 |
Message-ID: | m339gbc99p.fsf@mnc.ch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | David Johnston | 2011-09-05 15:16:43 | Re: Postgres jdbc transactions |
Previous Message | Olivier Thomas | 2011-09-05 14:36:15 | Postgres jdbc transactions |