Re: [HACKERS] problem with new autocommit config parameter - Mailing list pgsql-jdbc

From Curt Sampson
Subject Re: [HACKERS] problem with new autocommit config parameter
Date
Msg-id Pine.NEB.4.44.0209101158440.13186-100000@angelic.cynic.net
Whole thread Raw
In response to Re: [HACKERS] problem with new autocommit config parameter and jdbc  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [HACKERS] problem with new autocommit config parameter and jdbc
List pgsql-jdbc
On Mon, 9 Sep 2002, Tom Lane wrote:

> If autocommit=off really seriously breaks JDBC then I don't think a
> simple SET command at the start of a session is going to do that much
> to improve robustness.  What if the user issues another SET to turn it
> on?

You mean, to turn it off again? The driver should catch this, in theory.

In practice we could probably live with saying, "Don't use SET
AUTOCOMMIT; use the methods on the Connection class instead."

Probably the driver should be changed for 7.3 just to use the server's
SET AUTOCOMMIT functionality....

cjs
--
Curt Sampson  <cjs@cynic.net>   +81 90 7737 2974   http://www.netbsd.org
    Don't you know, in this new Dark Age, we're all light.  --XTC


pgsql-jdbc by date:

Previous
From: Curt Sampson
Date:
Subject: Re: [HACKERS] problem with new autocommit config parameter and jdbc
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] problem with new autocommit config parameter and jdbc