Re: [JDBC] JDBC behaviour - Mailing list pgsql-general

From John R Pierce
Subject Re: [JDBC] JDBC behaviour
Date
Msg-id 56C5902E.1030907@hogranch.com
Whole thread Raw
In response to Re: [JDBC] JDBC behaviour  (Sridhar N Bamandlapally <sridhar.bn1@gmail.com>)
List 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 by date:

Previous
From: Rakesh Kumar
Date:
Subject: Re: Multiple databases and shared_buffers
Next
From: Victor Blomqvist
Date:
Subject: Re: Query plan not updated after dropped index