JPA entity with table generator

Fri Mar 19, 2010 11:51 pm

You can use table a generator for your entity id . You define the name of this table and it is primary key , the generated value and for which col

Code:: @TableGenerator(name = "TOPIC_GEN", table = "ID_GEN", pkColumnName = "GEN_NAME", valueColumnName = "GEN_VAL", pkColumnValue = "TOPIC_ID", initialValue = 20000, allocationSize = 200)

name = generator name to be used with identities .
table = table name (optional : Default of persistence provider ) .
pkColumnName = name of primary key column of the table . (optional : Default of persistence provider ) .
valueColumnName = store last generated value (optional : Default of persistence provider ) .

pkColumnValue = for which primary key is the last value was generated .

Here its usage in the JPA entity

Code:: import javax.persistence.CascadeType; import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.FetchType; import javax.persistence.GeneratedValue; import javax.persistence.GenerationType; import javax.persistence.Id; import javax.persistence.OneToMany; import javax.persistence.Table; import javax.persistence.TableGenerator; import java.util.Date; import java.util.Set; @Entity @Table(name="TOPIC") public class topic { private long Id; private String title; private Date creationDate; private Date modifedDate; private String content; private String pending; private String editUser; private Set<comment> commentSet; @TableGenerator(name = "TOPIC_GEN", table = "ID_GEN", pkColumnName = "GEN_NAME" , valueColumnName = "GEN_VAL", pkColumnValue = "TOPIC_ID", initialValue = 20000, allocationSize = 200) @Id @GeneratedValue(generator="TOPIC_GEN",strategy=GenerationType.TABLE) 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; } public void setCommentSet(Set<comment> commentSet) { this.commentSet = commentSet; } @OneToMany(fetch=FetchType.LAZY,cascade=CascadeType.ALL,mappedBy="topic") public Set<comment> getCommentSet() { return commentSet; } }

JPA entity with table generator

JPA entity with table generator

Topic Tags