-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 3 posts ] 
Author Message
 Post subject: Mcrosoft SQL Server 2012 Dialect
PostPosted: Tue Sep 11, 2012 9:17 am 
Hibernate Team
Hibernate Team

Joined: Fri Sep 09, 2011 3:18 am
Posts: 295
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


Top
 Profile  
 
 Post subject: Re: Mcrosoft SQL Server 2012 Dialect
PostPosted: Tue Jan 15, 2013 2:50 pm 
Newbie

Joined: Tue Jan 15, 2013 2:46 pm
Posts: 1
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


Top
 Profile  
 
 Post subject: Re: Mcrosoft SQL Server 2012 Dialect
PostPosted: Tue Jan 15, 2013 9:26 pm 
Hibernate Team
Hibernate Team

Joined: Fri Sep 09, 2011 3:18 am
Posts: 295
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


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 3 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.