Re: commit problem - Mailing list pgsql-jdbc

From Kevin Grittner
Subject Re: commit problem
Date
Msg-id 20121025221048.306920@gmx.com
Whole thread Raw
In response to commit problem  (John R Pierce <pierce@hogranch.com>)
List 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


pgsql-jdbc by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: commit problem
Next
From: "Kevin Grittner"
Date:
Subject: Re: commit problem