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