Re: [JDBC] problem with new autocommit config parameter and jdbc

From: snpe <snpe(at)snpe(dot)co(dot)yu>
To: pgsql-hackers(at)postgresql(dot)org
Cc: pgsl-jdbc(at)postgresql(dot)org
Subject: Re: [JDBC] problem with new autocommit config parameter and jdbc
Date: 2002-09-07 18:57:55
Message-ID: 200209072057.55317.snpe@snpe.co.yu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-jdbc

On Saturday 07 September 2002 04:07 pm, Bruce Momjian wrote:
> snpe wrote:
> > On Saturday 07 September 2002 02:55 am, Bruce Momjian wrote:
> > > Barry Lind wrote:
> > > > Haris,
> > > >
> > > > You can't use jdbc (and probably most other postgres clients) with
> > > > autocommit in postgresql.conf turned off.
> > > >
> > > > Hackers,
> > > >
> > > > How should client interfaces handle this new autocommit feature? Is
> > > > it best to just issue a set at the beginning of the connection to
> > > > ensure that it is always on?
> > >
> > > Yes, I thought that was the best fix for apps that can't deal with
> > > autocommit being off.
> >
> > Can client get information from backend for autocommit (on or off) and
> > that work like psql ?
>
> 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

thanks

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Rod Taylor 2002-09-07 18:58:08 Re: current_schemas()
Previous Message Alvaro Herrera 2002-09-07 18:39:35 current_schemas()

Browse pgsql-jdbc by date

  From Date Subject
Next Message Joe Conway 2002-09-07 19:12:36 Re: [JDBC] problem with new autocommit config parameter
Previous Message Bruce Momjian 2002-09-07 14:07:19 Re: [JDBC] problem with new autocommit config parameter and