If I have a table like so:

item item_name item_value

and I put a unique constraint on the item,

How do I tell my mapping abiout it? Most examples I have used, have had a surrogate key, like the below example. I would like the framework to not insrt when it sees another item with the same name (possibly case insensitive?).

Thanks,



Here is a mapping I tweaked, but I do not know how to handle the attributes for the item.

<hibernate-mapping>
<class name="com....Item" table="item" >
<item name="item" column="item" type="java.lang.String" unsaved-value="0">
<generator class="identity"/>???
</id>

<property name="itemname" column="item_name" type="java.lang.String" />
<property name="itemvalue" column="item_value" type="java.lang.String" />
</class>
</hibernate-mapping>

tag for those columns.

I'd rather implement this on the db side and just catch the exception, but this is how its done in mappings.

In the database, i have marked the item as unique.

So now in my mapping, do I need to put in a id? Or just use a property name for this?

Thanks,
Scott

oh yeah. If item is the primary key, designate it as the id in the mapping file. That will dictate to hibernate that it is the primary key and must be unique.