Hi I am trying to generate a unique-key for a table.
I have read the docs and tried what it said but still am unable to achieve desired results
Eg
<class
name="test"
table="t_table_test">
<property
name="field_1"
column="FIELD_1"
access="field"
not-null="true"
unique-key="field_1_2"
/>

<property
name="field_2"
access="field"
not-null="true"
column="FIELD_2"
unique-key="field_1_2"
/>
</class>

But I am still able to insert the same data more than once.
Any help would be appreciated.

Thx

Hi Shalvin,

Look into the thread below, Hope this helps:-)

http://forum.hibernate.org/viewtopic.ph ... highlight=

thx for the link
I am still not a 100% sure I know what to do. Do u have some sample that I could look at.

Gavin told us to use natural id for unique key....i have not tried it...Wait for others to reply..will try to do a sample and let you know...

Hi Shalvin,

I did it this way to maintaing unique result in database.

Criteria criteria = session.createCriteria(User.class);
User user = (User) criteria.add(Restrictions.naturalId().set("userId", userId)).setCacheable(true).uniqueResult();

where User Id should be unique in this case.

Hope this helps:-)