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.
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.
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
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.
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?
how do I use this utility
How did you run the client. Did you use from DOS prompt java DatabaseManager. If so do you needed to set CLASSPATH