Re: commit problem

From: "Kevin Grittner" <kgrittn(at)mail(dot)com>
To: "John R Pierce" <pierce(at)hogranch(dot)com>,pgsql-jdbc(at)postgresql(dot)org
Subject: Re: commit problem
Date: 2012-10-25 22:10:48
Message-ID: 20121025221048.306920@gmx.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

John R Pierce wrote:

> my developers don't think simple reads ARE a transaction.

Now you've piqued my interest. To run multiple simple selects which
should see a consistent view of the data, wouldn't they expect they
could setTransactionIsolation() to TRANSACTION_REPEATABLE_READ or
TRANSACTION_SERIALIZABLE and setAutoCommit() false to see a stable
view of the data?  How would they say they were done with that view
and wanted a fresh one for the next batch of SELECT statements?

-Kevin

Browse pgsql-jdbc by date

  From Date Subject
Next Message Craig Ringer 2012-10-26 06:54:01 Re: Publish artifacts to Maven central
Previous Message Thomas Kellerer 2012-10-25 22:09:14 Re: commit problem