Export data from hsqldb

Openfire Openfire Support
1

Afternoon All,

We have a local intranet site with certain live stats on our company. I have been asked to get the status of each user on the IM software and show this on our intratnet too. We are using OpenFire 3.4.5 on Windows Server 2003 and using the HSQLDB embbeded database.

I was looking for a JDBC-ODBC Bridge Driver to do this but thought against it and thought that using hsqltool.jar would be better as I could run a batch file every 5mins to get the data I needed and dump it into a csv file and then import this into our MSSQL database that holds all the data for the site and code a ASP page to show the results nicely to the end users.

Does anyone have an example of how to run a sql file from command line and dumping the data into a csv file? Or if anyone knows of a better way to do this please share.

Many Thanks

Richard

2

Hi Richard,

What do you mean by status?

If its simply the online status, you may be better off using the Presence plugin. It allow for http access to users presence, which should be easy to use from your asp page.

Conor.

3

not to worry we are moving the database across to MS SQL now.