two tables:



itemno and storeid are a unique pair, identifying an item. For an item I may have a description, identified by the same pair.
I cannot use the "id" key instead of the pair.
itemno and storeid are modeled through a component.

Question: Is there a way to map the one-to-many relationship between item and itemdescription in hibernate 2?
Something like the property-ref attribute but that takes a component or more than one property?

Any suggestion?

setting up relationships between classes such as Users, Group


Group Contains
name:String
description:String
User Contains
email:String
password:String

A a one-to-many relationship exists between Groups and Users, since a group has many users. Users can exists outside of a group; that is, aggregation not composition (in database speak no cascade delete relationship exists between Groups and Users).

Group contains User. One-to-many Aggregation Bidirectional (Group<-->Users)


[Group.java]
/**
*
* @return
*
* @hibernate.bag name="users"
* cascade="save-update"
* lazy="true"
* inverse="true"
*
* @hibernate.collection-key
* column="FK_GROUP_ID"
*
* @hibernate.collection-one-to-many
* class="net.sf.hibernateExamples.User"
*/
public List getUsers() {
return users;
}

[User.java]
/**
* @hibernate.many-to-one
* column="FK_GROUP_ID"
* class="net.sf.hibernateExamples.Group"
*/
public Group getGroup() {
return group;
}

create table TBL_USER (PK_USER_ID BIGINT NOT NULL AUTO_INCREMENT,USER_TYPE VARCHAR(255) not null,FK_GROUP_ID BIGINT,VC_EMAIL VARCHAR(82) not null unique,primary key (PK_USER_ID))


create table TBL_GROUP (PK_GROUP_ID BIGINT NOT NULL AUTO_INCREMENT,VC_DESCRIPTION VARCHAR(255),VC_NAME VARCHAR(40) unique,primary key (PK_GROUP_ID))

alter table TBL_USER add index (FK_GROUP_ID), add constraint FK_111 foreign key FK_GROUP_ID)
references TBL_GROUP (PK_GROUP_ID)