Main Tutorials

org.hibernate.AnnotationException: Unknown Id.generator

Problem

Runing the following Hibernate’s annotation sequence generator with PostgreSQL database.


        @Id	
	@Column(name="user_id", nullable=false)	
	@GeneratedValue(strategy = GenerationType.SEQUENCE ,generator="account_user_id_seq")
	private Integer userId;

Hits the following Unknown Id.generator exception.


Caused by: org.hibernate.AnnotationException: Unknown Id.generator: account_user_id_seq
	at org.hibernate.cfg.BinderHelper.makeIdGenerator(BinderHelper.java:413)
	at org.hibernate.cfg.AnnotationBinder.bindId(AnnotationBinder.java:1795)
	at org.hibernate.cfg.AnnotationBinder.processElementAnnotations(AnnotationBinder.java:1229)
	at org.hibernate.cfg.AnnotationBinder.bindClass(AnnotationBinder.java:733)

The sequence “account_user_id_seq” is created in PostgreSQL database, what caused the above exception?

Solution

When declaring the Hibernate’s annotation strategy to use “Sequences” as Id generator, try specify the @SequenceGenerator as well, as following


        @Id	
	@Column(name="user_id", nullable=false)	
	@SequenceGenerator(name="my_seq", sequenceName="account_user_id_seq")
	@GeneratedValue(strategy = GenerationType.SEQUENCE ,generator="my_seq")
	private Integer userId;

About Author

author image
Founder of Mkyong.com, love Java and open source stuff. Follow him on Twitter. If you like my tutorials, consider make a donation to these charities.

Comments

Subscribe
Notify of
10 Comments
Most Voted
Newest Oldest
Inline Feedbacks
View all comments
Aaparna
10 years ago

I tryied the similar way it didn’t work, But the below code did.

@Id

@Column(name = “ID”, unique = true, nullable = false)

@GeneratedValue(generator=”my_seq”)

@SequenceGenerator(name=”my_seq”, sequenceName=”E_ID”)

private Long docmId;

Ashwini Sharma
9 years ago
Reply to  Aaparna

may u plz tell me how it works…

Vivek
8 years ago

Hi Mkyong,
Please give some solution to my issue.

Thanks
Vivek

Vivek
8 years ago

How I can autogenerate the String in hibernate?

Example:

@Id

@GenerateValue

private String cust_code;

If i give above like that, it should not work and please let me know how to resolve this issue?

Alex
10 years ago

Thank you very match!

nmn
11 years ago

you saved my day. thank you.

Mr Spoon
11 years ago

Thank you so much for this!
It works perfectly. Hibernate can be very unhelpful sometimes!

Rosdi
13 years ago

Isn’t that ridiculous? I think writing the actual sequence name in the generator field makes more sense.

software development company
14 years ago

Quite inspiring,

good tip:When we declared our annotation strategy to use “Sequences” as our id generator, we need to specify the @SequenceGenerator as well.
I try to remember it

Thanks for writing about it