I got problem when having two id in one entity.
I have an Order entity. It has one "id" field, which is PK and is generated by Hibernate uuid. It also has a "refNum" field, which is a unique number for other business purpose and is generated by Oracle sequence.
The "id" field is working fine. But, the "refNum" field is always generated a null value and inserting null into table and thus throwing SQL exception: [cannot insert NULL into ("ORDER"."REF_NUM")]
Have I missed something ? Or Have I made any mistakes?
Thanks.
Code:
@Entity
@Table(name="ORDER")
public class Order{
@Id
@GeneratedValue(generator = "hibernate-uuid")
@org.hibernate.annotations.GenericGenerator(
name = "hibernate-uuid",
strategy = "uuid"
)
@Column(name="ID")
private String id;
@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator="ref_num_seq")
@SequenceGenerator(name="ref_num_seq", sequenceName="SEQ_ORDER_REF_NUM")
@Column(name="REF_NUM")
private Long refNum;
public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}
public Long getRefNum() {
return refNum;
}
public void setRefNum(Long refNum) {
this.refNum = refNum
}
}