How do we represent the following relationships in hibernate.

Here OrganizationExamSource table have a composite primary key.
each of the columns(organizationId and examSourceId ) are the primary keys of other two tables

OrganizationExamSource (
organizationId BIGINT NOT NULL REFERENCES Organization(organizationId),
examSourceId BIGINT NOT NULL REFERENCES ExamSource(examsourcerecordId),
noAccess int NOT NULL DEFAULT 0,
PRIMARY KEY (organizationId, examSourceId)
);


Organization (
organizationId BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY, -- auto generated interal ID
parentId BIGINT REFERENCES Organization(organizationId),
orgName VARCHAR(255) NOT NULL,
address1 VARCHAR(255)
address2 VARCHAR(255)
orgDesc TEXT, -- description
UNIQUE INDEX (parentId, orgName) -- ensure names are unique at each level
);


ExamSource (
examsourcerecordId BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
sourceName VARCHAR (255) NOT NULL,
isActive INT NOT NULL DEFAULT 1,
UNIQUE INDEX (sourceName)
);[/quote]

If your OrganizationExamSource is only an association table, you can use a many-to-many between Organization and ExamSource (http://www.hibernate.org/hib_docs/v3/reference/en/html/associations.html#assoc-bidirectional-join-m2m) and don't have to define a <class> for OrganizationExamSource.

But it looks like you have extra fields in the association table (e.g. 'noAccess'), so you probably want to set it up as two many-to-ones (http://www.hibernate.org/hib_docs/v3/reference/en/html/associations.html#assoc-bidirectional-m21).

So your OrganizationExamSource would have two <many-to-one> associations (to Organization and ExamSource), and Organization and ExamSource would each have a matching inverse <set> association.

Hope that helps.

I realized that I mis-spoke a little. I am used to always using surrogate keys. If you want your OrganizationExamSource primary key to be the two foreign key columns, instead of using <many-to-one> tags in the OrganizationExamSource class, you would use <key-many-to-one> inside the <composite-id> tag (http://www.hibernate.org/hib_docs/v3/reference/en/html/mapping.html#mapping-declaration-compositeid).

Thanks Nathan