Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

It looks like your problem stems from the HSQL version you are using. The embedded version which comes with Base does not work with that select statement. This statement:

SELECT * FROM "INFORMATION_SCHEMA"."COLUMNS" WHERE "TABLE_NAME" = 'TEST1' ORDER BY "ORDINAL_POSITION"

works in HSQL 2.x or later. If you are not already using a 'split DB' you may want to consider this: click here. If you already are using a split DB, just upgrade to a later version of HSQL.

It looks like your problem stems from the HSQL version you are using. The embedded version which comes with Base does not work with that select statement. This statement:

SELECT * FROM "INFORMATION_SCHEMA"."COLUMNS" WHERE "TABLE_NAME" = 'TEST1' ORDER BY "ORDINAL_POSITION"

works in HSQL 2.x or later. If you are not already using a 'split DB' you may want to consider this: click here. If you already are using a split DB, just upgrade to a later version of HSQL.

Edit:

Using the embedded HSQL, use the following statement:

SELECT * FROM INFORMATION_SCHEMA.SYSTEM_COLUMNS WHERE TABLE_NAME = 'ISSUE2' ORDER BY ORDINAL_POSITION