Snap Pack History: SQL Server
|
|
|
Updates |
|---|---|---|---|
|
|
|
Fixed an issue with the SQL Server - Stored Procedure Snap where the Snap failed with datatype conversion errors when passing datetimeoffset or LocalDateTime values. This fix ensures that values passed to stored procedures are in the correct data types, preventing conversion errors and ensuring reliable execution. |
|
|
|
Updated and certified against the current SnapLogic Platform release. |
|
|
|
Fixed an issue with the SQL Server - Insert Snap where pipeline executions failed when using the jTDS JDBC driver with NVARCHAR columns, resulting in the error Invalid java.sql.Types constant value -9.
The jTDS driver is now obsolete and is no longer maintained. Using this driver with Unicode data types, such as NCHAR, NVARCHAR, or NTEXT, can lead to data corruption or loss, as these types are not fully supported. We highly recommend you to use the Microsoft JDBC Driver for SQL Server (com.microsoft.sqlserver.jdbc.SQLServerDriver), which offers complete support for Unicode data types and is actively maintained. |
|
|
|
Enhanced the SQL Server Snap Pack to support v18.x of the BCP utility. Starting with v18.x, the BCP utility enforces SSL certificate verification by default. This may cause the SQL Server - Bulk Load Snap to fail with a certificate verification error if your SQL Server Account is not configured for Pipelines using BCP versions lower than v18.x are not affected.
Action Required: If you upgrade your BCP to v18.x or higher, set the URL property value as trustServerCertificate=true in your SQL Server Account to allow the Bulk Load Snap to work. |
|
|
|
Fixed a null pointer exception issue in the SQL Server - Execute Snap when the key or value in the URL properties field in the SQL Server Account or SQL Server Dynamic Account was left blank. |
|
|
|
Updated and certified against the current SnapLogic Platform release. |
|
|
|
Fixed the Null Pointer Exception (NPE) issue in the SQL Server Snaps. Now, these Snaps display an exception error instead of NPE when the URL properties (key and value) and either key or value are empty. |
|
|
|
Fixed an issue with the SQL Server - Select,SQL Server - Execute, and SQL Server - Insert Snaps that failed with ClassCastException for geometry and geography data types when using custom jar files. |
|
|
|
Updated and certified against the current SnapLogic Platform release. |
|
|
|
Updated and certified against the current SnapLogic Platform release. |
|
|
|
Reinstated support for the jTDS driver in the SQL Server Snap Pack. |
|
|
|
Updated and certified against the current SnapLogic Platform release. |
|
|
|
Fixed an issue with the SQL Server - Select Snap configured with an Ultra Tasks to handle temporary database unavailability. The Snap now validates the database connection to ensure that it is reestablished after temporary database outages. |
|
|
|
Fixed an issue with the SQL Server - Insert Snap that caused an error when inserting the infinity value into a decimal-type column. |
|
|
|
Fixed a case-sensitivity issue with the SQL Server - Bulk Load Snap that caused a NullPointerException when retrieving the PATH environment variable in a Windows environment. This change is applicable only to Windows, as environment variables are case-sensitive in Linux. |
|
|
|
Updated the Delete Condition (Truncates a Table if empty) field in the SQL Server - Delete Snap to Delete condition (deletes all records from a table if left blank) to indicate that all entries will be deleted from the table when this field is blank, but no truncate operation is performed. |
|
|
|
Fixed an issue with the SQL Server Snap Pack that displayed an error when numeric values with scale 0 were inserted into the database with DECIMAL or NUMERIC type columns, instead of inserting the value with decimal digits truncated.
Fixed an issue with the SQL Server Snap Pack that displayed an error when fractional numeric values (numbers with a decimal point) were inserted into the database with an INT type column, instead of inserting the value with decimal digits truncated. |
|
|
|
Fixed an issue with the SQL Server - Insert Snap that previously displayed an error when attempting to insert a true or false value into a TinyInt datatype. The Snap now correctly inserts 1 or 0 for true or false in the table, respectively. |
|
|
|
Added support for XML and spatial types (Geography and Geometry) for SQL Server Snap Pack.
Fixed an issue with the SQL Server - Insert Snap that displayed an error when an empty or blank string was passed as a value to an integer-type column. Behavior change: As part of the JOOQ upgrade done in main25112, the SQL Server - Insert Snap displayed the following error when an empty string was inserted to an integer-type column: Caused by: java.lang.NumberFormatException: Character n is neither a decimal digit number, decimal point, nor "e" notation exponential mark. Now, the Snap inserts a null value in this scenario. |
|
|
|
As of main25112, the SQL Server Snap Pack no longer supports the jDTS driver. If you are using the latest SQL Server driver versions (2014 and higher), we recommend you use the driver that is bundled with the SQL Server Snap Pack. Note that the older SQL Server versions are supported as is. |
|
|
|
Updated and certified against the current SnapLogic Platform release. |
|
|
|
Fixed an issue with the SQL Server - Stored Procedure and SQL Server - Table List Snaps that caused no retries to be executed even if you select the number of retries in the UI when a custom JDBC driver was used. |
|
|
|
Improved the SQL Server - Bulk Load Snap to reduce the chance of causing a deadlock error. |
|
|
|
The SQL Server - Execute Snap now includes a new Query type field. When Auto is selected, the Snap tries to determine the query type automatically. |
|
|
|
The SQL Server - Stored Procedure and SQL Server - Table List Snaps now support the retry functionality. |
|
|
|
The SQL Server Snap Pack is upgraded to the latest version of the Microsoft JDBC Driver 12.2.0.jre11 for SQL Server:
Pipelines using the default JAR in the SQL server accounts might fail after the driver upgrade because the latest driver is backward-incompatible. To prevent your accounts from failing, reconfigure the URL properties field in account settings as follows: trustServerCertificate = true Pipelines NOT using the default driver (bundled with the SQL Server Snap Pack) will not fail. Note: This update will be a part of the stable distribution with the GA release on August 9, 2023. Learn more about the SQL Server driver upgrade: FAQ for Upgrading to SQL Server JDBC Driver 12.2.0
Fixed an issue with the SQL Server - Insert Snap that was causing performance degradation between GA release 4.32 and 4.33 if the network connection between the Groundplex and the database server was slow. |
|
|
|
The SQL Server Snap Pack is upgraded to the latest version of the Microsoft JDBC Driver 12.2.0.jre11 for SQL Server:
Pipelines using the default JAR in the SQL server accounts might fail after the driver upgrade because the latest driver is backward-incompatible. To prevent your accounts from failing, reconfigure the URL properties field in account settings as follows: trustServerCertificate = true Pipelines NOT using the default driver (bundled with the SQL Server Snap Pack) will not fail. The Microsoft JDBC Driver 12.2.0.jre11 for SQL Server included in the SQL Server Snap Pack is currently NOT available with the latest distribution. However, you can still consume this patch through 433patches21386. This update is scheduled to be included in the upcoming distribution release on July 12, 2023, and will be a part of the stable distribution with the GA release on August 9, 2023. |
|
|
|
Updated the SQL Server - Bulk Load Snap to preserve empty strings as empty strings and null as nulls. |
|
|
|
Upgraded with the latest SnapLogic Platform release. |
|
|
|
Upgraded with the latest SnapLogic Platform release. |
|
|
|
The SQL Server - Insert Snap no longer no longer includes the Preserve case-sensitivity checkbox because the database is case-insensitive. The database stores the data regardless of whether the columns in the target table and the input data are in mixed, lower, or upper case. |
|
|
|
The SQL Server - Insert Snap now displays the error, Number overflow: <number> (instead of Batch operation failed) when inserting a number into tinyinit column. |
|
|
|
A memory leak in the SQL Server - Stored Procedure Snap is fixed. The Snap now clears the closed connections from memory and retains the open connections. |
|
|
|
The SQL Server accounts failed with a certificate error on Windows Snaplexes when using the default SQL driver with the 4.31 main18944 build. This patch addresses the certificate error issue. |
|
|
|
The SQL Server - Insert Snap now creates the target table only from the table metadata of the second input view when the following conditions are met:
|
|
|
|
The SQL Server - Select Snap now has the Convert rowversion datatype to integer checkbox to support the ROWVERSION data type. Select this checkbox to display the ROWVERSION data type as integers in the output. |
|
|
|
The SQL Server - Execute Snap containing an explicit SQL transaction now works as expected when using a default JDBC driver. |
|
|
|
Upgraded with the latest SnapLogic Platform release. |
|
|
|
Fixed an issue with the SQL Server - Execute Snap where the Snap did not display a valid error message when the delete condition is invalid. |
|
|
|
Enhanced the SQL Server - Bulk Load Snap with the Batch Size field to process records in a batch. |
|
|
|
Enhanced the SQL Server - Select and SQL Server - Lookup Snaps with Option for Unique Identifier Column that allows you to convert the case to lower or upper while displaying the Unique Identifier output (display) value. |
|
|
|
Updated the label for Delete Condition to Delete Condition (Truncates Table if empty) in the SQL Server - Delete Snap. |
|
|
|
Enhanced the SQL Server - Execute Snap to invoke stored procedures. |
|
|
|
Fixed an issue in the SQL Server - Bulk Load Snap where boolean data type failed to load into BIT field. |
|
|
|
Upgraded with the latest SnapLogic Platform release. |
|
|
|
Fixed an issue with the SQL Server - Bulk Load Snap where the Snap fails when the login password contains a colon or a less than (<) symbol. |
|
|
|
Upgraded with the latest SnapLogic Platform release. |
|
|
|
Enhances the SQL Server - Select Snap by introducing a new field, Query Hints, which helps to customize and optimize the database engine to process query statements. |
|
|
|
Enhances the SQL Server - Select Snap to return only the selected output fields or columns in the output schema (second output view) using the Fetch Output Fields In Schema check box. If the Output Fields field is empty all the columns are visible.
Enhances the SQL Server - Stored Procedure Snap to accept parameters from input documents by column keys. If the values are empty, the parameters are populated based on the column keys for easier mapping in the upstream Mapper Snap. |