[Solved] [HSQLDB] Jdbc driver: Table not found in statement
Posted: Sat Mar 22, 2008 12:08 pm
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.
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.