powered by Jive Software

HSQLDB connection

Hi I want to connect to the embedded data base that openfire creates on install, pull info from this data base and print to a file. I am studying java in college and plan to do it using a simple java program.

I plan to :
Connect to database using url.
use java.sql to pull data out from the openfire database
print certain information from this database to a file

What port does the embedded database listen on or is it even listening on a port as it is embedded?
Am I doing this the best way or should I be doing it some other way instead?

Thanks

Embedded database is a simple text file loaded into memory on Openfire startup (/openfire/embedded-db/openfire.script). It can’t listen to ports as it is not a normal database.

Thank you for your help