Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: neutral (athena.apache.org: local policy)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=sbcglobal.net;
  h=DKIM-Signature:X-Yahoo-Newman-Property:X-YMail-OSG:X-Yahoo-SMTP:Received:Message-ID:Date:From:User-Agent:MIME-Version:To:Subject:References:In-Reply-To:Content-Type;
  b=5fBfwS26AphArfq/uvCA5aFIKWqpbz72aXcERG5c/BwE2FtXSX3n3K512ZKFIdoM9pZ1b4tvN9cIhUn+Qcx+gHfVy/T8AyHa3c9+Fi0FEwu8/zrQ33yz3iEPrvvecWUPVNygX4Z1ZiwmlOeKPGQcK16F5QTFZG7EL5XKXL0mSrE=
  ;
Message-ID: <5040D6CA.1020400@sbcglobal.net>
Date: Fri, 31 Aug 2012 08:22:50 -0700
From: Katherine Marsden <kmarsdenderby@sbcglobal.net>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
 rv:15.0) Gecko/20120824 Thunderbird/15.0
MIME-Version: 1.0
To: Derby Discussion <derby-user@db.apache.org>
Subject: Re: Get a "read-only" connection using Derby EmbeddedDataSource40
References: 
 <BA35FB323D092143B4F8335A0CAC0EE418493330@SN2PRD0610MB396.namprd06.prod.outlook.com>
 <BA35FB323D092143B4F8335A0CAC0EE418494345@SN2PRD0610MB396.namprd06.prod.outlook.com>
In-Reply-To: 
 <BA35FB323D092143B4F8335A0CAC0EE418494345@SN2PRD0610MB396.namprd06.prod.outlook.com>
Content-Type: multipart/alternative;
 boundary="------------050403050908000107030306"

This is a multi-part message in MIME format.
--------------050403050908000107030306
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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 Manual.
>
> The java.sql.Connection method "setReadOnly(boolean)" is supported and 
> performs 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


--------------050403050908000107030306
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <div class="moz-cite-prefix">On 8/31/2012 7:05 AM, Alain Kuchta
      wrote:<br>
    </div>
    <blockquote
cite="mid:BA35FB323D092143B4F8335A0CAC0EE418494345@SN2PRD0610MB396.namprd06.prod.outlook.com"
      type="cite">
      <meta http-equiv="Content-Type" content="text/html;
        charset=ISO-8859-1">
      <meta name="Generator" content="Microsoft Word 12 (filtered
        medium)">
      <style><!--
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
	{font-family:Tahoma;
	panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:purple;
	text-decoration:underline;}
span.EmailStyle17
	{mso-style-type:personal;
	font-family:"Calibri","sans-serif";
	color:windowtext;}
span.EmailStyle18
	{mso-style-type:personal-reply;
	font-family:"Calibri","sans-serif";
	color:#1F497D;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-size:10.0pt;}
@page WordSection1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
      <div class="WordSection1">
        <p class="MsoNormal"><span style="color:#1F497D">Hello all,<o:p></o:p></span></p>
        <p class="MsoNormal"><span style="color:#1F497D"><o:p>&nbsp;</o:p></span></p>
        <p class="MsoNormal"><span style="color:#1F497D">I&#8217;ve actually
            found an answer to my own question in the Derby Reference
            Manual.<br>
            <br>
            The java.sql.Connection method &#8220;setReadOnly(boolean)&#8221; is
            supported and performs as I desired.<o:p></o:p></span></p>
        <p class="MsoNormal"><span style="color:#1F497D"><o:p>&nbsp;</o:p></span></p>
        <p class="MsoNormal"><span style="color:#1F497D">Perhaps someone
            else will found this snippet useful.<o:p></o:p></span></p>
        <p class="MsoNormal"><span style="color:#1F497D"><o:p>&nbsp;</o:p></span></p>
      </div>
    </blockquote>
    <br>
    One word of caution: While Connection.setReadOnly works fine for
    Embedded.&nbsp;&nbsp; There is a long standing&nbsp; issue with the call with
    Client:<br>
    <a class="moz-txt-link-freetext" href="https://issues.apache.org/jira/browse/DERBY-911">https://issues.apache.org/jira/browse/DERBY-911</a><br>
    <br>
    <br>
  </body>
</html>

--------------050403050908000107030306--