JPA entity with table generator

msi_333 · **Posted:** 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

Users browsing similar codes