skip to main content
Using the driver : Using connection properties : Data type handling properties
  

Try DataDirect Drivers Now

Data type handling properties

The following table summarizes connection properties which can be used to handle data types.
Table 17. Data type handling properties
Property
Characteristic
Controls how data conversions are handled for null values.
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.
The default is 1.
Determines how the driver describes native data types that map to the following JDBC 4.0 data types: NCHAR, NVARCHAR, NLONGVARCHAR, NCLOB, and SQLXML.
If set to 0, the driver describes the data types as JDBC 4.0 data types when using Java SE 8 or higher.
If set to 1, the driver describes the data types using JDBC 3.0-equivalent data types, regardless of JVM. This allows your application to continue using JDBC 3.0 types in a Java SE 8 or higher environment.
The defaut is 1.