Re: JDBC behaviour

Поиск
Список
Период
Сортировка
От Sridhar N Bamandlapally
Тема Re: JDBC behaviour
Дата
Msg-id CAGuFTBW=rFvmv2MibYp1UQTNhM93X--ARnd0J22mNoCufBOsgA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: JDBC behaviour  (Vladimir Sitnikov <sitnikov.vladimir@gmail.com>)
Ответы Re: JDBC behaviour  (Andreas Joseph Krogh <andreas@visena.com>)
Список pgsql-jdbc
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 по дате отправления:

Предыдущее
От: Vladimir Sitnikov
Дата:
Сообщение: Re: JDBC behaviour
Следующее
От: Andreas Joseph Krogh
Дата:
Сообщение: Re: JDBC behaviour