users@glassfish.java.net

Re: JPA - A Complex Relationship Scenario. Help!!!

From: <glassfish_at_javadesktop.org>
Date: Thu, 23 Jul 2009 14:14:28 PDT

I can think of a few possibilities:

1. are the data types of the FK's in MENTOR_TOPIC the same as the PK's they reference?
2. is a single composite PK defined for (id_user, id_mentor, id_topic)?

I assume you have a statements like:

ALTER TABLE MENTOR_TOPIC ADD CONSTRAINT PK_MENTOR_TOPIC
        PRIMARY KEY (id_user, id_mentor, id_topic);

ALTER TABLE MENTOR_TOPIC ADD CONSTRAINT FK_ID_TOPIC
        FOREIGN KEY (ID_TOPIC) REFERENCES TOPIC (ID_TOPIC);

etc... You will then see which FK is causing problems (instead of messages like MENTOR_TOPIC.FK_Constraint_1...)

3. Possible issue with JPA tools in Eclipse? I have always used Netbeans.

Hope this helps ;-)
[Message sent by forum member 'ggierer' (ggierer)]

http://forums.java.net/jive/thread.jspa?messageID=357308