Subject: Re: PostgreSQL: Autocommit through windows odbc driver doesnt work!!!
To: "Venkatesan, Sekhar" <sekhar.venkatesan@emc.com>,
 "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
References: <F84DE43FDACD4C45AA84E2DA016FAE2F1C65A5FC@MX105CL01.corp.emc.com>
From: Adrian Klaver <adrian.klaver@aklaver.com>
Message-ID: <56AA4157.4040509@aklaver.com>
Date: Thu, 28 Jan 2016 08:27:03 -0800
User-Agent: Mozilla/5.0 (X11; Linux i686; rv:38.0) Gecko/20100101
 Thunderbird/38.5.1
MIME-Version: 1.0
In-Reply-To: <F84DE43FDACD4C45AA84E2DA016FAE2F1C65A5FC@MX105CL01.corp.emc.com>
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 8bit
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

On 01/27/2016 10:31 PM, Venkatesan, Sekhar wrote:
> Hi All,
>
> I am trying  to certify our product with PostgreSQL database and facing
> an issue with windows odbc driver and need your help to identify the
> problem.
>
> Our application uses SQLDriverConnect to connect to PostgreSQL server. I
> am using PostgreSQL odbc driver version 9.4
>
> SQLSetConnectAttr to enable autocommit as below:
>
> Eg: SQLSetConnectAttr(SQL_ATTR_AUTOCOMMIT, SQL_AUTOCOMMIT_ON, 0)
>
> But it seems autocommit is not set and hence any queries executed from
> other session never gets updated data in other session since autocommit
> of insert statements never happens.
>
> Only workaround I am seeing is to explicitly issue “commit” to save the
> updates in the database.
>
> Has anyone seen this issue earlier? I see a relevant issue in psqlODBC
> 09.05.0100 Release something like below:
>
> https://odbc.postgresql.org/docs/release.html
>
> 1.*Don't reset autocommit when a connection is established*
>
> If autocommit is disabled on a connection, by calling
> SQLSetConnectAttr(SQL_ATTR_AUTOCOMMIT, SQL_AUTOCOMMIT_OFF, 0), before
> connecting with SQLDriverConnect(), autocommit was incorrectly reset
> back to on when the connection was established.
>
> Is the above issue fixed? Also in my use-case, I want to enable
> autocommit at odbc driver level but even that doesn’t work.
>
> The same application works in Linux OS when unix odbc driver is used.
> This seems to be specific to windows driver.
>
> Please shed some light on this. Do ask me further question if you have any.

The only answer I have is that you might get an answer sooner if you 
post this to the -odbc list:

http://www.postgresql.org/list/pgsql-odbc/

>
> Thanks,
>
> Sekhar
>


-- 
Adrian Klaver
adrian.klaver@aklaver.com


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql