Autoincrement column in oracle using hibernate

Question

I am using hibernate annotations. I want to make a column as autoincremented. I have created a sequence in database(oracle) and mapped that sequence in java POJO class. Do I need to create trigger for that sequence too? I want to know how we can make a column autoincremented while using hibernate anotation? What changes i have to do in java and as well as database side? Please help me in this. Following is the part of code where I have mapped the sequence.

public class SimRuns implements Serializable {

    private static final long serialVersionUID = 8698324570356602407L;

    @Id @Column(name = "RUN_ID")
    @GeneratedValue(strategy=GenerationType.SEQUENCE, generator="seq_run_id")
    @SequenceGenerator(name="seq_run_id", sequenceName="seq_run_id")
    private Long runId;
}

Do you have a trigger/sequence created on the database side? — Dropout
– Dropout, Commented May 6, 2013 at 6:47

Ondrej Bozek · Accepted Answer · 2013-05-06 07:09:13Z

1

This works for me:

@Id
@GeneratedValue(generator = "nosicSeq")
@SequenceGenerator(name = "nosicSeq", sequenceName = "NOSIC_SEQ", allocationSize = 1)
@Column(name = "SID")
private BigDecimal sid;

no triggers in DB needed, just sequence.

answered May 6, 2013 at 7:09

Ondrej Bozek

11.6k7 gold badges58 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jeremie · Accepted Answer · 2013-05-06 06:44:39Z

0

Try removing the generator and setting to auto the generationType

answered May 6, 2013 at 6:44

Jeremie

3791 gold badge4 silver badges17 bronze badges

Comments

Lukas Eichler · Accepted Answer · 2013-05-06 07:38:03Z

0

@Id @Column(name = "RUN_ID")
@GeneratedValue(strategy=GenerationType.AUTO)
@SequenceGenerator(name="seq_run_id", sequenceName="seq_run_id")
private Long runId;

Hibernate is probably the only JPA Provider that selects the right Generationstrategy based on your databasetype. Using the GenerationType.AUTO statement hibernate will try to select the best strategy to implement an increasing row id.

answered May 6, 2013 at 7:38

Lukas Eichler

5,9331 gold badge27 silver badges45 bronze badges

Comments

user6192626 · Accepted Answer · 2016-04-12 09:50:29Z

0

In Oracle : It's no need for an Oracle trigger, but the sequence is must.
In pojo: you can use Annotations like this:

@Id @GeneratedValue(strategy=GenerationType.SEQUENCE, generator="majorsSeq") @SequenceGenerator(name="majorsSeq", sequenceName="MAJORS_SEQ", allocationSize = 1,initialValue = 1) public int getId() { return id; }

answered Apr 12, 2016 at 9:50

user6192626

1

Collectives™ on Stack Overflow

Autoincrement column in oracle using hibernate

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related