Opened 8 years ago
Closed 8 years ago
#778 closed task (fixed)
Switch to MS SQL Jdbc Drivers
Reported by: | Blucecio | Owned by: | |
---|---|---|---|
Priority: | minor | Milestone: | 7.7 |
Component: | Core | Version: | 7.6.4 |
Keywords: | Cc: |
Description
We should switch to Microsoft Jdbc drivers for MS SQL server
https://msdn.microsoft.com/it-it/library/ms378526(v=sql.110).aspx
https://msdn.microsoft.com/it-it/library/ms378422(v=sql.110).aspx
https://msdn.microsoft.com/en-us/library/ms378526(v=sql.110).aspx
Since Microsoft JDBC Drivers 4.2 for SQL Server, it is supported Java SE Development Kit (JDK) 8.0 and Java Runtime Environment (JRE) 8.0.
The support for the specific API Java Database Connectivity (JDBC) has been extended to include API JDBC 4.1 and 4.2.
https://docs.jboss.org/hibernate/orm/3.5/api/org/hibernate/dialect/package-summary.html
SQLServer2008Dialect
Currently we are using JTDS but it is outdated
http://jtds.sourceforge.net/
http://jtds.sourceforge.net/doc.html
Latest release is 1.3.1 and is dated 2013-06-08 and it is JDBC 3.0 (a type 4 driver)
Currently we are using Hibernate 4.1.12.Final
https://docs.jboss.org/hibernate/orm/4.1/javadocs/org/hibernate/dialect/package-summary.html
For MS SQL we should use the Hibernate dialect SQLServer2008Dialect
http://stackoverflow.com/questions/3585544/how-to-configure-hibernate-config-file-for-sql-server
http://stackoverflow.com/questions/6942407/setting-up-maven-dependency-for-sql-server
http://stackoverflow.com/questions/15519621/hibernate-configuration-for-sqlserver-driver-class
https://wiki.jasig.org/display/UPM41/MS+SQL+Server+and+MS+JDBC+Driver
http://www.codejava.net/java-se/jdbc/connect-to-microsoft-sql-server-via-jdbc
Change History (1)
comment:1 Changed 8 years ago by car031
- Priority changed from major to minor
- Resolution set to fixed
- Status changed from new to closed