Re: [Hsqldb-user] Custom Database Properties

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

In 1.7.2 you can access the defined properties via the SYSTEM_PROPERTIES
table.

The proper way of storing a schema version is via the custom table solution.
The .properties file should only contain key/value pairs that are supported
by the engine. The full release is likely to discard any unrecognised
properties.

Fred

----- Original Message ----- 
From: "Coup, Robert Muir" <r....@au...>
To: <hsq...@li...>
Sent: 23 March 2004 03:57
Subject: [Hsqldb-user] Custom Database Properties


Hi all,

Since HSQLDB uses a standard Java Properties set in database.properties
- is there any way to access this collection at runtime?

What I would like to do is implement a db schema version property in our
system. Then when a client accesses a database it can run scripts to
upgrade the schema before accessing the data. The nice way as I see it
would be to add it to the hsqldb database.properties.

Another way which is less nice is to create a table with one field and
one row containing the version...

Thanks,

Rob :)





-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id70&alloc_id638&op=ick
_______________________________________________
Hsqldb-user mailing list
Hsq...@li...
https://lists.sourceforge.net/lists/listinfo/hsqldb-user