Page 1 of 1

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

Posted: Sat Mar 22, 2008 12:08 pm
by 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.

Re: [HSQLDB] Jdbc driver: Table not found in statement...

Posted: Sat Mar 22, 2008 10:11 pm
by 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.

Re: [HSQLDB] Jdbc driver: Table not found in statement...

Posted: Sun Mar 23, 2008 7:26 am
by newuser
Thanks a lot Drew, it works perfectly.

Re: [SOLVED][HSQLDB]Jdbc driver: Table not found in statement...

Posted: Sun Mar 23, 2008 3:08 pm
by DrewJensen
Great -

Also
newuser wrote: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.