Interacting with the HSQLDB

[Migrated From Jforum.net]

I have JForum installed, running and using HSQLDB. I read some of the documentation from the HSQLDB web site and I can interact with a test DB.

How do I interact the JForum HSQLDB tables?

What steps do I go through to get the results of:
select * from jforum_users;

Thanks...
[originally posted on jforum.net by spiderhere]

[Migrated From Jforum.net]

The default jforum hsqldb is started in embedded mode. If you want to access it while your jforum is running you will have to start it in server mode.

The hsqldb files for jforum are normally in config/database/hsqldb/jforum
[originally posted on jforum.net by marc]

[Migrated From Jforum.net]

Thanks for the info. Here is what I unsuccessfully tried.

# cd .../jforum/WEB-INF/config/database/hsqldb
java -classpath ../../../lib/hsqldb-1.7.3.0.jar org.hsqldb.Server &

[Server@19189e1]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@19189e1]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@19189e1]: Startup sequence initiated from main() method
[Server@19189e1]: Loaded properties from [/opt/SUNWwbsvr/https-ilsdev15.red.iplanet.com/webapps/https-ilsdev15.red.iplanet.com/jforum/WEB-INF/config/database/hsqldb/server.properties]
[Server@19189e1]: Initiating startup sequence...
[Server@19189e1]: Server socket opened successfully in 42 ms.
[Server@19189e1]: Database [index=0, id=0, db=file:test, alias=] opened sucessfully in 1202 ms.
[Server@19189e1]: Startup sequence completed in 1299 ms.
[Server@19189e1]: 2005-03-15 18:59:27.112 HSQLDB server 1.7.3 is online
[Server@19189e1]: To close normally, connect and execute SHUTDOWN SQL
[Server@19189e1]: From command line, use [Ctrl]+[C] to abort abruptly

*** At this point, hsqldb creates a test database in the directory I'm in.
Should I create a server.properties files? If yes, what should it look like?

# cat /sqltool.rc
urlid localhost-sa
url jdbc:hsqldb:hsql://localhost
username sa
password mypassword

# java -jar ../../../lib/hsqldb-1.7.3.0.jar localhost-sa
Failed to get a connection to jdbc:hsqldb:hsql://localhost as sa. Access is denied

*** I believe I fail to connect to the JForum db because the hsqldb server started up connected to the test db whereas I want to connect to the JForum db.

Any suggestions?


[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

you have to specifiy the name of the database you want to start, otherwise a new db 'test' will be created.

try this:

java -classpath ../../../lib/hsqldb-1.7.3.0.jar org.hsqldb.Server -database.0 jforum -dbname.0 jforum &
[originally posted on jforum.net by marc]