Sequence Generator JPA

Sat Mar 13, 2010 11:02 pm

This is an example for using sequence as generator for identity column . I using annotations to reference to the name of the sequence in the physical database and then define the generator name to be used in the code .

Defining generator

Code:: @SequenceGenerator(sequenceName="TOPIC_SEQ",name="TOPIC_SEQ_GEN")

using it :

Code:: @GeneratedValue(generator="TOPIC_SEQ_GEN",strategy=GenerationType.SEQUENCE)

Here is the entity class :

Code:: package codemiles.test.jpa; import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.GeneratedValue; import javax.persistence.GenerationType; import javax.persistence.Id; import javax.persistence.Table; import java.util.Date; import javax.persistence.SequenceGenerator; @Entity @Table(name="TOPIC") @SequenceGenerator(sequenceName="TOPIC_SEQ",name="TOPIC_SEQ_GEN") public class topic { private long Id; private String title; private Date creationDate; private Date modifedDate; private String content; private String pending; private String editUser; @Id @GeneratedValue(generator="TOPIC_SEQ_GEN",strategy=GenerationType.SEQUENCE) public long getId() { return Id; } public void setId(long id) { Id = id; } @Column(name="TITLE") public String getTitle() { return title; } public void setTitle(String title) { this.title = title; } @Column(name="CREATION_DATE") public Date getCreationDate() { return creationDate; } public void setCreationDate(Date creationDate) { this.creationDate = creationDate; } @Column(name="MODIFED_DATE") public Date getModifedDate() { return modifedDate; } public void setModifedDate(Date modifedDate) { this.modifedDate = modifedDate; } @Column(name="CONTENT") public String getContent() { return content; } public void setContent(String content) { this.content = content; } public void setPending(String pending) { this.pending = pending; } @Column(name="PENDING") public String getPending() { return pending; } public void setEditUser(String editUser) { this.editUser = editUser; } @Column(name="EDIT_USER") public String getEditUser() { return editUser; } }