Scott S Nelson

I keep forgetting to post this. The table test query from the installer defaults to Derby/pointbase as:

SQL SELECT COUNT(*) FROM SYS.SYSTABLES

It should be:

SQL SELECT 1 FROM DUAL

if using an Oracle database and

SQL SELECT 1

if using MySQL.

See Default Test Table Name for more.

© Scott S. Nelson