Re: [JDBC] problem with new autocommit config parameter

Joe Conway <mail@joeconway.com>

From: Joe Conway <mail@joeconway.com>
To: snpe <snpe@snpe.co.yu>
Cc: pgsql-hackers@postgresql.org, pgsl-jdbc@postgresql.org
Date: 2002-09-07T19:12:36Z
Lists: pgsql-hackers
snpe wrote:
>>Sure, you can do SHOW autocommit.
> 
> I am interesting with JDBC driver.
> When I make connection in base I want that driver find autocommit mode 
> (from postgresql.conf or call in backend) and set mode true or false 
> 

You could make a call to current_setting in the backend.

I don't know anything about the jdbc driver, but if it's written in C 
something like this should work:

text *autocommit = DatumGetTextP(DirectFunctionCall1(current_setting,
                                       CStringGetDatum("autocommit")));

Would this work?

Joe