0

I am trying to connect to an OpenOffice Base database from Java and execute a query, and have not been able to.

These are the steps I followed:

1) Created a Database 'TestDB.odb' in OpenOffice, and a table 'Movies' with columns (ID, Name, Director)

2) Downloaded hsqldb jar file and inclued in project build path

3) Used the following code to connect to it:

String file_name_prefix = "C:/Documents and Settings/327701/My Documents/TestDB.odb";
Connection con = null;
Class.forName("org.hsqldb.jdbcDriver"); 
con = DriverManager.getConnection("jdbc:hsqldb:file:" + file_name_prefix, "sa","");
Statement statement = con.createStatement();
String query1 = "SELECT * FROM \"Movies\"";
ResultSet rs = statement.executeQuery(query1);

Althoug I'm able to connect to the Database, it throws the following exception on trying to execute the query:

org.hsqldb.HsqlException: user lacks privilege or object not found: Movies

Tried googling, but have not been able to resolve my problem. I'm stuck and it would be great if someone could guide me on how to fix this issue?

Chillax
  • 4,418
  • 21
  • 56
  • 91

2 Answers2

1

You cannot connect to an .odb database. The database you have connected to is in fact a separeate set of files with names such as TestDB.odb.script, etc.

Check http://user.services.openoffice.org/en/forum/viewtopic.php?f=83&t=17567 on how to use an HSQLDB database externally from OOo in server mode. You can connect to such databases with the HSQLDB jar.

fredt
  • 24,044
  • 3
  • 40
  • 61
0

OLD thread.

I lost 2 days of my life until I changed the property:

spring.jpa.properties.hibernate.globally_quoted_identifiers = false

I was using mysql before and then I changed to hsqldb in order to run some tests. I kinda copied and pasted this property without looking and then you know - Murphy's law ...

I hope it helps.

agodinhost
  • 381
  • 4
  • 16