org.hibernate.AnnotationException: Unknown Id.generator

by

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;

mkyong

Founder of Mkyong.com, passionate Java and open-source technologies. If you enjoy my tutorials, consider making a donation to these charities.

10 Comments
Most Voted
Newest Oldest
Inline Feedbacks
View all comments
Aaparna
12 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;

1
Reply
Ashwini Sharma
12 years ago
Reply to  Aaparna

may u plz tell me how it works…

0
Reply
Vivek
11 years ago

Hi Mkyong,
Please give some solution to my issue.

Thanks
Vivek

0
Reply
Vivek
11 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?

0
Reply
Alex
12 years ago

Thank you very match!

0
Reply
nmn
13 years ago

you saved my day. thank you.

0
Reply
Mr Spoon
13 years ago

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

0
Reply
Rosdi
15 years ago

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

0
Reply
mkyong
15 years ago
Reply to  Rosdi

Include the sequence name in the generator field make some of my projects failed to run, don’t really know the reason behind.

However, the @SequenceGenerator worked in all cases.

0
Reply
software development company
16 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

0
Reply