Hello,
We are using Hibernate Core with Hibernate Annotation (with Oracle as database). We are using oracle sequence for primary keys. Everything works great except for one following strange issue that we recently noticed:

The primary key values that get saved in the database are different from the actual oracle sequnce value. Following is the code snippet of our model.

We are using Hibernate version:3.2.0 and the oracle database sequnce name in this case is SEQ_ORD_ID


@Entity
@Table(name = "ORDER")
@SequenceGenerator(name = "SEQ_ORDER", sequenceName = "SEQ_ORD_ID")
public class Order implements Serializable {

private static final long serialVersionUID =4791234021227501647L;

@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQ_ORDER")
@Column(name = "ORD_ID")
private Long orderId;

@Column(name = "ORDER_DATE")
private Date orderDate;

public Long getOrderId() {
return orderId;
}

public void setOrderId(Long orderId) {
this.orderId = orderId;
}


In the hibernate log with SQL tracing enabled we see the "select SEQ_ORD_ID.nextval from dual" only once after the application server is started.

Am I missing anything here ? Any help/insight is to why the primary key value that gets saved is different from actual sequnce value that oracle database holds, is greatly appreciated.

Hi,

Add the following code to to the @SequenceGenerator annotation:



This should solve the problem.

Cheers,

Andy