JDBC Driver release notes for 2022¶

New features and updates¶

• Upgraded the arrow library from version 9.0.0 to 10.0.1.

• Relocated files in META-INF/versions to META-INF/versions/<version_number>/net/snowflake/client/jdbc/internal.

• Added the getNano() and getOffset() methods to the SnowflakeTimeWithTimezone object to return the number of nanoseconds and the time zone offset, respectively.

BCR (Behavior Change Release) change¶

New features and updates¶

• Set the default value of the allowUnderscoresInHost parameter to false, which converts underscores in account names to hyphens to avoid Apache httpclient connection errors with underscores. This behavior can be turned off by setting allowUnderscoresInHost to true.

• Updated the aws-java-sdk-bom library version from 1.11.394 to 1.12.327.

• Added the enableReturnTimestampWithTimeZone parameter to set whether to include the timezone in a timestamp.

• Added log warnings for each of the error return paths while parsing a SnowflakeConnectString.

• Added commas to the SnowflakeDatabaseMetaData.getColumn() arguments to improve readability.

• Added support for stored procedures.

Bug fixes¶

• Fixed an issue related to using the GET command when GCS_USE_DOWNSCOPED_CREDENTIAL is true.

• Fixed an issue related to returning result types when the session handle is NULL.

BCR (Behavior Change Release) change¶

New features and updates¶

• Upgraded the following libraries:

  • arrow from version 8.0.0 to 9.0.0

  • jacksondatabind from version 2.13.2.2 to 2.13.4.2

  • google-cloud-storage from version 2.5.0 to 2.6.2

• The Statement.getMoreResults() function now returns TRUE when more statements are available to iterate through in a multi-statement query.

• The Statement.getupdateCount() function now returns 0 instead of -1 for non-DML queries.

New features and updates¶

• Enabled the parallelism parameter for PUT/GET commands when using Azure.

Bug fixes¶

• Fixed an issue with NoClassDefFoundError in Google libraries in the FIPs driver.

• Fixed error that occurred when getting procedures with a reader account.

New features and updates¶

• Updated the tika-core library to version 2.4.1.

• Added support for the new Okta OIE (Okta Identity Engine).

Bug fixes¶

• Fixed an issue where getColumnClassName() threw an exception when the column type is timestamp_tz.

• Fixed an issue where calling getSQLStateType() throws an exception while retrieving database metadata.

• Fixed an issue where calling executeLargeBatch() for prepared statements might result in no rows being inserted.

• Fixed an issue where QueryStatus could return invalid error codes and messages.

• Fixed a null pointer exception that sometimes occurred for session-less clients.

New features and updates¶

• Added the getStreams function to the SnowflakeDatabaseMetaData object to list active streams.

• Updated the prefetch memory maximum retry value to improve chunk download performance.

Bug fixes¶

• Fixed a memory leak issue with the statement object in the snowflakeConnectionV1::createResultSet function.

• Fixed a memory leak issue with arrow result sets.

• Fixed an issue with missing data in the JDBC chunk downloader.

New features¶

• Implemented fast fail functionality for 404 errors returned from Amazon S3.

• Updated the following dependency in the JDBC driver:

  • arrow version 7.0.0 to 8.0.0

• Upgraded the following Google library versions:

  • google-auth-library from 0.9.0 to 1.5.3

  • google-cloud-storage from 1.82.0 to 2.5.0

  • google api client versions 1.30.10 to 1.33.2

  • google http client versions 1.36.0 to 1.41.4

New features¶

• Updated the isValid() function to send a heartbeat call instead of a SELECT 1 to validate the session connection.

• Added support for setting VARBINARY byte[] arrays in the SnowflakePreparedStatement.setObject() function.

• Updated the following dependencies in the JDBC driver:

  • arrow version 0.15.1 to 7.0.0

  • jackson version 2.11.0 to 2.13.2

  • bouncy version 1.64 to 1.70

Bug fixes¶

• Fixed an issue with TIMESTAMP_INPUT_FORMAT for stage binding.

New features¶

• Upgraded the arrow and jackson libraries.

Bug fixes¶

Stopped appending retryCount to a scoped URL for chunk downloading.

New features¶

• Added getters for the timezone and ZonedDateTime for the SnowflakeTimestampWithTimezone object.

Bug fixes¶

• Created a patch for driver release v3.13.16 that fixes incorrect behavior for getSchemas() function.

• Fixed the setting of invalid JVM parameters proxyHost and proxyPort.

Bug fixes¶

• Fixed an issue where the nonProxyHosts parameter setting was not honored.

Bug fixes¶

• Refactored the isFileTransfer function into the base class.

• Refactored the FileTransferAgent facade classes into base class

• Fixed a segmentation fault issue within Graal VM Native Image applications.

• Fixed and issue that cause the ChunkDownloader to hang.

Bug fixes¶

• Added streaming ingest related metadata for streaming ingest billing.

• Updated BC FIPS version in the public POM.

Bug fixes¶

• Fixed an issue where the JDBC driver was not updating stageInfo for information related to s3RegionalURL.

• Fixed an issue with account names containing underscores.

• Fixed an issue where an empty result set was returned for schemas containing double quotes when calling getTables() or getColumns().

• Fixed an issue where getProcedureColumns() was not working with wildcards.