Object saving question

stringout · **Joined:** Fri Sep 28, 2007 6:28 pm **Posts:** 4

Hi, I have a little doubt.
Suppose I have a Question class and I do this:
******************
Question q = new Question();
q.setText("question1");
getSession.save(q);
*******************
that should persist the question in the db.
then in another moment(session) I repeat the same thing.

Then in my DB i get:
id text
1 question1
2 question1
BUT I want to get:
id text
1 question1

Please tell me I m doing something wrong. Thanks!

This is my mapping:

Code:

<hibernate-mapping>
    <class name="Question" table="QUESTION">
        <id name="id" column="ID">
            <generator class="native"/>
        </id>
        <property name="text" type="string"></property>
    </class>
<hibernate-mapping>

vbforums@yahoo.com · **Joined:** Fri Sep 28, 2007 7:40 pm **Posts:** 9

Options:
1. You can make that setText little intelligent to identify this scenario i.e setText will check the DB and if the value is alreay present it will do a save
2. You can go for composite key. Programming may be little tough if you just started hibernate

Thanks,
Venkat

kumar.hibernate · **Posted:** Fri Sep 28, 2007 10:24 pm

Little yhing u have to do
is
in before storing into DB u cross check the DB data ,meaning that get the list of the table QUESTION,and check the column text then if it is not available then add the record into the DB.....

I think iots the better thing we can do in programatically

stringout · **Joined:** Fri Sep 28, 2007 6:28 pm **Posts:** 4

I would like to do the composite way you ve told me. I think its the right way.
Could somebody provide some help for doing this?
thanks.

ganga_tanwar · **Joined:** Mon Oct 01, 2007 8:59 am **Posts:** 18

By using composite key you can not resist the second entry.
You make the property
unique="true"
it will solve your problem.
<hibernate-mapping>
<class name="Question" table="QUESTION">
<id name="id" column="ID">
<generator class="native"/>
</id>
<property name="text" type="string" unique="true"></property>
</class>
<hibernate-mapping>

stringout · **Joined:** Fri Sep 28, 2007 6:28 pm **Posts:** 4

ganga_tanwar wrote:

By using composite key you can not resist the second entry.
You make the property
unique="true"
it will solve your problem.
<hibernate-mapping>
<class name="Question" table="QUESTION">
<id name="id" column="ID">
<generator class="native"/>
</id>
<property name="text" type="string" unique="true"></property>
</class>
<hibernate-mapping>

I think that your solution wil cause a UNIQUE constraint violation when I save the second object...
No better solution?