Hibernate Community • View topic

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Oracle Sequences

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

jasoncwarner

Post subject: Oracle Sequences

Posted: Wed Aug 09, 2006 12:00 pm

Newbie

Joined: Wed Aug 09, 2006 11:56 am
Posts: 1

I have a general question about hibernate 3 with annotations and oracle sequences.

Is it possible to create a sequence using hibernate 3 annotations? I can't seem to find any documentation or examples on this, so if it is possible, would someone please be so kind as to point me in the right direction.

Thanks,
jason

Top

kama

Post subject:

Posted: Wed Aug 23, 2006 12:35 pm

Newbie

Joined: Thu Nov 10, 2005 7:21 pm
Posts: 4
Location: Germany

Hi there,

what about this:

Code:

@Table(name="TAB1")
public class Table ... {
    ...
    @Id
    @GeneratedValue(generator = "hibseq")
    @GenericGenerator(name = "hibseq", strategy = "sequence", parameters = { @Parameter(name = "sequence", value = "SEQ_TAB1") })
    public Long getId() {
        return this.id;
    } 

Kind regards
Karl Heinz

Top

willem

Post subject:

Posted: Fri Aug 25, 2006 8:04 am

Newbie

Joined: Wed Aug 23, 2006 7:59 am
Posts: 7

You simply annotate the class like this:

Code:

@SequenceGenerator(
        name="SEQ_PDA",
        sequenceName="res_rpa_seq"
)

then make your id field something like this:

Code:

    @Id @GeneratedValue(strategy=GenerationType.SEQUENCE, generator="SEQ_PDA") 
    public Long getId() {
        return m_id;
    }

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum