BUG No Toplink with HSQLDB support
1. Start HSQLDB in server mode
2. Log in as SA
3. Create two tables (in public schema, which is the default) with parent-child relation
4. Create new schema, switch to new schema
5. Create two tables (in public schema, which is the default) with parent-child relation in new schema
6. Create HSQLDB library in JDeveloper
6. Create connection in JDeveloper jdbc:hsqldb:hsql://...
7. Create JDeveloper project
8. Create Toplink map
9. Start "Java Objects from Tables" wizard.
10a. Select a table from public schema
11a. "Public schema is only for synonyms" error message appears
10b. Select a child table from the other schema.
11b. "A foreign key constraint must define at least one column" error message appears
I am using JDeveloper 10.1.3.1.0.3914 and HSQLDB 1.8.0.