Re: Connection.setReadOnly()

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: John R Pierce <pierce(at)hogranch(dot)com>
Cc: Kris Jurka <books(at)ejurka(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Connection.setReadOnly()
Date: 2009-12-11 00:46:20
Message-ID: 4B21965C.2000306@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message John R Pierce 2009-12-11 00:57:08 Re: Connection.setReadOnly()
Previous Message Oliver Jowett 2009-12-11 00:41:28 Re: Connection.setReadOnly()