Skip site navigation (1) Skip section navigation (2)

Re: Using ON_ERROR_ROLLBACK functionality in JDBC

From: Kris Jurka <books(at)ejurka(dot)com>
To: "Koth, Christian \(DWBI\)" <Christian(dot)Koth(at)smiths-heimann(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Using ON_ERROR_ROLLBACK functionality in JDBC
Date: 2006-07-28 16:17:54
Message-ID: Pine.BSO.4.63.0607281115040.11376@leary2.csoft.net (view raw or flat)
Thread:
Lists: pgsql-jdbc

On Fri, 28 Jul 2006, Koth, Christian (DWBI) wrote:

> Do you think its planned to do a thing like this?

It is on the TODO list, but driver development has currently stalled.

> Also I am wondering if this would really speed up applications. Is 
> creating savepoints expensive? Will have to do some tests. I think of 
> doing something like:
>

Savepoints aren't cheap, but they are cheaper than committing a whole
transaction.  There was a thread on this on -performance just yesterday.

http://archives.postgresql.org/pgsql-performance/2006-07/threads.php#00245

Kris Jurka


In response to

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2006-07-28 16:23:56
Subject: Re: Using ON_ERROR_ROLLBACK functionality in JDBC
Previous:From: Mark LewisDate: 2006-07-28 15:58:01
Subject: Re: Using ON_ERROR_ROLLBACK functionality in JDBC

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group