[Solved] [HSQLDB] Jdbc driver: Table not found in statement

[newuser]

I'm running OOo 2.3.1 on Windows 2000 and I'm trying to create a JDBC connection to an empty database file created with HSQLDB version 1.8.0.9.

So far I've been able to load the driver ("org.hsqldb.jdbcDriver"), connect to the database ("jdbc:hsqldb:file:c:\mydb\test.db") and create a table, however I cannot open it with Base since double clicking on it returns the following error message:

"The data content could no be loaded, table not found in statement [SELECT * FROM "TestTable"]"

It seems to be a problem with database schema, even if the option Advanced Setting -> Use schema name in Select Statement is checked it is ignored.

Am I missing something?

Thanks in advance.

Edit: if anyone wants to test it, please note that adding the jar file to the class path of your JRE environment will prevent the embedded HSQLDB engine from working until you remove it.

[DrewJensen]

Hi,

Take a look at this page on the wiki:

http://wiki.services.openoffice.org/wik ... and_Tricks

Checkout the option default_schema for the JDBC driver - that will fix it for you.

[newuser]

Thanks a lot Drew, it works perfectly.

[DrewJensen]

Great -

Also

Edit: if anyone wants to test it, please note that adding the jar file to the class path of your JRE environment will prevent the embedded HSQLDB engine from working until you remove it.

This was a regression in the 2.3.1 release and has been fixed in the 2.4 release.