Skip to content

Latest commit

 

History

History
1051 lines (884 loc) · 84.7 KB

CHANGELOG.md

File metadata and controls

1051 lines (884 loc) · 84.7 KB

Change Log

All notable changes to this project will be documented in this file.

The format is based on Keep a Changelog

[12.9.0] Preview Release

Added

  • Added statement portion of configurable retry logic feature #2396
  • Added JDK 23 support #2515

Changed

  • Reverted "Execute Stored Procedures Directly" feature, as well as subsequent changes related to the feature #2488
  • Changed MSAL logging from FINER to FINEST #2489

Fixed issues

  • Changed driver behavior to allow prepared statement objects to be reused, preventing a "multiple queries are not allowed" error #2482
  • Adjusted DESTINATION_COL_METADATA_LOCK, in SQLServerBulkCopy, so that is properly released in all cases #2484

[12.8.0] Stable Release

Fixed issues

  • Fixed regression with specifying argument names in callable statement syntax #2480

[12.7.1] Preview Release

Added

  • Added JDK 22 support #2414
  • Added credential caching for Managed Identity Credential and Default Azure Credential #2415
  • Added Caching SQLServerBulkCopy object for batch insert #2435
  • Added connection level bulk copy metadata caching #2464
  • Added logging to token caching #2468

Changed

  • Bump org.bouncycastle:bcprov-jdk18on from 1.77 to 1.78 #2403
  • Enum SQLServerSortOrder is now public #2405
  • Bump com.azure:azure-identity from 1.12.1 to 1.12.2 #2447
  • Bump com.microsoft.azure:msal4j from 1.15.0 to 1.15.1 #2448

Fixed issues

  • Execute stored procedures directly for RPC calls #2410
  • Fix SqlAuthenticationToken constructor accepting unix epoch #2425
  • TokenCredential class shouldn't be required #2441
  • Fixed timestamp string conversion error for CallableStatements #2449
  • Fixed CallableStatements default value regression #2452
  • Fixed parentheses parsing for stored procedure names and function names #2467

[12.7.0] Preview Release

Added

  • Server Message Handler and SQLException Chaining #2251
  • Finish support for RFC4180 for CSV bulk insert operations #2338
  • Allow constructing a microsoft.sql.DateTimeOffset instance from a java.time.OffsetDateTime value #2340
  • Added support for TDSType.GUID #2370

Changed

  • Remove synchronized from Socket overrides #2337
  • Default to RMFAIL instead of RMERR #2348

Fixed issues

  • Fix to allow connection retries to be disabled by setting connectRetryCount to 0 #2293
  • Fix to ensure metadata returned follows JDBC data type specs #2326
  • Added token cache map to fix use of unintended auth token for subsequent connections #2341
  • Fix calling procedures with output parameters by their four-part syntax #2349
  • Reset socketTimeout to original value after a successful connection open #2355
  • Clear prepared statement cache when resetting statement pool connection #2361
  • Clear prepared statement handle before reconnect #2364
  • Fixed ClassLoader leak of ActivityCorrelator ThreadLocal #2366
  • Check if TDSCommand counter is null before incrementing #2368
  • Escape schema for getProcedures and getProcedureColumns in SQLServerDatabaseMetaData #2369
  • Fix to properly validate money and small money values for BulkCopy #2379

[12.6.0] Stable Release

Changed

  • Adjusted PreparedStatement cache, so it's cleared before every execute #2272
  • Updated azure-identity, azure-security-keyvault-keys, bouncycastle, and msal library versions #2279
  • Changed socketTimeout to ensure it's always less than or equal to loginTimeout #2280
  • Change BulkCopy behavior from serializing and deserializing Timestamp objects, to using the objects directly #2291

Fixed issues

  • Fixed the way ActivityID was defined and used to be more in line with the behavior of other Microsoft drivers #2254
  • Fixed missing getters and setters for useBulkCopyForBatchInsert #2277
  • Fixed an issue where, when using the TOP qualifier in a query, the driver returns an error concerning ParameterMetadata #2287
  • Fixed an issue where insert statements with missing whitespace worked correctly in regular cases, but not when using batch inserts #2290
  • Fixed timezone not being properly applied to Timestamps when inserted using batch insert with bulkcopy #2291
  • Fixed locks in IOBuffer to prevent deadlock issues that could arise #2295
  • Fixed an issue where, when an exception has no cause, the exception itself is passed along instead, preventing it from being lost #2300

[12.5.0] Preview Release

Added

  • Added connection property, useDefaultJaasConfig, to allow Kerberos authentication without any additional external configuration #2147
  • Allow calling of stored procedures directly through use of new connection property useFlexibleCallableStatements, simplifying the procedure and improving performance #2154
  • Added connection property, useDefaultGSSCredential, to allow the driver to create GSSCredential on behalf of a user using Native GSS-API for Kerberos authentication #2177
  • Added Java 21 support #2229
  • Added connection property, calcBigDecimalScale, to allow the driver to calculate scale and precision from Big Decimal inputs #2248
  • Added a new named logger for connection open retries and idle connection resiliency reconnects #2250

Changed

  • Changed how IBM JDK is checked for to prevent issues with OSGi environments #2150#2209
  • Updated azure-security-keyvault-keys, bouncycastle, and h2 library versions. As well, Upgraded from bcprov-jdk15on and bcpkix-jdk15on to bcprov-jdk18on and bcpkix-jdk18on as the former is no longer being updated #2162#2182#2249
  • Changes to bulkcopy to allow for performance improvements when loading a large number of timestamps #2194
  • Added additional errors that should translate to RMFAIL #2201
  • Properly synchronize all calls to MSAL, preventing the driver from making extra calls and providing unnecessary dialogues #2218
  • Changed driver retry behavior to retry the correct number of times based on connectRetryCount. These changes were later reverted prior to the 12.6.0 release #2247#2267

Fixed issues

  • Fix to ignore irrelevant computed columns during bulk insert #1562
  • Fixed an issue where signature was not properly verified when using Java Key Store, as well as adding a new API to sign column master key metadata (and return generated signature) for use with Java Key Store and Azure Key Vault #2160
  • Fixed an issue where a null SQLState was returned when trying to convert a date to a long #2185
  • Fixed an issue where schemaPattern was not properly being escaped in SQLServerDatabaseMetadata #2195
  • Fixes getObject()'s erroneous conversion of DateTimeOffset to LocalDateTime #2204
  • Fixed an issue with ParameterMetadata not properly checking for an invalid index 0 #2217
  • Fixed bulkcopy metadata query to make use of cached data, if it's available #2231
  • Fixed an issue when writing TVP row values, where input values were not properly filtered for BigDecimal scale #2239

[12.4.0] Stable Release

Fixed issues

  • Revert #2051 (Big decimal precision) / #2116 (Fix for bigDecimal values between 0 and 1 having too high of a precision) #2176
  • Fixed server certificate validation for encrypt=strict #2174
  • Fixed issues identified by SonarQube #2145

[12.3.1] Preview Release

Added

  • Added a case to throw XAER_RMFAIL on connection reset for XA transactions 2118
  • Added support for Azure Active Directory Service Principal Certificate Authentication 2128

Changed

  • Improved performance of building parameter type definitions 1938
  • Removed check condition that had no effect 2129
  • Updated azure-security-keyvault-keys, azure-identity, gson and h2 library versions 2133
  • Changed serverName sent in LOGIN packet to include instanceName 2140

Fixed issues

  • Resolved high thread count when using findSocketUsingThreading 2104
  • Corrected Activity ID behavior to stay the same for the life of the process, always send Activity ID in PRELOGIN, increment sequence for each new connection and send a unique client ID that persists for duration of process 2136

[12.3.0] Preview Release

Added

  • Added additional logging info to help debug 2118
  • Added SQL query to toString() in SQLServerPreparedStatement 2099
  • Added Java 20 support 2097
  • Added access token callback class connection string property 2073

Changed

  • Updated azure-identity version 2114
  • Updated msal4j version 2102
  • Allow failover partner to be tried in case of socket timeout 2100
  • Updated supportsLikeEscapeClause() to check for Azure data warehouse 2092
  • sp_cursor calls now have table names passed in instead of an empty string 2087
  • Updated federated authentication logic to use persistence token cache when fetching token 2079
  • Updated supportTransaction method to reflect whether server supports transactions 2075
  • Made jdk.net optional OSGi import 2069
  • Upgraded to latest OSGi JDBC specification 2017

Fixed issues

  • Fixed missing property value for disableStatmentPooling meta info query 2120
  • Fixed typo in access token error message 2119
  • Fixed BigDecimal error when values between 0 and 1 are specified 2116
  • Fixed lockTimeout not taking effect when redirect mode is set in Azure DB 2110
  • Fixed shared timer race condition 2085
  • Fixed XA error handling to rethrow XAER_RMFAIL instead of XAER_RMERR 2078
  • Fixed issue by accounting for zero meta query results 2074
  • Fixed invalid batch inserts when columns provided in insert differs in order from table schema 1992

[12.2.0] Stable Release

Added

  • Added new connection property datetimeParameterType to specify datatype to use for date/timestamp parameters 1687

Changed

Fixed issues

  • Fixed BigDecimal Precision/Scale issue 2051
  • Fixed NULL state and 0 error code for SQL exceptions 2018
  • Fixed incorrect updateCount 2013
  • Fixed Azure Active Directory username cache matching to be case insensitive 1923
  • Fixed concurrency issues in encrypt/decrypt obfuscation methods for truststore password 1968
  • Fixed Idle Connection recovery so that unprocessedResponseCount isn't over decremented 1989
  • Fixed race condition connecting to the wrong SQLServer host in configurable IPv6 1968

[12.1.0] Preview Release

Added

  • Added support for access token callback 1940
  • Added support for DefaultAzureCredential 1936
  • Added support for Java 19 1929

Changed

  • Driver is Loom friendly 1931
  • Managed Identity authentication is achieved with Azure Identity instead 1936
  • Updated MSAL and jackson-databind versions 1947
  • Updated Azure-Identity version 1941
  • Made MSAL an optional dependency 1893
  • Added FINE logging for token expiry 1875
  • Upgraded junit jupiter 1895

Fixed issues

  • Ensure that batchParamValues is cleared in all cases when executing a batch 1869
  • Fixed query cancellation bug 1897
  • Fixed callable statement index out of bounds error 1898
  • Fixed sonartype warnings 1950
  • Fixed check for DONE token when fetching result sets 1943
  • Fixed race condition in secure string utility 1948
  • Fixed attestation NONE protocol bug to work with all servers and enclave types 1942
  • Fixed signed byte comparison 1920

[11.2.0] Stable Release

Added

  • Added support for caching parameter metadata for Always Encrypted with secure enclaves 1866
  • Added explicit dependency for com.microsoft.azure.msal4j (was a transitive dependency in previous releases) 1863

Changed

  • Changed default loginTimeout value to 30s 1885
  • Updated dependency versions of com.azure.azure-security-keyvault-keys and com.azure.azure-identity 1863
  • Send TDS version 8 in Login7 when in strict mode (encrypt=strict) 1870
  • Validate that the serverName field of the connection string does not have an equal sign 1853

Fixed issues

  • Fixed intermittent null prepared statement handle error caused by sp_prepare when used with batch queries. 1886
  • Fixed race condition with addressList which may result in IndexOutOfBoundsException when establishing multiple connections 1855
  • Updated secure string usage to prepend Initialization Vector into the encrypted bytes so each IV is unique and preserved with its encrypted bytes for later decryption 1858
  • Added check for DONE_ERROR status token which may occur from a killed session on the server 1857
  • Fixed issue where the driver may assert when canceling a statement 1872

[11.1.2] Preview Release

Added

  • Added support for caching managed identity tokens 1825
  • Added support for caching Always Encrypted parameter metadata 1845

Changed

  • Switched from strings to char arrays for secure string use 1813
  • Added check for negotiated ALPN 1818

Fixed issues

  • Fixed double connection issue when enabling TDS 8.0 and SSL by reusing original socket connection 1817
  • Fixed unknown token error 0xA3 when selectMethod cursor is used with data classification 1821
  • Fixed out-of-bounds error for when a data classification information type is not provided 1847

[11.1.1] Preview Release

Added

  • Added support for Java 18 1802
  • Added support for bulk insert of null GUID values 1778
  • Added ALPN for TDS 8.0 connections 1795

Changed

  • Updated dependency versions of azure-keyvault and azure-identity 1798
  • Refactored Idle Connection Resiliency timeout to use existing SharedTimer 1794

Fixed issues

  • Fixed regression with Always Encrypted with secure enclaves 1805

[11.1.0] Preview Release

Added

  • Added new connection string property prepareMethod to toggle use of sp_prepare 1719
  • Added Azure Active Directory tests for Azure Data Explorer using user/password/applicationName 1755
  • Added check for MSAL library when attempting ActiveDirectoryServicePrincipal authentication 1759
  • Added new encrypt options for TDSS support 1757
  • Added Configurable IPv6 Support 1766
  • Added serverCertificate connection property for encrypt=strict 1773
  • Added encrypt utility to obfuscate password strings 1780
  • Added option for NONE attestation protocol 1779

Changed

  • Simplified traceID creation in DataSource and PooledConnection 1747
  • Refactored SQLServerColumnEncryptionAzureKeyVaultProvider usage in SQLServerConnection 1774

Fixed issues

  • Removed extra call to executeCommand() within connectionCommand() 1754
  • Fixed warnings for Implicit narrowing conversion in compound assignment 1758
  • Added check for MSAL library when attempting ActiveDirectoryServicePrincipal authentication 1759
  • Fixed Managed Identity retry interval to exponential backoff properly 1770

[10.2.0] Stable Release

Added

  • Support for datetimeoffset with sql_variant 1673
  • Canonical host name resolution when realm is provided in connection string 1730

Changed

  • Changed certificate validation behavior to validate when encryption is negotiated from either the client or the server side, not just the client side 1731
  • Enclave Provider to use non blocking /dev/urandom 1734
  • Updated azure dependancy versions to address vulnerability issues1733
  • Updated Bouncy Castle version 1735

Fixed

  • Fixed issues detected by SonarQube 1739

[10.1.0] Preview Release

Added

  • Fix for Idle Connection Resiliency for Azure AD Authentication 1706
  • Retry for intermittent java NativeSeedGenerator 1705
  • Default encryption to true 1697
  • Fix for Azure AD interactive authentication timeout 1696

Changed

  • Deprecated AADSecurePrincipalId/AADSecurePrincipalSecret 1693

Fixed issues

  • Fixed TDSParser stuck on TDS_COLMETADATA issue [#1662] (#1662)
  • Fixed conversion of LocalDateTime and LocalTime to String in Bulk Copy [#1640] (#1640)

[9.5.0] Preview Release

Added

  • Idle Connection Resiliency Feature 1669
  • Fix for Bulkcopy multibyte characters in char/vchar columns 1671
  • Java 17 support 1676
  • Added logging when deriving realm 1672
  • Added check for closed statement to registerColumnEncryptionKeyStoreProvidersOnStatement 1644
  • Added 42108 and 42109 to transient error list 1643

Changed

  • Updated MD4 based on Bouncy Castle implementation 1665
  • Updated mssql-jdbc_auth_LICENSE 1663

Fixed issues

  • Fixed and issue where Statement.closeOnCompletion() would cause a Null Pointer Exeception 1639
  • Fixed conversion of LocalDateTime and LocalTime to String in Bulk Copy 1640

[9.4.0] Stable Release

Added

  • Added JAVA 16 support #1579
  • Added optional realm connection string property for Kerberos authenticatoin #1581
  • Added support for multiple, successive connections using AKV provider #1594
  • Updated error messages for Enclave exceptions with forward link to troubleshooting guide #1585
  • Added driver version to the database during prelogin #1583
  • Append MSAL exception error msg to error string #1576
  • Send client process ID to server on Java 9+ #1595
  • Removed dependency to org.hamcrest #1596
  • Updated dependency versions for azure-identity, azure-security-keyvault-keys, adal4j, gson, antlr, and bouncycastle #1613
  • Removed Java 9-specific class references from the Java 8 jar #1626
  • Updated dependencies versions and upgraded to Gradle version 7 #1627
  • Fixed memory leak issue #1633

Fixed issues

  • Fixed an issue where batch fails when always encrypted is enabled in connection string and clearParameters was called #1578

[9.3.1] Preview Release

Added

  • Added replication connection option #1566

Fixed issues

  • Fixed an issue where trustStorePassword is null when using applicationIntent=ReadOnly #1565
  • Fixed an issue where redirected token contains named instance in servername #1568

[9.3.0] Preview Release

Added

  • Added Open Connection Retry feature #1535
  • Added server recognition for Azure Synapse serverless SQL pool, and Azure SQL Edge #1543

Fixed issues

  • Fixed potential integer overflow in TDSWriter.writeString() #1531

[9.2.1] HotFix & Stable Release

Fixed issues

  • Fixed an issue with client secret being empty during ActiveDirectoryServicePrincipal authentication in Azure environment. #1519

[9.2.0] Stable Release

Added

  • Added logic to handle multi-factor authentication timeouts during ActiveDirectoryInteractive authentication #1488

Fixed issues

  • Fixed an issue with high memory allocation during bulk copy #1475

[9.1.1] Preview Release

Added

  • Added maxResultBuffer connection property 1431
  • Added support for Service Principal Authentication 1456
  • Added support for Azure Active Directory Interactive Authentication 1464

Changed

  • Enabled useBulkCopyForBatchInsert against non Azure SQL Data Warehouse servers #1465

[9.1.0] Preview Release

Added

  • Added support for already connected sockets when using custom socket factory 1420
  • Added JAVA 15 support #1434
  • Added LocalDateTime and OffsetDateTime support in CallableStatement 1393
  • Added new endpoints to the list of trusted Azure Key Vault endpoints #1445

Fixed issues

  • Fixed an issue with column ordinal mapping not being sorted when using bulk copy #1406
  • Fixed PooledConnectionTest to catch exceptions from threads #1409
  • Fixed an issue with bulk copy when inserting non-unicode multibyte strings #1421
  • Fixed intermittent deadlock issue in DBMetadatatest #1423
  • Fixed Gradle exclude tags #1424
  • Fixed an issue with SQLServerBulkCSVFileRecord ignoring empty trailing columns when using setEscapeColumnDelimitersCSV() API #1438

Changed

  • Changed visibility of SQLServerBulkBatchInsertRecord to package-private #1408
  • Upgraded to the latest Azure Key Vault libraries #1413
  • Updated API version when using MSI authentication #1418
  • Enabled Azure Active Directory integrated authentication tests on non-Windows clients #1425
  • Updated the driver to remove clientKeyPassword from memory #1428
  • Updated SQLServerPreparedStatement.getMetaData() to retain exception details #1430
  • Made ADALGetAccessTokenForWindowsIntegrated thread-safe #1441

[8.4.1] HotFix & Stable Release

Fixed issues

  • Fixed issue with SQLServerConnectionPoolProxy not being compatible with delayLoadingLobs. #1403
  • Fixed a potential NullPointerException issue with delayLoadingLobs. #1403
  • Fixed issue with decrypting column encryption keys using Windows Certificate Store.

[8.4.0] Stable Release

Added

  • Added support for sensitivity ranking when using SQL Data Discovery and Classification #1338 #1373
  • Added SQLServerDatabaseMetaData.getDatabaseCompatibilityLevel() API to return the database compatibility level #1345
  • Added support for Azure SQL DNS Caching #1357

Fixed issues

  • Fixed an issue with DatabaseMetaData.getColumns() intermittently returning table column descriptions in incorrect order #1348
  • Fixed an issue with spatial datatypes casting error when Always Encrypted is enabled #1353
  • Fixed an issue with DatabaseMetaData.getColumns() not returning correct type for IS_AUTOINCREMENT and IS_GENERATEDCOLUMN against Azure Data Warehouse #1356
  • Fixed an issue with Geography.STAsBinary() and Geometry.STAsBinary() returning WKB format instead of CLR format #1364
  • Fixed an issue with allowing non-MSSQL ResultSets to bulk copy DateTimeOffset #1365
  • Fixed issues identified by SonarQube #1369
  • Fixed an issue with batch insertion failing when Always Encrypted is enabled #1378

Changed

  • Updated Gradle build file to fix Azure pipelines #1359
  • Added database name to Always Encrypted enclave caching key #1388
  • Added functionality to validate both certificate beginning and expiration dates when creating encrypted connection #1394

[8.3.1] Preview Release

Added

  • Added delayed durability option to SQLServerConnection.commit() #1310
  • Introduced SQLServerBulkCSVFileRecord.setEscapeColumnDelimitersCSV() to escape delimiters and double quotes when using bulk copy to load from CSV files #1312
  • Added certificate expiry validation when using Always Encrypted with secure enclaves feature #1321
  • Added SQL State to Exception when connection is closed #1326
  • Introduced extended bulk copy support against Azure Data Warehouse #1331
  • Introduced 'delayLoadingLobs' connection property to provide backward compatibility when streaming LOBs #1336

Fixed issues

  • Fixed an issue with MSI authentication failing due to expiry date format mismatch #1308
  • Fixed an issue with streams not getting closed when using Always Encrypted with secure enclaves feature #1315
  • Fixed an issue with retrieving SQL VARIANT as its underlying type #1320
  • Fixed issues with the driver not being JAVA 8 compliant #1328
  • Fixed an issue with PreparedStatement when inserting large spatial data types #1337

Changed

  • Updated driver and test dependencies #1294, #1313
  • Improved exception message when connecting to redirection-enabled Azure server #1311
  • Improved performance when parsing connection string #1317
  • Updated the driver to throw a warning when TLS version lower than 1.2 is negotiated #1322
  • Removed unused code #1330

[8.3.0] Preview Release

Added

  • Added connection properties to specify custom SocketFactory #1217
  • Added support for Client Certificate Authentication #1284
  • Added support for JAVA 14 #1290
  • Added support for authentication to Azure Key Vault using Managed Identity #1286

Fixed issues

  • Fixed an issue with escaping curly brackets in connection string #1251
  • Fixed a warning when retrieving Operating System information from SQL Server Linux when using distributed transactions #1279

Changed

  • Updated Gradle dependencies #1244
  • Updated SQLServerPreparedStatement.setObject() to retrieve TVP name from SQLServerDataTable #1282

[8.2.2] HotFix & Stable Release

Added

  • Added an option to configure the list of trusted Azure Key Vault endpoints #1285

[8.2.1] HotFix & Stable Release

Fixed issues

  • Fixed a potential NullPointerException issue when retrieving data as java.time.LocalTime or java.time.LocalDate type with SQLServerResultSet.getObject() #1250

[8.2.0] Stable Release

Added

  • Added new tests for Always Encrypted with secure enclaves feature #1166
  • Added backwards compatibility for calling SQLServerClob.length() on nvarchar columns #1214

Fixed issues

  • Fixed an issue with potentially creating more enclave sessions than needed #1208
  • Fixed an issue with InputStream closing when calling SQLServerBlob.length() on an image column #1214
  • Fixed a potential performance issue created from trailing spaces in PreparedStatement queries #1215
  • Fixed an issue with native Always Encrypted calls not being synchronized #1220
  • Fixed issues identified by SonarQube #1226, Semmle #1234, and CredScanner #1237

Changed

  • Updated com.microsoft.rest:client-runtime to its latest version #1235
  • Removed shaded jars #1239

[8.1.1] Preview Release

Added

  • Added more tests to improve code coverage for Always Encrypted with secure enclaves feature #1186
  • Added certificate and enclave session caching for Always Encrypted with secure enclaves feature #1189

Fixed issues

  • Fixed a potential NullPointerException in SQLServerDataColumn.equals() #1168
  • Fixed an issue with BulkCopy when source is unicode char/varchar and destination is nchar/nvarchar #1193
  • Fixed an issue with SQLServerDatabaseMetaData.getColumns() only returning the first column against Azure SQL Data Warehouse #1197
  • Fixed an issue with SQLServerDatabaseMetaData.getImportedKeys() failing against Azure SQL Data Warehouse #1205

Changed

  • Made internal model public for SQLServerSpatialDatatype class #1169
  • Updated ISQLServerBulkData APIs to throw SQLException instead of SQLServerException #1187
  • Changed SQLServerConnection.state to volatile #1194
  • Optimized temporal datatype getter methods by replacing Calendar with LocalDatetime #1200
  • Updated driver and test dependencies #1203

[8.1.0] Preview Release

Added

  • Added ISQLServerBulkData to remove implementation details from ISQLServerBulkRecord #1099
  • Added support for Azure national clouds when using Azure Key Vault #1130
  • Implemented hashCode() and equals() APIs for SQLServerDataTable and SQLServerDataColumn #1146
  • Added support for JAVA 13 #1151
  • Added support for Always Encrypted with Secure Enclaves #1155

Fixed Issues

  • Fixed Geography.STAsBinary() returning null for a single point #1074
  • Fixed DatabaseMetaData.getImportedKeys() returning duplicate rows #1092
  • Fixed issue with truststore password being removed too early for XA connections #1133
  • Fixed issue with SQLServerDatabaseMetada.getColumns() not escaping wildcard characters #1138
  • Removed extra spaces in SQLServerDatabaseMetaData.getNumericFunctions() and SQLServerDatabaseMetaData.getStringFunctions() return values #1117

Changed

  • Improved performance of column name lookups #1066
  • Test improvements #1100
  • Updated issue templates #1148
  • Improved performance of CallableStatement and ParameterMetaData when using procedure names that contain wildcard characters #1149
  • Updated CI to use SQL Server 2012 instead of 2008R2 #1153

[7.4.1] HotFix & Stable Release

Fixed Issues

  • Reverted #1025 as it contains breaking changes. This removes hashCode() and equals() APIs from SQLServerDataTable and SQLServerDataColumn.

[7.4.0] Stable Release

Fixed Issues

  • Fixed issues reported by Static Analysis Tool - SonarQube #1077 #1103
  • Fixed issues with array bound checking in 'useFmtOnly' implementation #1094

Changed

  • Performance improvements #1075
  • Changed NTLM Authentication implementation to not store password in plain text #1095 #1108
  • Updated the Maven dependency of 'Java Client Runtime for AutoRest' to 1.6.10 version of the library #1097
  • Changed NTLM Authentication error strings #1105

[7.3.1] Preview Release

Added

  • Added support for NTLM Authentication #998
  • Added new connection property 'useFmtOnly' to retrieve parameter metadata #1044
  • Added support for JDK 12 with an additional "jre12" JAR #1050
  • Added 'keyVaultProviderClientId' and 'keyVaultProviderClientKey' connection properties to enhance Always Encrypted usability #902
  • Implemented hashCode() and equals() APIs for SQLServerDataTable and SQLServerDataColumn #1025
  • Added Maven Shade plugin configuration to package the driver jars in uber-jars #1043 #1078 #1081

Fixed Issues

  • Fixed DatabaseMetadata.getColumns() API to return ResultSet as per JDBC 4.3 Specifications #1016
  • Fixed issue with invalid Spatial data types by marking them valid by default #1035
  • Fixed issues with Login Timeout not getting applied appropriately #1049
  • Fixed SharedTimer implementation to use class level lock for thread safety #1046
  • Fixed issues with SQLServerDatabaseMetadata.getMaxConnections() API query #1009
  • Fixed issues with next ResultSet being consumed when reading warnings #991
  • Fixed exception handling in SQLServerPreparedStatement to make it consistent with SQLServerStatement #1003
  • Fixed misleading exception message in SQLServerCallableStatement implementation #1064
  • JUnit Test fixes and improvements #994 #1004 #1005 #1006 #1008 #1015 #1017 #1019 #1027 #1032 #1034 #1036 #1041 #1047 #1060

Changed

  • Improved performance of driver by continuously cleaning up ActivityIds stored in internal Map #1020
  • Improved performance by removing Enum.values() calls to avoid unnecessary array cloning #1065
  • Improved performance of SQLServerDataTable.internalAddRow() function #990

[7.3.0] Preview Release

Added

  • Added support in SQLServerBulkCopy to allow Pooled/XA Connection instances during object creation #968
  • Added support for FLOAT data type for bulk copy operation when using RowSet #986

Fixed Issues

  • Fixed a possible Statement leak in SQLServerConnection.isValid() API #955
  • Fixed rounding behavior when inserting datetime values into SQL Server version 2016 and later #962
  • Fixed SQLServerConnection.abort() API behavior to clear resources consistently #983
  • Fixed SQLServerConnection documentation #984
  • Fixed SQL Exception Error State length to respect SQLSTATE Standards #977

Changed

  • Refactored SELECT_METHOD in SQLServerConnection to not fetch the same connection property twice #987
  • Improved SQLServerParameterMetadata API implementations and code coverage #973

[7.2.1] HotFix & Stable Release

Fixed Issues

  • Fixed parsing issues with certain parameterized queries #950

[7.2.0] Stable Release

Added

  • Added Azure Pipelines CI configuration to trigger Windows Client testing with SQL Server 2017 and SQL Server 2008 R2 #940

Fixed Issues

  • Fixed issue with ThreadPoolExecutor thread preventing JVM from exiting #944
  • Fixed issues reported by Static Analysis Tool - SonarQube #928 #930 #933
  • Fixed Timestamp comparison with "Thai" locale in DataTypesTest #941

Changed

  • Changed timeout request handling implementation to use SharedTimer #920
  • Removed Appveyor CI and updated Travis CI configuration #940

[7.1.4] Preview Release

Added

  • Added APIs for DataSourceFactory and OSGI Framework #700
  • Added support for OffsetDateTime to be passed as 'type' in ResultSet.getObject() #830
  • Added support for Active Directory MSI Authentication #838
  • Added more datatype tests to JUnit test suite #878 #916
  • Added an option to perform JUnit testing against Azure Data Warehouse #903
  • Added new APIs to retrieve SQL Server error information received with SQLServerException #905

Fixed Issues

  • Fixed issue with java.time.OffsetDateTime value sent to the server being affected by the default timezone #831
  • Fixed SSL certificate validation to respect wildcards #836
  • Fixed Bulk Copy for batch insert operation to not error out against specific datatypes #912

Changed

  • Fixed synchronization on a non-final field #860
  • Removed hardcoded error messages from test file #904
  • Updated Issue and Pull Request templates #906
  • Updated JUnit tests by closing all resources consistently and updated Maven dependency versions to latest #919

[7.1.3] Preview Release

Added

  • Added a new SQLServerMetaData constructor for string values of length greater than 4000 #876

Fixed Issues

  • Fixed an issue with Geography.point() having coordinates reversed #853
  • Fixed intermittent test failures #854 #862 #888
  • Fixed an issue with setAutoCommit() leaving a transaction open when running against Azure SQL Data Warehouse #881

Changed

  • Changed query timeout logic to use a single thread #842
  • Code cleanup #857 #873
  • Removed populating Lobs when calling ResultSet.wasNull() #875
  • Improved retry logic for intermittent TLS1.2 issue when establishing a connection #882

[7.1.2] Preview Release

Added

  • Added support for JDK 11 #824 #837 #807
  • Updated SQL keywords in DatabaseMetaData #829
  • Improvements in DatabaseMetadata to prevent Statement leaks and enhance Statement caching #806

Fixed Issues

  • Fixed slf4j warning message in tests #841
  • Fixed potential NullPointerException in logException() #844
  • Fixed intermittent failures in JUnit - LobsTest #827
  • Fixed useBulkCopyForBatchInserts API to respect Statement timeout value #817

Changed

  • Updated JUnit tests to remove hard-coded names #809
  • Removed illegal reflection access in Kerberos Authentication #839
  • Enabled non-running JUnit tests #847
  • Updated Clobs to use StandardCharsets.US_ASCII instead of hard-coded string #855
  • Code cleanup #821 #825

[7.1.1] Preview Release

Added

  • Added streaming capabilities for Clob.getAsciiStream() #799

Fixed Issues

  • Fixed a bug where calling length() after obtaining a stream would close the stream for Clobs/NClobs #799
  • Fixed Clob/NClob encoding issues #799
  • Fixed issues in Bulk Copy exception handling #801
  • Fixed closeable resource leaks in JUnit tests #797
  • Fixed issues with apostrophe being passed in table name #780
  • Fixed statement leaks and improved exception handling in SQLServerParameterMetadata #780

Changed

  • Changed error message to be thrown when data out of range for DECIMAL/NUMERIC types #796

[7.1.0] Preview Release

Added

  • Added support for LocalDate, LocalTime and LocalDateTime to be passed as 'type' in ResultSet.getObject() #749
  • Added support to read SQL Warnings after ResultSet is read completely #785

Fixed Issues

  • Fixed Javadoc warnings and removed obselete HTML tags from Javadocs #786
  • Fixed random JUnit failures in framework tests #762

Changed

  • Improved performance of readLong() function by unrolling loop and using bitwise operators instead of additions #763
  • Removed logging logic which caused performance degradation in AE #773

[7.0.0] Stable Release

Added

  • Added 'Automatic-Module-Name' manifest entry to jre10 Jar, allowing JDK 10 users to access driver module 'com.microsoft.sqlserver.jdbc' #732
  • Added setUseBulkCopyForBatchInsert() to request boundary declaration APIs #739
  • Added new test for validation of supported public APIs in request boundary declaration APIs #746

Fixed Issues

  • Fixed policheck issue with a keyword #745
  • Fixed issues reported by static analysis tools (SonarQube, Fortify) #747

Changed

  • Reformatted code and updated mssql-jdbc-formatter #742
  • Changed Sha1HashKey to CityHash128Key for generating PreparedStatement handle and metadata cache keys #717
  • Changed order of logic for checking the condition for using Bulk Copy API #736
  • Changed collation name in UTF8SupportTest #741
  • Changed scope of unwanted Public APIs #757
  • Changed behavior of Bulk Copy API for batch inserts to disallow non-parameterized queries #756
  • Changed APIs and JavaDocs for Spatial Datatypes #752
  • Improved Javadoc comments in driver #754, #760

[6.5.4] Preview Release

Added

  • Added new connection property "useBulkCopyForBatchInsert" to enable Bulk Copy API support for batch insert operation #686
  • Added implementation for Java 9 introduced Boundary methods APIs on Connection interface #708
  • Added support for "Data Classification Specifications" on fetched resultsets #709
  • Added support for UTF-8 feature extension #722

Fixed Issues

  • Fixed issue with escaping catalog name when retrieving from database metadata #718
  • Fixed issue with tests requiring additional dependencies #729

Changed

  • Made driver default compliant to JDBC 4.2 specifications #711
  • Updated ADAL4J dependency version to 1.6.0 #711
  • Cleaned up socket handling implementation to generalize functionality for different JVMs and simplified the logic for single address case #663

[6.5.3] Preview Release

Added

  • Added removed constructor back to AKV Provider which supports authentication with a customized method to fetch accessToken #675
  • Added support for JDK 10 for both Maven and Gradle #691
  • Added a resource bundle to handle JUnit error strings #698

Fixed Issues

  • Fixed the driver disposing user created credentials when using Kerberos Constrained Delegation #636
  • Fixed an issue with HostnameInCertificate when redirected while connected to Azure #644
  • Fixed an intermittent issue with Prepared Statement handle not found #648
  • Fixed a conflict with JDBC Compliance where the driver was returning marked columns as SS_IS_COMPUTED instead of IS_GENERATED #695
  • Fixed maven build warnings and deprecated Java API warnings #701
  • Fixed some Javadoc related warnings #702

[6.5.2] Preview Release

Added

  • Added new connection property "cancelQueryTimeout" to cancel QueryTimeout on Connection and Statement #674

Fixed Issues

  • Improved performance degradation while maintaining JDBC compliance with results from sp_fkeys #677
  • Fixed an issue where ResultSetMetaData instances created by a ResultSet that has been closed were not persisting #685
  • Fixed an issue with PreparedStatement.setBigDecimal when no scale is passed #684
  • Fixed an issue with Clobs/NClobs not persisting after ResultSet/Connection closes #682

Changed

  • Updated the samples to be usable with Eclipse directly, and updated the driver version used by the samples to 6.4.0.jre9 #679
  • Updated Gradle script for building JDBC Driver #689
  • Updated Maven dependencies for test suite #676
  • Updated multiple Maven dependency and plugin versions #688

[6.5.1] Preview Release

Added

  • Test cases for Date, Time, and Datetime2 data types #558

Fixed Issues

  • Fixed an issue where ResultSetMetadata returned incorrect columnType for Geometry and Geography data types #657
  • Fixed server side CPU Affinity problems caused by uneven connection distribution across NUMA Nodes when multiSubnetFailover is true #662
  • Fixed an issue where Driver wasn't parsing TDS Packets completely to capture exceptions raised inside executed stored procedures #664
  • Fixed an issue where driver throws exception when using setMaxRows() followed by query execution when SHOWPLAN_TEXT is ON #666

Changed

  • Removed unused imports which forced users to import the ADAL4J library #652

[6.5.0] Preview Release

Added

  • Support for spatial datatypes #642

Fixed Issues

  • Fixed blobs becoming unavailable when the Result Set cursor moves or the Result Set closes #595
  • Fixed an issue when attempting to insert an empty or null value into an encrypted column #632
  • Fixed a misleading error message thrown by the driver when a user doesn't have execute permissions #635
  • Fixed statements throwing SQLServerException instead of java.sql.SQLTimeoutException when the query times out #641

Changed

  • Unit tests now use SQLException in most cases instead of SQLServerException.

[6.4.0] Stable Release

Added

  • Support added for AAD Integrated Authentication with ADAL4J on Windows/Linux/Mac OS #603
  • Enable Recover after MSDTC is restarted #581
  • Added Version Update configuration rules to project #541
  • JDK 9 Compatibility + JDBC 4.3 API support added to the driver [#601 (#601)

Fixed Issues

  • Re-introduced Retry Logic for Prepared Statement Caching implementation and remove detect change context function #618 and #620
  • Fixes for SonarQube Reported issues #599
  • Fixes for Random Assertion Errors #597

Changed

  • Updated Appveyor to use JDK9 building driver and running tests #619
  • JDK 7 compilation support removed from the driver #601

[6.3.6] Preview Release

Added

  • Added support for using database name as part of the key for handle cache #561
  • Updated ADAL4J version to 1.3.0 and also added it into README file #564

Fixed Issues

  • Fixed issues with static loggers being set by every constructor invocation #563

[6.3.5] Preview Release

Added

  • Added handle for Account Locked Exception 18486 during login in SQLServerConnection #522

Fixed Issues

  • Fixed the issues with Prepared Statement Metadata Caching implementation #543
  • Fixed issues with static logger member in abstract class 'SQLServerClobBase' #537

[6.3.4] Preview Release

Added

  • Added new ThreadGroup creation to prevent IllegalThreadStateException if the underlying ThreadGroup has been destroyed #474
  • Added try-with-resources to JUnit tests #520

Fixed Issues

  • Fixed the issue with passing parameters names that start with '@' to a CallableStatement #495
  • Fixed SQLServerDataTable creation being O(n^2) issue #514

Changed

  • Changed some manual array copying to System.arraycopy() #500
  • Removed redundant toString() on String objects #501
  • Replaced literals with constants #502

[6.3.3] Preview Release

Added

  • Added connection properties for specifying custom TrustManager #74

Fixed Issues

  • Fixed exception thrown by getters on null columns #488
  • Fixed issue with DatabaseMetaData#getImportedKeys() returns wrong value for DELETE_RULE #490
  • Fixed issue with ActivityCorrelator causing a classloader leak #465

Changed

  • Removed explicit extends Object #469
  • Removed unnecessary return statements #471
  • Simplified overly complex boolean expressions #472
  • Replaced explicit types with <> (the diamond operator) #420

[6.3.2] Preview Release

Added

  • Added new connection property: sslProtocol #422
  • Added "slow" tag to long-running tests #461

Fixed Issues

  • Fixed some error messages #452 & #459
  • Fixed statement leaks #455
  • Fixed an issue regarding loginTimeout with TLS #456
  • Fixed sql_variant issue with String type #442
  • Fixed issue with throwing error message for unsupported datatype #450
  • Fixed issue that initial batchException was not thrown #458

Changed

  • Changed sendStringParameterAsUnicode to impact set/update null #445
  • Removed connection property: fipsProvider #460
  • Replaced for and while loops with foeach loops #421
  • Replaced explicit types with the diamond operator #468 & #420

[6.3.1] Preview Release

Added

  • Added support for datetime/smallDatetime in TVP #435
  • Added more JUnit tests for Always Encrypted #432

Fixed Issues

  • Fixed getString issue for uniqueIdentifier #423

Changed

  • Skip long running tests based on Tag #425
  • Removed volatile keyword #409

[6.3.0] Preview Release

Added

  • Added support for sql_variant datatype #387
  • Added more JUnit tests for Always Encrypted #404

Fixed Issues

  • Fixed Turkey locale issue when lowercasing an "i" #384
  • Fixed issue with incorrect parameter count for INSERT with subquery #373
  • Fixed issue with running DDL in PreparedStatement #372
  • Fixed issue with parameter metadata with whitespace characters #371
  • Fixed handling of explicit boxing and unboxing #84
  • Fixed metadata caching batch query issue #393
  • Fixed javadoc issue for the newest maven version #385

Changed

  • Updated ADAL4J dependency to version 1.2.0 #392
  • Updated azure-keyvault dependency to version 1.0.0 #397

[6.2.2] Hotfix & Stable Release

Changed

  • Updated ADAL4J to version 1.2.0 and AKV to version 1.0.0 #516

[6.2.1] Hotfix & Stable Release

Fixed Issues

  • Fixed queries without parameters using preparedStatement #372

Changed

  • Removed metadata caching #377

[6.2.0] Release Candidate

Added

  • Added TVP and BulkCopy random data test for all data types with server cursor #319
  • Added AE setup and test #337,328
  • Added validation for javadocs for every commit #338
  • Added metdata caching #345
  • Added caching mvn dependencies for Appveyor #320
  • Added caching mvn dependencies for Travis-CI #322
  • Added handle for bulkcopy exceptions #286
  • Added handle for TVP exceptions #285

Fixed Issues

  • Fixed metadata caching issue with AE on connection #361
  • Fixed issue with String index out of range parameter metadata #353
  • Fixed javaDocs #354
  • Fixed javaDocs #299
  • Performance fix from @brettwooldridge #347
  • Get local host name before opening TDSChannel #324
  • Fixed TVP Time issue #317
  • Fixed SonarQube issues #300
  • Fixed SonarQube issues #301
  • Fixed random TDS invalid error #310
  • Fixed password logging #298
  • Fixed bulkcopy cursor issue #270

Changed

  • Refresh Kerberos configuration #279

[6.1.7] Preview Release

Added

  • Added support for data type LONGVARCHAR, LONGNVARCHAR, LONGVARBINARY and SQLXML in TVP #259
  • Added new connection property to accept custom JAAS configuration for Kerberos #254
  • Added support for server cursor with TVP #234
  • Experimental Feature: Added new connection property to support network timeout #253
  • Added support to authenticate Kerberos with principal and password #163
  • Added temporal types to BulkCopyCSVTestInput.csv #262
  • Added automatic detection of REALM in SPN needed for Cross Domain authentication #40

Changed

  • Updated minor semantics #232
  • Cleaned up Azure Active Directory (AAD) Authentication methods #256
  • Updated permission check before setting network timeout #255

Fixed Issues

  • Turn TNIR (TransparentNetworkIPResolution) off for Azure Active Directory (AAD) Authentication and changed TNIR multipliers #240
  • Wrapped ClassCastException in BulkCopy with SQLServerException #260
  • Initialized the XA transaction manager for each XAResource #257
  • Fixed BigDecimal scale rounding issue in BulkCopy #230
  • Fixed the invalid exception thrown when stored procedure does not exist is used with TVP #265

[6.1.6] Preview Release

Added

  • Added constrained delegation to connection sample #188
  • Added snapshot to identify nightly/dev builds #221
  • Clarifying public deprecated constructors in LOBs #226
  • Added OSGI Headers in MANIFEST.MF #218
  • Added cause to SQLServerException #202

Changed

  • Removed java.io.Serializable interface from SQLServerConnectionPoolProxy #201
  • Refactored DROP TABLE and DROP PROCEDURE calls in test code #222
  • Removed obsolete methods from DriverJDBCVersion #187

Fixed Issues

  • Typos in SQLServerConnectionPoolProxy #189
  • Fixed issue where exceptions are thrown if comments are in a SQL string #157
  • Fixed test failures on pre-2016 servers #215
  • Fixed SQLServerExceptions that are wrapped by another SQLServerException #213
  • Fixed a stream isClosed error on LOBs test #233
  • LOBs are fully materialised #16
  • Fix precision issue in TVP #217
  • Re-interrupt the current thread in order to restore the threads interrupt status #196
  • Re-use parameter metadata when using Always Encrypted #195
  • Improved performance for PreparedStatements through minimized server round-trips #166

[6.1.5] Preview Release

Added

  • Added socket timeout exception as cause#180
  • Added Constrained delegation support#178
  • Added JUnit test for Statement test#174
  • Added test for statement.cancel() when MultiSubnetFailover is set to true#173
  • Added tests for lobs #168
  • Added badges for License, Maven Central, JavaDocs & gitter chat room #184

Changed

  • Enabled update counts for SELECT INTO statements#175
  • Use Executor service instead of thread#162
  • Convert socket adaptor to socket#160

Fixed Issues

  • Fixed local test failures #179
  • Fixed random failure in BulkCopyColumnMapping test#165

[6.1.4] Preview Release

Added

  • Added isWrapperFor methods for MetaData classes#94
  • Added Code Coverage #136
  • Added TVP schema test #137
  • Introduced FIPS boolean property #135
  • Added unit statement test cases #147

Changed

  • Enabled AAD Authentication with Access Token on Linux #142
  • Enabled AAD Authentication with ActiveDirectoryPassword on Linux #146
  • Made Azure Key Vault and Azure Active Directory Authentication Dependencies optional #148
  • Getting TVP name from ParameterMetaData when using TVP with a stored procedure #138

Fixed Issues

  • Fixed getBinaryStream issue #133
  • Fixed an issue of Bulk Copy when AlwaysEncrypted is enabled on connection and destination table is not encrypted #151

[6.1.3] Preview Release

Added

  • Added Binary and Varbinary types to the jUnit test framework #119
  • Added BulkCopy test cases for csv #123
  • Added BulkCopy ColumnMapping test cases #127

Changed

  • Switched to clean rounding for bigDecimal #118
  • Updated BVT tests to use jUnit test framework #120
  • In case of socket timeout occurrence, avoid connection retry #122
  • Changed ant build file to skip tests #126

Fixed Issues

  • Fixed the inconsistent coding style #4
  • Fixed NullPointerException in case when SocketTimeout occurs #65

[6.1.2] Preview Release

Added

  • Socket timeout implementation for both connection string and data source #85
  • Query timeout API for datasource #88
  • Added connection tests #95
  • Added Support for FIPS enabled JVM #97
  • Added additional tests for bulk copy [#110] (#110)

Changed

  • Remove redundant type casts #63
  • Read SQL Server error message if status flag has DONE_ERROR set #73
  • Fix a bug when the value of queryTimeout is bigger than the max value of integer #78
  • Add new dependencies to gradle build script #81
  • Updates to test framework #90

Fixed Issues

  • Set the jre8 version as default #59
  • Fixed exception SQL Server instance in use does not support column encryption #65
  • TVP Handling is causing exception when calling SP with return value #80
  • BigDecimal in TVP can incorrectly cause SQLServerException related to invalid precision or scale #86
  • Fixed the connection close issue on using variant type [#91] (#91)

[6.1.1] Preview Release

Added

  • Java Docs #46
  • Driver version number in LOGIN7 packet #43
  • Travis- CI Integration #23
  • Appveyor Integration #23
  • Make Ms Jdbc driver more Spring friendly #9
  • Implement Driver#getParentLogger #8
  • Implement missing MetaData #unwrap methods #12
  • Added Gradle build script #54
  • Added a queryTimeout connection parameter #45
  • Added Stored Procedure support for TVP #47

Changed

  • Use StandardCharsets #15
  • Use Charset throughout #26
  • Upgrade azure-keyvault to 0.9.7 #50
  • Avoid unnecessary calls to String copy constructor #14
  • make setObject() throw a clear exception for TVP when using with result set #48
  • Few clean-ups like remove wild card imports, unused imports etc. #52
  • Update Maven Plugin #55

[6.1.0] Stable Release

Changed

  • Open Sourced.