Sequence Generator JPA

DrRakha

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;
    }
}

 

Java

C/C++

PHP

C#

HTML

CSS

ASP

Javascript

JQuery

AJAX

XSD

Python

Matlab

R Scripts

Weka

Sequence Generator JPA