Re: [JDBC] JDBC behaviour

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: [JDBC] JDBC behaviour
Дата
Msg-id 56C5902E.1030907@hogranch.com
обсуждение исходный текст
Ответ на Re: [JDBC] JDBC behaviour  (Sridhar N Bamandlapally <sridhar.bn1@gmail.com>)
Список pgsql-general
On 2/18/2016 12:26 AM, Sridhar N Bamandlapally wrote:
> If we want transactions in "begin-end" then its fine,
>
> but in this case all these transactions are independent with
> autocommit off,

with autocommit OFF, when you issue the first query, jdbc generates a
postgresql BEGIN;  this starts a postgresql transaction.     To end the
transaction,  you have to explicitly .commit() or .rollback() ....

with autocommit ON, then jdbc lets each query execute standalone, this
is postgresql's default behavior if you don't use BEGIN...



--
john r pierce, recycling bits in santa cruz



В списке pgsql-general по дате отправления:

Предыдущее
От: Rakesh Kumar
Дата:
Сообщение: Re: Multiple databases and shared_buffers
Следующее
От: Victor Blomqvist
Дата:
Сообщение: Re: Query plan not updated after dropped index