hypersonic database client

[saldokan]

Hi all,
Does Hypersonic that comes with jboss have a client I can use to look at the database?
Thanks,
Sam.

[mkuusela]

Hi,

In the hsqldb.jar there's a utility called org.hsqldb.util.DatabaseManager. The jar -file is located in the %JBOSS_DIST%/lib/ext -directory.

Regards,
Mika

[saldokan]

Thanks Mika. I ran the client fine. However It seems the tables Jboss created for my entity beans are not there. I don't have problem finding the entities from the Java program. I am trying the CD example posted on jboss.org.
Thanks,
Sam.

[ppetit]

2 things to check :
give the real URL of the directory containing the data files (ie under window : c:\jboss\db\hypersonic)
JBoss should be halted, because of conflicting access

hope this helps
Philippe

[saldokan]

Thanks Philippe! Now I can see the tables. It seems that JBoss creates a default database file named 'default.data' where it stores the tables. However, why the size of default.data or any database file I create for that matter is only 20 bytes?! This is the case even when I created and populated tables in the database. This does not seem right.
Thanks,
Sam.

[mattbishop]

The data file is tiny because hypersonic is an in-memory database, not a disk database; it can run as a disk-based database, but this is not it's default setting.

You can set it to become a disk-based db by using a slightly different create table command: CREATE CACHED TABLE

I am looking for a way to get jboss to do this by default. Any ideas?

[burnsanthony]

how do I use this utility

[umabush]

How did you run the client. Did you use from DOS prompt java DatabaseManager. If so do you needed to set CLASSPATH
thank you