AppletTalk.com

Daniel Marzano · Guest

Hello,

From the hsqldb 1.7.2 readme.txt file:

FILES IN JAR

This option allows database files to be distributed in the
application jar. We have changed the original contribution so
that a special URL is used for this mode in the form of:

jdbc:hsqldb:res:<path in jar>

The URL type 'res' determines that the path that follows is a path
into the JAR.

Could someone give me an example of usage?

The jar file is located at M:/dmarzano/LucidPlayer.jar

I have tried various combinations of the url and have not had much luck, eg.

"jdbc:hsqldb:res:jar:file:/M:/dmarzano/LucidPlayer.jar!/spiders"
"jdbc:hsqldb:res:file:/M:/dmarzano/LucidPlayer.jar!/spiders"
"jdbc:hsqldb:res:jar:file:/M:/dmarzano/LucidPlayer.jar/spiders"
"jdbc:hsqldb:res:M:/dmarzano/LucidPlayer.jar!/spiders"
"jdbc:hsqldb:res:file:/M:/dmarzano/LucidPlayer.jar/spiders"

Thanks,
Daniel

Vasiliy Malakhov · Guest

Create a database and put the files in jar, like this:
[malakhov@midas-11 29]$ jar tf db.jar
META-INF/
META-INF/MANIFEST.MF
db/jardb.log
db/jardb.properties
db/jardb.script
[malakhov@midas-11 29]$

This jar should be in the classpath:
java -cp /usr/hsqldb/lib/hsqldb.jar:jardb.jar org.hsqldb.util.DatabaseManager

In this case the URL is
jdbc:hsqldb:res:/db/jardb
(path inside of the jar, not in the filesystem).

[email]D.Marzano (AT) cbit (DOT) uq.edu.au[/email] (Daniel Marzano) wrote in message news:<10dbe0de.0311132144.2ed50032 (AT) posting (DOT) google.com>...