Skip to Main Content
Forums

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

BUG No Toplink with HSQLDB support

Vytenis BivainisDec 7 2006 — edited Dec 7 2006
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.

Comments

Hi,

don't have HSQLDB for testing, but typing HSQLDB TopLink into a Google search brought up many messages of people that got this combination working.

I suggest to post this question on the TopLink forum here on OTN

Frank
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 4 2007
Added on Dec 7 2006
#application-development-in-java, #jdeveloper-and-adf
1 comment
219 views