Java: Creating a JDBC Connection to OpenOffice.Org Databases
Download "hsqldb_1_8_0_10.zip" (HSQLD DB ENGINE) from http://sourceforge.net/project/downloading.php?group_id=23316&use_mirror=ovh&filename=hsqldb_1_8_0_10.zip&84223716 Extracted [adapted] from: http://digiassn.blogspot.com/2006/07/java-creating-jdbc-connection-to.html Java: Creating a JDBC Connection to OpenOffice.Org Databases The following example will open an OpenOffice.org Base file via the Java ZIP classes, extract the necessary files to the temporary folder, create the JDBC connection using the HSQLDB JDBC driver, query, then delete the temp files. import java.sql.*; import java.util.zip.*; import java.io.*; import org.hsqldb.jdbcDriver; import java.util.*; public class Test { public static void main(String[] args) { jdbcDriver j = new jdbcDriver(); //Instantiate the jdbcDriver from HSQL Connection con = null; //Database objects Statement com = null; ResultSet rec = null; ZipFile file = null; //For hand...