I have a table as below

create table BUYER (
BUYERCODE VARCHAR2(255) not null,
BUYERNAME VARCHAR2(50) not null,
primary key (BUYERCODE)
);

The hbm file is as below

<class name="com.arch.db.vo.Buyer" table="BUYER">
<id name="buyerCode" column="BUYERCODE" type="string" unsaved-value="null">
<generator class="??????"/>
</id>
<property name="buyerName" column="BUYERNAME" type="string" length="50" not-null="true"/>
</class>

What class should I use in the generator tag as the column buyerCode[primary key] is a string?

Kindly let me know at the earliest

Thanks
Saravanan

Read section 5.1.4.1 of the Hibernate reference. I think you are looking for uuid.hex or uuid.string.

http://www.hibernate.org/hib_docs/reference/en/html/mapping.html#mapping-declaration-id-generator

Buyer obj = new Buyer();
obj.buyerCode("N12345");
obj.buyerName("SampleName");
hda.storeObj(obj);

When I tried uuid.string the record in the table was inserted with the no value for the buyercode [It was empty]

When I tried uuid.hex the record in the table was inserted with the a value for the buyercode as 8a80800102176cdc0102176cfa850001

In either case i was not able to get my value that 'N12345'. So what generater class should I use to get this inside the column

It worked when I tried with the genertor class as "assigned"

Thanks for the link