Re: [JDBC] problem with new autocommit config parameter

From: Joe Conway <mail(at)joeconway(dot)com>
To: snpe <snpe(at)snpe(dot)co(dot)yu>
Cc: pgsql-hackers(at)postgresql(dot)org, pgsl-jdbc(at)postgresql(dot)org
Subject: Re: [JDBC] problem with new autocommit config parameter
Date: 2002-09-07 19:12:36
Message-ID: 3D7A4FA4.9070102@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-jdbc

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2002-09-07 19:27:09 Re: [GENERAL] Making small bits of code available
Previous Message Hervé Piedvache 2002-09-07 19:03:47 Impossible to import pg_dumpall from 7.2.2 to 7.3b1

Browse pgsql-jdbc by date

  From Date Subject
Next Message snpe 2002-09-07 20:09:45 Re: [JDBC] problem with new autocommit config parameter
Previous Message snpe 2002-09-07 18:57:55 Re: [JDBC] problem with new autocommit config parameter and jdbc