I get an error from seam generate-entities for the following situations.

table locale

locale_id integer NOT NULL,
locale_name varchar(10) NOT NULL,
locale_desc varchar(50) NOT NULL,
PRIMARY KEY(locale_id)

table user

user_id integer NOT NULL,
locale_id integer NOT NULL,
.....
PRIMARY KEY(user_id, locale_id)
FOREIGN KEY(locale_id) REFERENCES locale(locale_id) ON DELETE RESTRICT

table foo

foo_id integer NOT NULL,
locale_id integer NOT NULL,
foo_user1 integer NOT NULL,
foo_user2 integer NOT NULL,
...
PRIMARY KEY(foo_id, locale_id)
FOREIGN KEY(locale_id) REFERENCES locale(locale_id) ON DELETE RESTRICT
FOREIGN KEY(foo_user1) REFERENCES user(user_id) ON DELETE RESTRICT
FOREIGN KEY(foo_user2) REFERENCES user(user_id) ON DELETE RESTRICT


FooHome will have two UserHome declarations and a compiler error results.

I see this error.

org.hibernate.AnnotationException: A Foreign key refering User from Foo has the wrong number of colum. should be 2.

Thanks,

M