Return-Path: X-Original-To: apmail-db-derby-user-archive@www.apache.org Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id EC37C9526 for ; Fri, 31 Aug 2012 15:26:07 +0000 (UTC) Received: (qmail 89268 invoked by uid 500); 31 Aug 2012 15:26:07 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 89245 invoked by uid 500); 31 Aug 2012 15:26:07 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 89237 invoked by uid 99); 31 Aug 2012 15:26:07 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 31 Aug 2012 15:26:07 +0000 X-ASF-Spam-Status: No, hits=0.6 required=5.0 tests=FSL_RCVD_USER,HTML_MESSAGE,RCVD_IN_DNSWL_MED,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: local policy) Received: from [65.55.88.14] (HELO tx2outboundpool.messaging.microsoft.com) (65.55.88.14) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 31 Aug 2012 15:25:57 +0000 Received: from mail222-tx2-R.bigfish.com (10.9.14.246) by TX2EHSOBE003.bigfish.com (10.9.40.23) with Microsoft SMTP Server id 14.1.225.23; Fri, 31 Aug 2012 15:25:36 +0000 Received: from mail222-tx2 (localhost [127.0.0.1]) by mail222-tx2-R.bigfish.com (Postfix) with ESMTP id 0A2583C0147 for ; Fri, 31 Aug 2012 15:25:36 +0000 (UTC) X-Forefront-Antispam-Report: CIP:157.56.234.133;KIP:(null);UIP:(null);IPV:NLI;H:SN2PRD0610HT005.namprd06.prod.outlook.com;RD:none;EFVD:NLI X-SpamScore: -4 X-BigFish: VPS-4(zzbb2dI98dI9371Ic85fh14ffIzz1202hzz8275bh8275dhz2dh2a8h668h839hd25hf0ah107ah1155h) Received: from mail222-tx2 (localhost.localdomain [127.0.0.1]) by mail222-tx2 (MessageSwitch) id 134642673335264_17392; Fri, 31 Aug 2012 15:25:33 +0000 (UTC) Received: from TX2EHSMHS006.bigfish.com (unknown [10.9.14.254]) by mail222-tx2.bigfish.com (Postfix) with ESMTP id EE6A5400043 for ; Fri, 31 Aug 2012 15:25:32 +0000 (UTC) Received: from SN2PRD0610HT005.namprd06.prod.outlook.com (157.56.234.133) by TX2EHSMHS006.bigfish.com (10.9.99.106) with Microsoft SMTP Server (TLS) id 14.1.225.23; Fri, 31 Aug 2012 15:25:31 +0000 Received: from SN2PRD0610MB396.namprd06.prod.outlook.com ([169.254.4.169]) by SN2PRD0610HT005.namprd06.prod.outlook.com ([10.255.117.40]) with mapi id 14.16.0190.008; Fri, 31 Aug 2012 15:25:31 +0000 From: Alain Kuchta To: Derby Discussion Subject: RE: Get a "read-only" connection using Derby EmbeddedDataSource40 Thread-Topic: Get a "read-only" connection using Derby EmbeddedDataSource40 Thread-Index: Ac2HgM/IS3AtYtlwQoSR/cIeKcAGDgAAJhSwAALE1wAAABTzkA== Date: Fri, 31 Aug 2012 15:25:30 +0000 Message-ID: References: <5040D6CA.1020400@sbcglobal.net> In-Reply-To: <5040D6CA.1020400@sbcglobal.net> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [72.49.105.163] Content-Type: multipart/alternative; boundary="_000_BA35FB323D092143B4F8335A0CAC0EE418494363SN2PRD0610MB396_" MIME-Version: 1.0 X-OriginatorOrg: etegent.com --_000_BA35FB323D092143B4F8335A0CAC0EE418494363SN2PRD0610MB396_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Thank you for bringing this to my attention. From: Katherine Marsden [mailto:kmarsdenderby@sbcglobal.net] Sent: Friday, August 31, 2012 11:23 AM To: Derby Discussion Subject: Re: Get a "read-only" connection using Derby EmbeddedDataSource40 On 8/31/2012 7:05 AM, Alain Kuchta wrote: Hello all, I've actually found an answer to my own question in the Derby Reference Man= ual. The java.sql.Connection method "setReadOnly(boolean)" is supported and perf= orms as I desired. Perhaps someone else will found this snippet useful. One word of caution: While Connection.setReadOnly works fine for Embedded. = There is a long standing issue with the call with Client: https://issues.apache.org/jira/browse/DERBY-911 --_000_BA35FB323D092143B4F8335A0CAC0EE418494363SN2PRD0610MB396_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Thank you for bringing= this  to my attention.

 

From: Katherine Marsden [mailto:kmarsdenderby@sbcglobal= .net]
Sent: Friday, August 31, 2012 11:23 AM
To: Derby Discussion
Subject: Re: Get a "read-only" connection using Derby Embe= ddedDataSource40

 

On 8/31/2012 7:05 AM, Alain Kuchta wrote:=

Hello all,=

 

I’ve actually fo= und an answer to my own question in the Derby Reference Manual.

The java.sql.Connection method “setReadOnly(boolean)” is suppor= ted and performs as I desired.

 

Perhaps someone else w= ill found this snippet useful.

 


One word of caution: While Connection.setReadOnly works fine for Embedded.&= nbsp;  There is a long standing  issue with the call with Client:=
https://issues.= apache.org/jira/browse/DERBY-911

--_000_BA35FB323D092143B4F8335A0CAC0EE418494363SN2PRD0610MB396_--