OpenOffice 3.3 with HSQLDB via JDBC
I had developed an application that stored some metrics in a HyperSQL database for offline processing and reporting with OpenOffice. It seemed simple enough - OpenOffice would connect to the database via JDBC, with the JDBC URL and driver class..trouble was, no matter what I did, the driver class would not be recognised! After endlessly searching on the web for a solution, I realised the piece of the puzzle I was missing - the version of the hsqldb jar file. The version 2.0.0 jar appears to be incompatible with OpenOffice 3.3 - Reverting back to 1.8.0.10 solves the problem, and the JDBC driver class is recognised. So I'll publish the process in full here, just in case anyone else runs into the same problem!
»