Mapping PostgreSQL serial type with Hibernate annotations

Question

I am using Hibernate 3.3 and PostgreSQL 8.x and would like to use Hibernate annotations to map an auto-incremented column which is NOT a primary key.

It doesn't matter if the column is mapped using SERIAL type or sequences in Postgres as long as it gets auto-incremented by the database and not by Hibernate. I tried the following mappings, but they always generated null orderId.

@Column(name = "orderId", insertable = false)
@Generated(GenerationTime.INSERT)
//@GeneratedValue(strategy = javax.persistence.GenerationType.AUTO)
private Integer orderId;

I will appreciate any help with this.

Thanks

I wrote an integration test and checked this field's value in the debugger. — alecswan
– alecswan, Commented Feb 12, 2011 at 18:47
@alecswan please revise the selected answer - i believe my answer is more correct and i personally have to keep coming back here to remember how to do it correctly! every time i attempt to use the incorrect answer and then look further and find my own correct answer! — pstanton
– pstanton, Commented Jun 27, 2014 at 1:58

laurent · Accepted Answer · 2015-10-26 22:19:19Z

37

The following mapping should work fine:

@Column(name = "orderId")
@Generated(GenerationTime.INSERT)
private Integer orderId;

Note, however, that generated value for freshly saved objects is not available until session is flushed.

EDIT: Note that this mapping doesn't affect doesn't make Hibernate to create a column of type serial during schema generation, since Hibernate doesn't know anything about the nature of value generation at the database side. Therefore, if you want Hibernate to create a column with a proper type, you need to specifiy it explicitly:

@Column(name = "orderId", columnDefinition = "serial")
@Generated(GenerationTime.INSERT)
private Integer orderId;

And on a recent Hibernate version (4.3), you can use this:

@Id
@GeneratedValue(strategy=GenerationType.IDENTITY)
private Long orderId;

edited Oct 26, 2015 at 22:19

laurent

7739 silver badges14 bronze badges

answered Feb 12, 2011 at 19:04

axtavt

243k42 gold badges518 silver badges486 bronze badges

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

9 Comments

alecswan Over a year ago

Flushing the session before loading the object did not work. I noticed that Hibernate just generates orderid column with type INTEGER in Postgres database. I don't see how this can work at all if the type is not SERIAL and Hibernate does not generate any triggers that would update this column. Any other thoughts? Thanks

axtavt Over a year ago

@alecswan: Updated. Also, flushing is related to the session where objects were save, not the the session where they are loaded.

alecswan Over a year ago

In my case objects were saved and loaded in the same session. Adding columnDefinition = "serial" fixed the problem, thanks! Is there a solution, e.g. using Identity generator, to make this solution work on other databases as well?

axtavt Over a year ago

@alecswan: As far as I know, Hibernate doesn't support generators for non-id properties.

beginner_ Over a year ago

up-vote because this can be used for generating values on non-id columns. And that can be a big issue. This makes it easy with the downside of being hibernate specific (and not JPA) and Database specific (PostgreSQL). In my case that is not an issue.

|

pstanton · Accepted Answer · 2013-01-16 01:08:40Z

25

the accepted answer doesn't work for me.

this did though:

@Id
@Column(name = "your_id", columnDefinition = "serial")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer yourId;

answered Jan 16, 2013 at 1:08

pstanton

36.9k28 gold badges130 silver badges171 bronze badges

5 Comments

pstanton Over a year ago

this is also JPA not compatible which is a bonus.

hd1 Over a year ago

How is not compatible a bonus?

pdem Over a year ago

Works for me, without the columnDefinition = "serial", I prefer to declare this only in the SQL generation file, using flyway (or liquibase)

Klesun Over a year ago

Wait, didn't OP say his column is NOT a primary key? Does @Id annotation still apply in such case?

pstanton Over a year ago

@Klesun i must have missed that requirement - oops

Mike Aski · Accepted Answer · 2012-09-11 15:59:51Z

5

I'm using this with postgresql9.1, should work with 8 too:

@SequenceGenerator(allocationSize=1, initialValue=1, sequenceName="account_id_seq", name="account_id_seq")
@GeneratedValue(generator="account_id_seq", strategy=GenerationType.SEQUENCE)
@Id
@Column(name="id")
private Integer id;

edited Sep 11, 2012 at 15:59

Mike Aski

9,2364 gold badges48 silver badges66 bronze badges

answered Aug 10, 2012 at 13:15

bjonczy

491 silver badge4 bronze badges

2 Comments

Craig Ringer Over a year ago

You can also use strategy=GenerationType.IDENTITY

Angelo Fuchs Over a year ago

Does this work without @Id? (Because the question is explicit about the field not being an id field)

Klesun · Accepted Answer · 2021-06-08 12:32:44Z

1

I tried both GenerationTime.INSERT and GenerationType.IDENTITY, but neither prevented the null from being inserted on an updating saveAll() call.

What did help was marking the field as non-writable for hibernate:

@Column(insertable = false, updatable = false)
private Integer orderId;

(Kudos to this answer)

edited Jun 8, 2021 at 12:32

answered Jun 7, 2021 at 10:56

Klesun

14.1k7 gold badges66 silver badges60 bronze badges

Comments

erdikanik · Accepted Answer · 2020-08-08 11:15:35Z

0

Database sequence is not sync with your private key. So you need to update sequence index.

Check your sequence id from db and execute this sql command. (Do not forget to get backup your db just in case)

SELECT setval('your_primary_key_sequence', (SELECT MAX(your_primary_key) FROM your_table)+1);

answered Aug 8, 2020 at 11:15

erdikanik

7449 silver badges13 bronze badges

Collectives™ on Stack Overflow

Mapping PostgreSQL serial type with Hibernate annotations

5 Answers 5

9 Comments

5 Comments

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

9 Comments

5 Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related