skip to main content
Configuring Hybrid Data Pipeline for JDBC : Connection properties reference : ConvertNull
  

Try Now

ConvertNull

Purpose

Controls how the driver handles data conversions for null values.

Valid Values

0 | 1

Behavior

If set to 0, the driver does not perform the data type check if the value of the column is null. This allows null values to be returned even though a conversion between the requested type and the column type is undefined.
If set to 1, the driver checks the data type being requested against the data type of the table column that stores the data. If a conversion between the requested type and column type is not defined, the driver generates an "unsupported data conversion" exception regardless of whether the column value is NULL.

Default

1

Data Type

int