Opened 4 months ago

Closed 4 months 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 4 months ago by car031

  • Priority changed from major to minor
  • Resolution set to fixed
  • Status changed from new to closed
Note: See TracTickets for help on using tickets.