Java error when connecting to Open Office Base Database

Java error when connecting to Open Office Base Database:

java.sql.SQLException: Wrong database file version
at org.hsqldb.jdbc.Util.sqlException(Util.java:365)
...

Try closing the Data Base before running the program.

Comments

Post a Comment

Popular posts from this blog

On Comments (*)

I do appreciate all the emails and comments received or to be received through this blog. Nevertheless, to avoid misunderstandings, I do not guarantee to reply all of them. I do apologize in advance. Carpe Diem,
Read more

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...
Read more