postgresql - define serial data type in java project

Question

I use play! framework 2.0 and postgresql.
in my db there is users table and every user ofcourse has a unique id.
so I defined it as serial.

my question is: how to represent a field which it's data type is serial
in my java project.

p.s. I understood play! framework uses Hibernate annotation

ndeverge · Accepted Answer · 2012-08-04 11:49:16Z

7

From the PostgreSQL documentation, the SERIAL type is equivalent to an ìnteger` with a sequence, so:

CREATE TABLE tablename (
    colname SERIAL
);

is equivalent to specifying:

CREATE SEQUENCE tablename_colname_seq;
CREATE TABLE tablename (
    colname integer DEFAULT nextval('tablename_colname_seq') NOT NULL
);

The @Id JPA annotation on the Long type will provide a sequence (equivalent to AUTO_INCREMENT in MySQL).

So, in you class, just use:

@Id
public Long id;

answered Aug 4, 2012 at 11:49

ndeverge

21.6k4 gold badges58 silver badges86 bronze badges

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

Comments

socksocket · Accepted Answer · 2012-08-04 09:50:55Z

0

OK. I just added the annotation @Id

answered Aug 4, 2012 at 9:50

socksocket

4,37114 gold badges49 silver badges70 bronze badges