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

From Oliver Jowett
Subject Re: Connection.setReadOnly()
Date
Msg-id 4B21965C.2000306@opencloud.com
Whole thread Raw
In response to Re: Connection.setReadOnly()  (John R Pierce <pierce@hogranch.com>)
List pgsql-jdbc
John R Pierce wrote:
> Kris Jurka wrote:
>> So if they go to the trouble of doing a setReadOnly call, why not
>> simply do a setAutoCommit(true) call as well?
>
> thats pretty much what they'll have to do.   I guess setReadOnly() is
> pretty much a non-op in pg-jdbc?

It issues a "SET SESSION CHARACTERISTICS AS TRANSACTION READ ONLY"
command. See

http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/jdbc/pgjdbc/org/postgresql/jdbc2/AbstractJdbc2Connection.java?rev=1.54&content-type=text/x-cvsweb-markup

-O

pgsql-jdbc by date:

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