Menu
I have searched online but could not find the Hibernate dialect to use for Microsoft SQL Server 2014. Which dialect should be used?
422
Dialect is a class that acts as a bridge between Java JDBC types and SQL types, which contains the mapping between java language data type and database datatype. Dialect allows Hibernate to generate SQL optimized for a particular relational database.
Dialect is the SQL dialect that your database uses. List of SQL dialects for Hibernate.
In addition to that, Hibernate needs to know the database-specific dialect it shall use to generate the SQL statements. Hibernate can detect the dialect based on the configured JDBC connection, or you can provide it as a configuration parameter.
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.
152
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
