Hi,
microsoft SQL server 2012 has some new features and the one I'm interested at the moment is the ability to create sequences.

If I'm not wrong the current dialects don't support this feature yet.
I was wondering if someone is working on this or if there is already a dialect for this server that I can use.

Thanks

Hello davided80 !

I'm in the same situation as you're in... Did you find a solution ?

We're migrating from PostgreSQL to MS SQL Server 2012 and I need Hibernate support for sequences.

Will I have to write my own sub-dialect for this feature ? Anyone has done it before ?

Thank you !

-C

Hi couimet
I didn't receive any reply at this post so we have created our custom dialect class and it seems it worked well.

We have extendeded the MySQL5Dialect class (https://github.com/hibernate/hibernate-orm/blob/master/hibernate-core/src/main/java/org/hibernate/dialect/MySQL5Dialect.java) and then we have overriden the methods related to sequences that are in the Dialect super class (https://github.com/hibernate/hibernate-orm/blob/master/hibernate-core/src/main/java/org/hibernate/dialect/Dialect.java).
The methods I'm talking about are after the Dialect#supportsSequences().

If you are going to write the class It would be great if you would send a pull request to the hibernate team (they can also give some feedback about it).
I would have sent the pull myself but I've left the company soon after I've created this thread.

Cheers