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: 88.198.21.77 is neither permitted
 nor denied by domain of malesch@gmail.com)
Message-ID: <4B169EED.5080609@gmail.com>
Date: Wed, 02 Dec 2009 18:07:57 +0100
From: malesch <malesch@gmail.com>
User-Agent: Thunderbird 2.0.0.23 (X11/20090817)
MIME-Version: 1.0
To: Derby Discussion <derby-user@db.apache.org>
Subject: Re: Different DB behavior loaded from JAR vs. file system
References: <4B1546CD.3010907@gmail.com> <x1oxiqcq1rmv.fsf@sun.com>
In-Reply-To: <x1oxiqcq1rmv.fsf@sun.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Hi Dag

I connect to my DB with the same user name with the default schema APP
and, what I forgot to mention last time, the DB is encrypted.

Now while creating a little program to demonstrate the effect I stumbled
over something pointing to a possible explanation :-). I realized that
in my demo with the extracted DB (on the file system) the expected
tables didn't show up (like in the JAR case). Disappointed I opened the
same DB with SquirellSQL and, surprise, the tables were there again.
After this opening with SquirellSQL my demo programm showed again the
previously missing tables.

Is there some transaction log which is not commited and what would be
the reason for this (simply not properly commiting/closing the DB?)

Greetings,
marcus


Dag H. Wanvik wrote:
> malesch <malesch@gmail.com> writes:
> 
>> I am seeing some very strange behavior with my Derby DB
>> (version 10.4.2.0 and 10.5.3.0).
>>
>> If I load my DB from a JAR file, I am missing some table
>> entries, that are existing if I extract the DB from the
>> same JAR file and load it from the file system.
>>
>> How can I understand this behavior, is there an
>> explanation for this?
> 
> That seems weird. Are you connecting with the same user name (or none)
> in the two scenarios? Occasionally we see users miss some tables
> because they end up in an unexpected schema; the default schema is the
> user name (or "APP" if not provided).
> 
> If this is not the issue, are you able to provide a repro for it?
> 
> Thanks,
> Dag