In this article
...
As part of the JOOQ upgrade done in main25112, the SQL Server-Insert Snap displayed an error Caused by: java.lang.NumberFormatException: Character n is neither a decimal digit number, decimal point, nor "e" notation exponential mark when an empty string was inserted into an integer-type column. Now, The Snap inserts a null value in this scenario.
Limitations and Known Issues
...
| Info |
|---|
|
): Indicates a list that is dynamically populated based on the configuration.Field Name | Field Type | Description | ||||||
|---|---|---|---|---|---|---|---|---|
Label* Default Value: SQL Server - Insert | String | Specify a unique name for the Snap. | ||||||
Schema Name Default Value: N/A | String/Expression | Specify the database schema name. In case it is not defined, then the suggestion for the Table Name will retrieve all tables names of all schemas. The property is suggestible and will retrieve available database schemas during suggest values. The values can be passed using the Pipeline parameters but not the upstream parameter. You cannot use Pipeline parameters within your SQL statement. If you need to use parameters, insert a Mapper (Data) Snap before the SQL Snap and call them there. The Snap can then use the substituted values through the input view. | ||||||
Table Name* Default Value: N/A | String/Expression | Specify the name of a table to execute insert on. The values can be passed using the Pipeline parameters but not the upstream parameter. | ||||||
Create table if not present
| Checkbox |
| ||||||
Number of retries
| Integer/Expression | Specify the maximum number of attempts to be made to receive a response. The request is terminated if the attempts do not result in a response. | ||||||
Retry interval (seconds)
| Integer/Expression | Specify the time interval between two successive retry requests. A retry happens only when the previous attempt resulted in an exception. | ||||||
Enable identity insert
| Integer/Expression | Select the checkbox to insert values from the input document into the target table identity column. Ensure that the target table contains an identity column. If you do not select the check box, then do not enter any value for the identity column in the input document. | ||||||
Snap Execution Default Value: Execute only | Dropdown list |
|
...
| Info |
|---|
This Snap will not automatically fix some errors encountered during table creation because it requires user intervention to resolve correctly. For example, if the source table contains a column with a type that does not have a direct mapping in the target database, the Snap fails to execute. You then need to add a Mapper Snap to change the metadata document to explicitly set the values needed to produce a valid "CREATE TABLE" statement. |
Example
Inserting Data Into a Table
...