Re: Connection.setReadOnly() - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Connection.setReadOnly()
Date
Msg-id alpine.BSO.2.00.0912101744080.30821@leary.csoft.net
Whole thread Raw
In response to Connection.setReadOnly()  (John R Pierce <pierce@hogranch.com>)
Responses Re: Connection.setReadOnly()
List pgsql-jdbc

On Thu, 10 Dec 2009, John R Pierce wrote:

> does Connection.setReadOnly(true) block pgjdbc from automatically issuing
> BEGIN;, similar to setAutoCommit(true) ?

No.

> if not, why not?
>

Just because your connection is readonly doesn't mean that everyone elses
is as well.  If you want a consistent view of the database you can get
that with a serializable transaction.

Kris Jurka

pgsql-jdbc by date:

Previous
From: John R Pierce
Date:
Subject: Connection.setReadOnly()
Next
From: John R Pierce
Date:
Subject: Re: Connection.setReadOnly()