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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Curt Sampson <cjs(at)cynic(dot)net>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Barry Lind <barry(at)xythos(dot)com>, "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [JDBC] problem with new autocommit config parameter and jdbc
Date: 2002-09-10 03:27:13
Message-ID: 16196.1031628433@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-jdbc

Curt Sampson <cjs(at)cynic(dot)net> writes:
> Probably the driver should be changed for 7.3 just to use the server's
> SET AUTOCOMMIT functionality....

That should happen eventually, IMHO, but I am not going to tell the JDBC
developers that they must make it happen for 7.3. They've already got a
pile of much-higher-priority things to fix for 7.3, like schema
compatibility and dropped-column handling.

My feeling about the original complaint is very simple: setting server
autocommit to off is not supported with JDBC (nor is it fully supported
with any other of our frontend clients, right at this instant, though
that may improve somewhat before 7.3 release). If you don't like it,
tough; contribute the required fixes or stop complaining. Someone else
will fix it when they get around to it, but there are bigger problems to
deal with first. Autocommit is only a work-in-progress today, not
something that we promise will do anything useful for anybody.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-09-10 03:43:08 Re: Script to compute random page cost
Previous Message Steve Howe 2002-09-10 03:26:49 Re: Proposal: Solving the "Return proper affected tuple

Browse pgsql-jdbc by date

  From Date Subject
Next Message Michael Andreasen 2002-09-10 11:26:02 Blobs and "No results were returned by the query."
Previous Message Curt Sampson 2002-09-10 02:59:55 Re: [JDBC] problem with new autocommit config parameter