Problem with unique and unique-key

[Suhas Bilaye]

Hi,

I have a table called category in the database which has 2 columns. Id(Primary key) and Title (should be unique)

I am trying to specify that this title should be unique. I am using the hbm file for mapping.
Please see the file as below.

   <?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<!--
    Document   : Category.xml
    Created on : November 10, 2009, 12:43 PM
    Author     : 15760
    Description:
        Purpose of the document follows.
-->

<hibernate-mapping>
    <class name="entity.Category" table="category">
        <id name="id" column="id" 
        type="java.lang.Integer">
            <generator class="native"/>
        </id>
        
        <property name="title"
        column="title" type="java.lang.String" unique-key="true" unique="true"/>
 </class>
</hibernate-mapping>
 

whether is specify unique = true or unique-key = true and try to save a category whose title is "Soaps" multiple times
it still gets saved. The id is automatically generated by using an autoincrement option.., how do i force so that the category should not be saved multiple times .. with the same title.

Please advise.

Regards,
Suhas

[Tauri Valor]

Refer to https://coderanch.com/t/218167/Object-Relational-Mapping/java/Hibernate-Unique-Statement

[Suhas Bilaye]

Thanks ...