From: | snpe <snpe(at)snpe(dot)co(dot)yu> |
---|---|
To: | "pgsql-jdbc(at)postgresql(dot)org"(at)mx1(dot)verat(dot)net |
Subject: | Re: [HACKERS] problem with new autocommit config parameter |
Date: | 2002-09-07 23:27:19 |
Message-ID: | 200209080127.19658.snpe@snpe.co.yu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Ok.
Now JDBC don't work with autocommit=true in psotgresql.conf except
if have 'conn.setAutoCommit(false)' on begining.
On Sunday 08 September 2002 12:39 am, Barry Lind wrote:
> Yes it is possible, but according to the jdbc spec, a new connection in
> jdbc is always initialized to autocommit=true. So jdbc needs to ignore
> whatever the current server setting is and reset to autocommit=true.
>
> --Barry
>
> 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 ?
>
From | Date | Subject | |
---|---|---|---|
Next Message | Felipe Schnack | 2002-09-08 17:08:13 | postgresql-java |
Previous Message | Barry Lind | 2002-09-07 22:39:46 | Re: [JDBC] problem with new autocommit config parameter |