why Oracle sequence not working with JPA entity ID?

于 2012-09-19 08:08:18 发布 · 108 阅读

文章标签：

#JPA #@Entity #@SequenceGenerator #Oracle Sequence

JEE 同时被 2 个专栏收录

40 篇文章

订阅专栏

Java

10 篇文章

订阅专栏

本文介绍如何正确配置Oracle序列与JPA实体Bean中的@SequenceGenerator注解，以确保序列号按预期分配，避免出现随机分配导致的问题如唯一约束违规等错误。

Suppose you have an Oracle sequence defined as following:

CREATE SEQUENCE BILLING.SEQ_ACTVID
	START WITH 300060
	INCREMENT BY 1
	NOMINVALUE
	NOMAXVALUE
	NOCYCLE
	NOORDER
	CACHE 20;

And you want to use that Oracle sequence. You need to add attribute "allocationSize=1" in "@SequenceGenerator" when decroating the Entity bean.

  @Id
  @Column(name="ACTVID", nullable = false)
  @SequenceGenerator(name="SeqACTVID", sequenceName="SEQ_ACTVID", allocationSize=1)
  @GeneratedValue(strategy=GenerationType.SEQUENCE, generator="SeqACTVID")
  private Long ACTVID;

Otherwise, ORM implementation underneath JPA might randomly allocate sequence number for you. This might cause problems that you don't expect, such as unique constraint violation errors from Oracle. You might also notice that the Oralce sequence generator seems to ignore your "start with" defination as well, if you missed out the "allocationSize=1" attribute.