Thread: Postgres jdbc transactions

Postgres jdbc transactions

From
Olivier Thomas
Date:
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.

Re: Postgres jdbc transactions

From
David Johnston
Date:
On Sep 5, 2011, at 10:36, Olivier Thomas <othomas@webtiss.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
DBsaying 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
autocommittrue. 
> 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
vaguedescription doesn't cut it. 

David J.


Re: Postgres jdbc transactions

From
Guillaume Cottenceau
Date:
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