Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:3.1

I am looking for help about hibernate ID Generator.
I have a table about person,it's primary key is char type.
the key is consisted of 10 digit of charactor string, which is lead by P,eg.P000000001,P000000002.

Somebody pls help me.
Thanks and regards,
Sunshine

Hi,

Having a char primary key is not a great idea. ( affects performance )
Anyway, if you decide to go with it, here is one way.

Define a custom id generator,

public class MyIdGenerator implements IdentifierGenerator {
public Serializable generate(SessionImplementor session, Object object) throws HibernateException {
// Use your logic here. For example, I am using a sequence
SessionImpl sessionImpl = (SessionImpl) session ;
BigDecimal id = (BigDecimal) sessionImpl.createSQLQuery("select my_sequence.nextval from dual").list().get(0) ;
return "P" + id.toString() ; // format it as required
}
}


And then, use that generator in id mapping.

<id name="id" column="id" type="string">
<generator class="MyIdGenerator"></generator>
</id>


------------------------------------------------------------------
Rate the reply if you find it helpful