Menu
I'm new to MSSQL Hibernate, Previously worked with MySQL implementation of Spring and hibernate.
I see the below supported list :
org.hibernate.dialect.SQLServerDialect
org.hibernate.dialect.SQLServer2005Dialect
org.hibernate.dialect.SQLServer2008Dialect
org.hibernate.dialect.SQLServer2012Dialect
I can't find support for the latest version of 2017 MSSQL server. It's okay to work with org.hibernate.dialect.SQLServer2012Dialect ?. Right now it works but i'm not sure how well it goes at a longer run.
Please suggest!
Thanks Log.d
414
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.
Hibernate is database agnostic. It doesn't care if you use Oracle, SQL Server, MySQL, or about a dozen other relational databases.
hibernate. dialect. DB2Dialect , dialect for the MySql 5 database is org.
Yes, it is okay to work with org.hibernate.dialect.SQLServer2012Dialect for SQL Server 2017. As far as I know, SQL Server 2012 Dialect is the latest support NHibernate has for SQLServer.
Source: https://github.com/nhibernate/nhibernate-core/tree/master/src/NHibernate/Dialect
94
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
