Posted: 14 Mar 2017 2:46 EDT Last activity: 11 Apr 2017 5:09 EDT
Support for Microsoft JDBC 6.1.2 of SQL Server on Pega
Recently Microsoft open sourced their JDBC connector and added support for socketTimeout at JDBC level with JDBC 6.1.2 driver version.
I have downloaded the jar from the above link (mssql-jdbc-6.1.2.jre7-preview.jar) and tried this on my local Pega 7.1.8 instance with tomcat (java 7) and works fine.
One of my client is requesting for a confirmation if they can use this 6.1.2 version of MS JDBC driver with Pega 7.1.8 using WAS 18.104.22.168 with Java 1.6
From the MS SQL JDBC Support Matrix Page - Java (JRE) platform 7 or 8 and commonly used MSSQL DB products has been listed which means this driver should work fine for Pega application when supported Java and DB product is used.
SME's - Let me know your thoughts.
***Updated by moderator: Lochan to add Categories***
Our Platform Support guide lists the certified and supported stack for the specific PRPC version. As you have already consulted the latest SQL Server JDBC driver certified for PRPC v7.1.x and v7.2.x is sqljdbc4.jar so SQL Server JDBC driver v6.1.2 is not officially certified and supported.