使用jdbc程序连接到Open Office odb文件 [英] Connect to Open Office odb file using jdbc program

问题描述

我编写了以下代码以连接到OpenOffice db.

I had written following code to connect to OpenOffice db .

String db = "C:\\Documents and Settings\\hkonakanchi\\Desktop\\Test.odb";
Class.forName("org.hsqldb.jdbcDriver");
Connection con =  DriverManager.getConnection("jdbc:hsqldb:file:" + db,"sa","");
Statement statement = con.createStatement();
ResultSet rs = statement.executeQuery("SELECT * FROM Emp");
while (rs.next()) {
System.out.print("ID: " + rs.getString("ID"));
System.out.print(" first name: " + rs.getString("firstname"));
System.out.println(" last name: " + rs.getString("lastname"));
}
con.close();

数据库包含emp表并保存了一些数据.

The database contains emp table and saved some data.

但是我收到如下错误消息.

But I get error message as follows.

Exception in thread "main" java.sql.SQLException: 
Table not found in statement [SELECT * FROM Emp]
        at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
        at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
        at org.hsqldb.jdbc.jdbcStatement.executeQuery(Unknown Source)
        at Test.main(Test.java:16)

我该如何解决.谁能告诉我如何使用hsqldb驱动程序连接到开放式办公室db?

How could I resolve this. Could anyone tell me how to connect to open office db using hsqldb driver?

推荐答案

最后，我找到了解决方案.但不幸的是，您必须将数据库从odb更改为hsql.

finally I found the solution. but unfortunately you have to change your db from odb to hsql.

1.将odb文件重命名为yourdatabasename.zip

1.rename your odb file to yourdatabasename.zip

2.提取它

3.现在您可以在数据库文件夹下的数据库目录中找到备份，数据，脚本，属性文件.

3.now you can find backup,data,script,properties files in database directory under you database folder.

4.将这些文件重命名为yourdatabasename.data，yourdatabasename.backup，yourdatabasename.script，yourdatabasename.properties

4.rename these files to yourdatabasename.data,yourdatabasename.backup,yourdatabasename.script,yourdatabasename.properties

5.现在您的连接应如下所示: "jdbc:hsqldb:file:Addressto您的数据库/数据库/您的数据库名称"

5.now your connection should be like this: "jdbc:hsqldb:file:Addresstoyourdatabase/database/yourdatabasename"

6.不要忘记在表名周围加上"，例如: "SELECT * FROM \" Emp \"

6.do not forget to put " around your table name like: "SELECT * FROM \"Emp\""

这篇关于使用jdbc程序连接到Open Office odb文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！