

Added SQL query to toString() in SQLServerPreparedStatement to support Hibernate JPA slow query logging 2099.Added additional logging to help debug authentication and encryption issues 2118.Added access token callback class connection string property 2073.Precompiled binaries are available on GitHub and also on Maven Central.īelow is a summary of the changes in 12.3.0 over version 12.2.0. Our developers have successfully been able to connect to a MS SQL server 2016 database using using the latest version of JDBC driver 11.2.0.0 We are using the OEM version of Pentaho shipped with BMC Remedy 6.0.1.0-386 However as of version 7 of the Community Edition, they do not come with JDBC drivers for Oracle, SQL Server or MySQL (for Data Integration).We have released a new early technical preview of the JDBC Driver for SQL Server which contains several additions and changes. We have recently tried connecting to a MS SQL server 2019 database but are receiving the attached login error (credentials masked to xxx) Since we can connect to this DB with the ID and PW from MS SQL Server Studio (v 18.x) we are wondering of this dated version of Pentaho and the JDBC driver will support a connection to MS SQL Server 2019? The Microsoft JDBC Driver 6.2 for SQL Server provides mssql-jdbc-6.2.2.jre7.jar, and mssql-jdbc-6.2.2.jre8.jar class library files. The Microsoft JDBC Drivers 6.0 and 4.2 for SQL Server provide sqljdbc41.jar, and sqljdbc42.jar class library files. The Microsoft JDBC Driver 4.1 for SQL Server provides the sqljdbc41.jar class library file.We ask this because we did have to update MS SQL Server Studio or MS SQL server 2019.We also haven't found any examples that reference MS SQL Server 2019.

