Re: Using ON_ERROR_ROLLBACK functionality in JDBC - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Using ON_ERROR_ROLLBACK functionality in JDBC
Date
Msg-id Pine.BSO.4.63.0607281119360.11376@leary2.csoft.net
Whole thread Raw
In response to Re: Using ON_ERROR_ROLLBACK functionality in JDBC  (Mark Lewis <mark.lewis@mir3.com>)
List pgsql-jdbc

On Fri, 28 Jul 2006, Mark Lewis wrote:

> Does the current savepoint implementation in the driver require a
> separate round-trip?

Yes.  Creating, rolling back to, or releasing a savepoint each currently
make a server round-trip.  If you're suggesting queueing these up so that
it sends these with queries instead of alone, I think that's something the
driver could do if it was creating savepoints itself, but would be tougher
to do for user savepoints.  For user savepoints I think you need to get
feedback to the caller immediately upon command execution rather than with
a later query.  Consider something like trying to release an invalid
savepoint.  You need to tell the user immediately.

Kris Jurka


pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Using ON_ERROR_ROLLBACK functionality in JDBC
Next
From: Mike Morris
Date:
Subject: literal value in the select fieldlist returns not the string, but a java String object