Sequence in Sql Server 2014 and Hibernate

Asked Sep 15 '15 at 17:49

Active Sep 15 '15 at 17:49

Viewed 1,451 times

I'm working for a database from a legacy application. The database has a table called 'User' , with multiple records , the last of which id used is the value 900. I need to implement a user registration form , and the id has to start 901. In Postgres , I just used a sequence and set the start value to 901 . The problem is that the sql server has no sequence . How do I solve this problem with sql server and hibernate?

Thank you.

asked Sep 15 '15 at 17:49

brunojmbq

Old versions of Sql Server doesen't have sequences. 2014 has. https://msdn.microsoft.com/en-us/library/ff878091.aspx – Evgeni Dimitrov Sep 15 '15 at 17:52
Have you tried AUTO_INCREMENT with the ID? – Kebab Programmer Sep 15 '15 at 18:05
I am writing the getId with '@SequenceGenerator' and '@GeneratedValue', but gives error when starting the server : org.hibernate.dialect.SQLServerDialect does not support sequences – brunojmbq Sep 15 '15 at 18:59
3

I used the dialect org.hibernate.dialect.SQLServer2012Dialect and works! Thanks anyway. – brunojmbq Sep 15 '15 at 19:04
GenerationType.AUTO selects the most appropiate generation type appropiate for each database – Daniel Higueras Feb 24 '16 at 11:43

Sequence in Sql Server 2014 and Hibernate

0 Answers0

Linked