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.