Opened 9 years ago

Closed 9 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 by car031, 9 years ago

Priority: major → minor
Resolution: → fixed
Status: new → closed
Note: See TracTickets for help on using tickets.