Hibernate Generate Primary Key Using Trigger

Question

I am using JPA2.0 and Hibernate 4

For generating primary key in table, I am using table trigger. Trigger works fine if I am using Long as data type for Primary Key. However if I am using String as Primary Key data type, then I am getting the following errors.

org.springframework.orm.hibernate3.HibernateSystemException: Unknown integral 
data type for ids : java.lang.String; nested exception is
org.hibernate.id.IdentifierGenerationException: Unknown integral
 data type for ids : java.lang.String at 
org.springframework.orm.hibernate3.SessionFactoryUtils.
convertHibernateAccessException(SessionFactoryUtils.java:690)

So is it not allowed to use String for Primary Key for generating values using trigger?

My code snippet for generating values using trigger

private String deptNo;
@Id
@GenericGenerator(name = "trig", strategy = "increment")
@GeneratedValue(generator = "trig")
@Column(name = "DEPT_NO")

  public String getDeptNo() {
    return deptNo;
}

public void setDeptNo(String deptNo) {
    this.deptNo = deptNo;
}

dursun · Accepted Answer · 2013-05-11 09:47:50Z

2

you are not allowed to use generated values for String in hibernate, however there is no limitation for keys. if you have to use deptNo as a string you can create an adaptor class for your Domain object which contains deptNo as Long.

answered May 11, 2013 at 9:47

dursun

1,8362 gold badges22 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Jacob Over a year ago

dursun What exactly you mean by using String as an adaptor class? You mean creating custom class for generating keys?

dursun Over a year ago

no, I mean you create another object for your current class, for example if your current class is Employee, you can create AdaptorEmployee which converts Employees deptNo attribute which is Long into a String.

Jacob Over a year ago

So when I am writing to database I should call AdaptorEmployee class?

dursun Over a year ago

you should use adapter whenever you need deptNo as string and you should use the actual class whenever you need deptNo as long. So when you are intracting with db you need deptNo as long.

Collectives™ on Stack Overflow

Hibernate Generate Primary Key Using Trigger

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related