How to persist a class using hibernate which is used in many different ways?

Question

I am new to hibernate world, still learning it. I am trying to persist one class in database using hibernate. Objects of this class can have different meaning in its client classes. Following is the class definition which I want to persist :

class Entity {
    int id;
    String name;
}

class ClientClass {
    int clientClassID;
    List<Entity> employerList;
    List<Entity> clientList;
}

Mapping file for ClientClass is as follows :

<hibernate-mapping package="com.foo.bar.model">
    <class name="ClientClass" table="CLIENTS">
        <id name="clientClassID" column="CLIENT_ID" type="integer"
            unsaved-value="0">
            <generator class="native" />
        </id>
        <set name="clientList" table="PROJECT_CLIENTS" cascade="all">
            <key column="CLIENT_ID" />
            <many-to-many column="CLIENT_ID" class="Entity" />
        </set>
        <property name="description" type="string" length="1000" />
        <set name="employerList" table="PROJECT_EMPLOYERS" cascade="all">
            <key column="CLIENT_ID" />
            <many-to-many column="EMPLOYER_ID" class="Entity" />
        </set>
         </class>
</hibernate-mapping>

I am not able to understand how to write mappings for Entity class? Please help me. If you need more details then please let me know.

Thanks in Advance !!!

powerMicha · Accepted Answer · 2011-11-02 07:39:00Z

1

You will have to map Entity as own class first.

<class name="Entity" table="ENTITY">
    <id name="id" column="id" type="integer"
        unsaved-value="0">
        <generator class="native" />
    </id>
    <property name="name" type="string" />
</class>

Then you can add it as Many-To-Many association in your other classes. I do not really understand how your mapping on EMPLOYER_NAME and CLIENT_ID should work.

For further documentation see: http://docs.jboss.org/hibernate/core/3.3/reference/en/html/collections.html#collections-ofvalues

edited Nov 2, 2011 at 7:39

answered Nov 2, 2011 at 7:24

powerMicha

2,7731 gold badge25 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Shekhar Over a year ago

thanks a lot for answer. If I do not want to create ENTITY table, then what should I do? Instead of ENTITY class, I want to create tables named CLIENT_LIST or EMPLOYER_LIST which have id and name columns.

powerMicha Over a year ago

Is it still many-to-many then? I think it is one-to-many but that's not the solution. I would create two further classes that extend Entity and map them. There is no possibility to map one entity on two tables.

Shekhar Over a year ago

okay, but then I have to create those subclasses unnecessarily just because hibernate cant do this. Actually earlier I had created different database schema but I was facing some problem in it. So I changed it to the one like above. I have posted question on SO. Here is the link for it : stackoverflow.com/questions/7964417/… . Please have a look at it.

Collectives™ on Stack Overflow

How to persist a class using hibernate which is used in many different ways?

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related