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: error (athena.apache.org: local policy)
Message-ID: <520A6D0F.1040307@sbcglobal.net>
Date: Tue, 13 Aug 2013 10:29:51 -0700
From: Katherine Marsden <kmarsdenderby@sbcglobal.net>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
 rv:17.0) Gecko/20130620 Thunderbird/17.0.7
MIME-Version: 1.0
To: Derby Discussion <derby-user@db.apache.org>
Subject: Re: Strange situation
References: 
 <FA2097F81290A640BDA96A31434295600134533EF847@MXPJFMAILBO.PJF.gob.mx>
In-Reply-To: 
 <FA2097F81290A640BDA96A31434295600134533EF847@MXPJFMAILBO.PJF.gob.mx>
Content-Type: multipart/alternative;
 boundary="------------020008020003020406050206"

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

On 8/13/2013 7:37 AM, Carlos de Luna Saenz wrote:
>
> We have a stange behavour in a database that is "imported" from a SQL 
> Server DB.
>
> On Windows Derby shows all records fine, but when used as "read only" 
> (root admin owned with 755) on Mac there is a table that shows as 
> empty (0 records) when the same DB in Windows has 1310 records.
>
> for accessing the DB we are using the Emmbeded driver...
>
> We found that the first time the DB is used on Mac or windows there 
> are some files changes (if 777 is set as permissions) and then the 
> records are shown, but the installation program is not seting (and we 
> don't want) those priviledges to the derby files...
>
> Any idea on WHY this is happenning? we are looking how to get files 
> that works with the install but we would like to know what do we have 
> to be aware to prevent this "data lose" when copying the DB.
>
> Greetings
>
My guess is that you did not shutdown the database before deploying read 
only.  See this information for preparing a database for read-only use:
http://db.apache.org/derby/docs/10.10/devguide/tdevdeploy26887.html

> *Ing. Carlos de Luna S�enz *| Direcci�n de Sistematizaci�n de Tesis - 
> Director de �rea |
>
> Direcci�n General de Tecnolog�as de la Informaci�n | *Suprema Corte de 
> Justicia de la Naci�n*
>
> T. +52.55. 4113-1000 ext. 1174 | C: cluna@scjn.gob.mx 
> <mailto:cluna@scjn.gob.mx>
>


--------------020008020003020406050206
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/13/2013 7:37 AM, Carlos de Luna
      Saenz wrote:<br>
    </div>
    <blockquote
cite="mid:FA2097F81290A640BDA96A31434295600134533EF847@MXPJFMAILBO.PJF.gob.mx"
      type="cite">
      <meta http-equiv="Content-Type" content="text/html;
        charset=ISO-8859-1">
      <meta name="Generator" content="Microsoft Word 14 (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:"Century Gothic";
	panose-1:2 11 5 2 2 2 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Calibri","sans-serif";
	mso-fareast-language:EN-US;}
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.EstiloCorreo17
	{mso-style-type:personal-compose;
	font-family:"Calibri","sans-serif";
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-family:"Calibri","sans-serif";
	mso-fareast-language:EN-US;}
@page WordSection1
	{size:612.0pt 792.0pt;
	margin:70.85pt 3.0cm 70.85pt 3.0cm;}
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">We have a stange behavour in a database
          that is "imported" from a SQL Server DB.<o:p></o:p></p>
        <p class="MsoNormal">On Windows Derby shows all records fine,
          but when used as "read only" (root admin owned with 755) on
          Mac there is a table that shows as empty (0 records) when the
          same DB in Windows has 1310 records.<o:p></o:p></p>
        <p class="MsoNormal">for accessing the DB we are using the
          Emmbeded driver&#8230;<o:p></o:p></p>
        <p class="MsoNormal">We found that the first time the DB is used
          on Mac or windows there are some files changes (if 777 is set
          as permissions) and then the records are shown, but the
          installation program is not seting (and we don't want) those
          priviledges to the derby files&#8230;<o:p></o:p></p>
        <p class="MsoNormal">Any idea on WHY this is happenning? we are
          looking how to get files that works with the install but we
          would like to know what do we have to be aware to prevent this
          "data lose" when copying the DB.<o:p></o:p></p>
        <p class="MsoNormal">Greetings<o:p></o:p></p>
        <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
      </div>
    </blockquote>
    My guess is that you did not shutdown the database before deploying
    read only.&nbsp; See this information for preparing a database for
    read-only use:<br>
    <a class="moz-txt-link-freetext" href="http://db.apache.org/derby/docs/10.10/devguide/tdevdeploy26887.html">http://db.apache.org/derby/docs/10.10/devguide/tdevdeploy26887.html</a><br>
    <br>
    <blockquote
cite="mid:FA2097F81290A640BDA96A31434295600134533EF847@MXPJFMAILBO.PJF.gob.mx"
      type="cite">
      <div class="WordSection1">
        <p class="MsoNormal"><span style="mso-fareast-language:ES"><o:p>&nbsp;</o:p></span></p>
        <p class="MsoNormal"><b><span
              style="font-size:10.0pt;font-family:&quot;Century
              Gothic&quot;,&quot;sans-serif&quot;;mso-fareast-language:ES"
              lang="ES-MX">Ing. Carlos de Luna S&aacute;enz </span></b><span
            style="font-size:10.0pt;font-family:&quot;Century
            Gothic&quot;,&quot;sans-serif&quot;;mso-fareast-language:ES"
            lang="ES-MX">| Direcci&oacute;n de Sistematizaci&oacute;n de Tesis -
            Director de &Aacute;rea |<o:p></o:p></span></p>
        <p class="MsoNormal"><span
            style="font-size:10.0pt;font-family:&quot;Century
            Gothic&quot;,&quot;sans-serif&quot;;mso-fareast-language:ES"
            lang="ES-MX">Direcci&oacute;n General de Tecnolog&iacute;as de la
            Informaci&oacute;n | <b>Suprema Corte de Justicia de la Naci&oacute;n<o:p></o:p></b></span></p>
        <p class="MsoNormal"><span style="font-family:&quot;Century
            Gothic&quot;,&quot;sans-serif&quot;;mso-fareast-language:ES"
            lang="EN-US">T. +52.55. 4113-1000 ext. 1174 | C: <a
              moz-do-not-send="true" href="mailto:cluna@scjn.gob.mx"><span
                style="color:blue">cluna@scjn.gob.mx</span></a><o:p></o:p></span></p>
        <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
        <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
      </div>
    </blockquote>
    <br>
  </body>
</html>

--------------020008020003020406050206--