How to annotate id so it's autoincrements without SEQUENCE table?

hibernate jpa sequence auto-generate

bunnyjesse112 · Mar 28, 2012 · Viewed 16.2k times · Source

I have a trouble generating id's for new entities, i tried:

@Id
@GeneratedValue
private Long myId;

and

@Id
@GeneratedValue(generator="increment")
@GenericGenerator(name="increment", strategy = "increment")
private Long myId;

but on entityManager.persist i get Table "SEQUENCE" not found In pure hibernate generator class="increment" worked for me just fine.

Answer

You could define myId as auto increment / identity column in database and annotate corresponding field entity following way:

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

That works at least with H2 1.3.160 & Hibernate 3.6.8.