CODEWITHSUNDEEP
sql-serverhibernate
Sid
Sid

Reputation: 1274

What is the Hibernate dialect for Microsoft SQL Server 2014?

I have searched online but could not find the Hibernate dialect to use for Microsoft SQL Server 2014. Which dialect should be used?

Upvotes: 11

Views: 18585

Answers (1)

Magnilex
Magnilex

Reputation: 11958

The latest dialect for Microsoft SQL Server is SQLServer2012Dialect, which is the one you should use for now. See this link for all supported dialects.

Actually, there was a bug where Hibernate defaulted to the SQL Server 2000 dialect when SQL Server 2014 was used. This bug has been resolved (in versions 5.2.0 and 5.1.1) and the solution was:

Added version 12 to the switch statement so that SQLServer2012Dialect is now returned by default, as SQL Server 2014 is much more similar to SQL Server 2012 than SQL Server 2000

In time, a SQLServer2014Dialect will probably appear, which of course mean you would switch to that dialect then.

Upvotes: 18

Related Questions