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: pass (asf.osuosl.org: domain of alberto.molpeceres@gmail.com
 designates 66.249.82.193 as permitted sender)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition;
        b=qc60m/P22yr6YujOVPyMdWNjmlWW0iE6gUJO7RR/qq+HKQBjoPxaNG6rMxRQvTy/GBNUqMdm8/Y146+ly4q8CoIr7alfatLoqzTucwkkgAHrRmCZfJrHGroT/U9O7HRgLVFZ9j3f+woZnORPTAqcSi6/5qNjgH5Gg4rnb7uZZaw=
Message-ID: <7338a19f0605290415v72a0136te90001557b792f73@mail.gmail.com>
Date: Mon, 29 May 2006 13:15:05 +0200
From: "Alberto Molpeceres" <alberto.molpeceres@gmail.com>
To: derby-user@db.apache.org
Subject: problem with embeded derby database and javawebstart
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi all,

This is my first mail to the list, so, I want to say hello to all
members. Greetings from Spain :-D.

Well, we are working in a Java Web Start application that use a
database as  source of information. Till now he have do our
test&deploy in intranet enviroments, so we used a central postgres
database.

Now we have to write a internet version of our application using an
embeded database for read only data. We are trying to use derby
embeded with this database compressed in a jar file, but we are not
very lucky till now, the console reports that the database can't be
found :-(.

Database's jar is referenced in the JNLP file, and it's in the same
place as all other jars, so it shouldn't be a problem, still we
receive a:

SQL Exception: Failed to start database 'jar:(database.jar)/testDB',
see the next exception for details.
...
Java exception: 'No such file or directory: java.util.zip.ZipException'.
java.util.zip.ZipException: No such file or directory

Our relevant connection information is:

    databaseDriverName =3D "org.apache.derby.jdbc.EmbeddedDriver";
    connectionURL =3D "jdbc:derby:jar:(database.jar)/testDB";

This database works fine using it as a desktop application and
referenced from it's folder in the URL, and the JWS application has
all permissions.

Any idea?. Are we missing something in the URL?. Can't a derby
database be loaded from a jar in a Java web start application?.

Thank you very much for you attention,

    al.