Postgres Pro
Downloads
Home   >   mailing lists

Re: JDBC behaviour - Mailing list pgsql-jdbc

From Sridhar N Bamandlapally
Subject Re: JDBC behaviour
Date
Msg-id CAGuFTBW=rFvmv2MibYp1UQTNhM93X--ARnd0J22mNoCufBOsgA@mail.gmail.com
Whole thread Raw
In response to Re: JDBC behaviour  (Vladimir Sitnikov <sitnikov.vladimir@gmail.com>)
Responses Re: JDBC behaviour
List pgsql-jdbc
Tree view
Ok, let me put this way

in JDBC we have setAutoCommit( false ) , and all dmls are independent transactions

and when any transaction fails then the session not allowing next transactions

in Java when we do setAutoCommit( false ) its behaving like all transactions in BEGIN-END block, this is not expected behavior

i guess this is bug





On Thu, Feb 18, 2016 at 2:00 PM, Vladimir Sitnikov <sitnikov.vladimir@gmail.com> wrote:
> but in this case all these transactions are independent with autocommit off,

At database level, there is no "autocommit=off".
There's just "begin-end".

It is database who forbids .commit, not the JDBC driver.
Vladimir

pgsql-jdbc by date:

Previous
From: Vladimir Sitnikov
Date:
Subject: Re: JDBC behaviour
Next
From: Andreas Joseph Krogh
Date:
Subject: Re: JDBC behaviour