Mapping Question involving sets

nissimbst · **Joined:** Tue Nov 15, 2005 4:23 am **Posts:** 2

Hi,
I have a major problem in mapping my DB schema.
My DB schema is like that

Class Store{

Map<integer,ItemLocations> Items;

//item can be in more than one location;
}

class ItemLocations{

Set<string> locations;

}

class Item{
...
...
}

DB:

CREATE TABLE STORES ( ID NUMBER -->PK , ... )

CREATE TABLE ITEM_LOCATIONS
(
STORE_ID NUMBER NOT NULL, ---> PK
ITEM_ID NUMBER NOT NULL, ---> PK
LOCATION VARCHAR2(30 BYTE) ---->PK
)

CREAT TABLE ITEMS( ITEM_ID NUMBER NOT NULL --> PK ,
.... )

I think I should declare a composite-id but I haven't succeeded to understand how to, even after reading the reference document.

Can you help me with the mapping decleration for classes STORE and ITEM_LOCATIONS ??

I'm using Hibernate version 3.0.5

kochcp · **Posted:** Wed Nov 16, 2005 3:45 pm

Code:

<class
    name="package.Class" 
    table="table_name"
    
>
   
    <composite-id name="comp_id" class="package.class">
    
        <key-property 
            name="name" 
            column="name" 
            ...
        >
        </key-property>
        <key-property 
            name="name" 
            column="name" 
          ...
        >
          ...

nissimbst · **Joined:** Tue Nov 15, 2005 4:23 am **Posts:** 2

Can you specify it using my object names?

kochcp · **Posted:** Thu Nov 17, 2005 2:47 pm

sorry i do not have time to write out the schema using your names. what i have posted should be plenty of information to get a good start.

some useful links
http://www.hibernate.org/hib_docs/v3/re ... ompositeid
http://www.hibernate.org/hib_docs/v3/re ... pping.html