id	summary	reporter	owner	description	type	status	priority	milestone	component	version	resolution	keywords	cc
778	Switch to MS SQL Jdbc Drivers	Alex		"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"	task	closed	minor	7.7	Core	7.6.4	fixed