Re: [Hsqldb-developers] Re: database in jar

[fredt <fr...@us...>]

Thanks Brendan

I think the issue of where to put the database in the jar file and how to
access it via the jdbc url needs clarification and an example for the
average user. I take your example to mean the following:

The relative location of the database as taken from the jdbc url is used.
For example, if the url is specified as "jdbc:hsqldb:testdata/felder.hsqldb"
then the database is loaded from the "testdata/" directory in the jar
and the database file names are "felder.hsqldb.properties" and
felder.hsqldb.script" in that directory.

So a more generic example of the directory structure of the jar including
the database files and the corresponding url would be appreciated.

Fred

----- Original Message -----
From: "Brendan Ryan" <br...@in...>
To: <hsq...@li...>
Sent: 29 April 2003 14:21
Subject: [Hsqldb-developers] Re: database in jar


Hi Fred,

This works perfectly (in my application at least).

You may wish to update "doc/databaseinjar.txt" in the sample jnlp file, text
line 42:

old:    <property name="hsqldb.dbjarfile" value="true"/>
new:  <property name="hsqldb.files_in_jar" value="true"/>

Axel:

Remember that you must set the system property hsqldb.files_in_jar to "true"
for the database load from a jar file to work. When this is the case, the
database is loaded using a getResourceAsStream method instead of a file
access, as shown in the following code snippet:

            if (JARFILE) {
                fis = this.getClass().getClassLoader().getResourceAsStream(
                    fileName + ".properties");
            } else {
                File f = new File(fileName + ".properties");

                fis = new FileInputStream(f);
            }

The variable fileName contains the relative location of the database as
taken from the jdbc url. Fro example, if the url is specified as
"jdbc:hsqldb:testdata/felder.hsqldb" then the database is loaded from
"testdata/felder.hsqldb.properties".

Regards
Brendan


----- Original Message -----
From: "fredt" <fr...@us...>
To: "Brendan Ryan" <br...@in...>;
<hsq...@li...>
Sent: Tuesday, April 29, 2003 11:16 AM
Subject: Re: [Hsqldb-developers] Re: hsqldb-developers digest, Vol 1 #217 -
1 msg


> Hi Brendan,
>
> I modified your code for the current CVS and committed it. The relevant
> property is now called hsqldb.files_in_jar. It would be a good idea if you
> could checkout the CVS hsqldb-dev HEAD and test this capability.
>
> Fred
>
> ----- Original Message -----
> From: "Brendan Ryan" <br...@in...>
> To: <hsq...@li...>
> Sent: 29 April 2003 07:33
> Subject: [Hsqldb-developers] Re: hsqldb-developers digest, Vol 1 #217 - 1
> msg
>
>
> Hi Axel,
>
> Yes it is possible with some small changes in the source. I use it for an
> application started using Java Web Start.
>
> I sent these changes to this list a few months ago. I can send you a copy
of
> the patch or my modified jar file if you prefer.
>
> Fred - How about integrating this change into the standard. I can make a
> patch for the current cvs sources.
>
> Regards
> Brendan
>
> ----- Original Message ----- > Subject: [Hsqldb-developers] DB included in
> JAR file
> >
> > Hi everybody,
> >
> > is it possible to put a database into a JAR attached to an applet ?
> >
> > I have an application which I intend to convert into an applet, but the
> > data within the database is only selected, neither modified, deleted nor
> > extended.
> >
> > Any hints ?
> >
> > Axel.
> >
>
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> hsqldb-developers mailing list
> hsq...@li...
> https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
>
>
>




-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
hsqldb-developers mailing list
hsq...@li...
https://lists.sourceforge.net/lists/listinfo/hsqldb-developers