From derby-user-return-15164-apmail-db-derby-user-archive=db.apache.org@db.apache.org Tue Aug 13 14:38:29 2013 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 12A7EFF39 for ; Tue, 13 Aug 2013 14:38:29 +0000 (UTC) Received: (qmail 78391 invoked by uid 500); 13 Aug 2013 14:38:28 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 78196 invoked by uid 500); 13 Aug 2013 14:38:21 -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 78188 invoked by uid 99); 13 Aug 2013 14:38:20 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 13 Aug 2013 14:38:20 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [201.116.131.108] (HELO SCJNSMTP1.scjn.gob.mx) (201.116.131.108) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 13 Aug 2013 14:38:15 +0000 Received: from pjfmailpscas1.PJF.gob.mx (192.168.240.48) by SCJNSMTP1.scjn.gob.mx (192.168.240.240) with Microsoft SMTP Server (TLS) id 8.2.255.0; Tue, 13 Aug 2013 09:35:41 -0500 Received: from pjfmailbocas1.PJF.gob.mx (172.16.31.15) by pjfmailpscas1.PJF.gob.mx (172.16.12.244) with Microsoft SMTP Server (TLS) id 8.2.255.0; Tue, 13 Aug 2013 09:37:30 -0500 Received: from MXPJFMAILBO.PJF.gob.mx ([fe80::fdf5:c99c:7d45:3410]) by pjfmailbocas1.PJF.gob.mx ([fe80::107e:f1fb:be1f:2e0a%10]) with mapi; Tue, 13 Aug 2013 09:37:26 -0500 From: Carlos de Luna Saenz To: "derby-user@db.apache.org" Date: Tue, 13 Aug 2013 09:37:26 -0500 Subject: Strange situation Thread-Topic: Strange situation Thread-Index: Ac6YMT2X32OfQMNfRNCwanntrONRxg== Message-ID: Accept-Language: es-ES, en-US Content-Language: es-ES X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: es-ES, en-US Content-Type: multipart/alternative; boundary="_000_FA2097F81290A640BDA96A31434295600134533EF847MXPJFMAILBO_" MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org --_000_FA2097F81290A640BDA96A31434295600134533EF847MXPJFMAILBO_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable We have a stange behavour in a database that is "imported" from a SQL Serve= r 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 recor= ds) 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 som= e files changes (if 777 is set as permissions) and then the records are sho= wn, but the installation program is not seting (and we don't want) those pr= iviledges to the derby files... Any idea on WHY this is happenning? we are looking how to get files that wo= rks 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 Ing. Carlos de Luna S=E1enz | Direcci=F3n de Sistematizaci=F3n de Tesis - D= irector de =C1rea | Direcci=F3n General de Tecnolog=EDas de la Informaci=F3n | Suprema Corte de= Justicia de la Naci=F3n T. +52.55. 4113-1000 ext. 1174 | C: cluna@scjn.gob.mx --_000_FA2097F81290A640BDA96A31434295600134533EF847MXPJFMAILBO_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

We have a stange b= ehavour in a database that is "imported" from a SQL Server DB.

On Windows Derby shows all records fine, b= ut when used as "read only" (root admin owned with 755) on Mac th= ere is a table that shows as empty (0 records) when the same DB in Windows = has 1310 records.

for accessing the DB w= e are using the Emmbeded driver…

W= e 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 show= n, but the installation program is not seting (and we don't want) those pri= viledges to the derby files…

Any i= dea on WHY this is happenning? we are looking how to get files that works w= ith the install but we would like to know what do we have to be aware to pr= event this "data lose" when copying the DB.

Greetings

 

&nbs= p;

Ing. Carlos de Luna S=E1enz | Direcci=F3n de Sistematizaci=F3n de Tesis - Director de =C1rea |

T. +52.55. 4113-1000 ext. 1174 | C: cluna@scjn.gob.mx<= o:p>

 

 

= --_000_FA2097F81290A640BDA96A31434295600134533EF847MXPJFMAILBO_--