Purpose

Determines how the driver describes database data types that map to the following JDBC 4.0 data types: NCHAR, NVARCHAR, NLONGVARCHAR, NCLOB, and SQLXML. In addition, it controls whether the PROCEDURE_NAME column returned by DatabaseMetadata.getProcedures() and DatabaseMetadata.getProcedureColumns() contains procedure name qualifiers.

This property is applicable only when the application is using Java SE 6 or higher.

Valid Values

0 | 1

Behavior

If set to 0, the driver describes the data types as JDBC 4.0 data types when using Java SE 6or higher. Additionally, the PROCEDURE_NAME column does not contain procedure name qualifiers in the specific_name column. For example, for the fully qualified procedure name 1.sp_productadd, the driver would return sp_productadd instead of sp_productadd;1.

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 6 or higher environment. Additionally, the PROCEDURE_NAME column contains procedure name qualifiers. For example, for the fully qualified procedure name 1.sp_productadd, the driver would return sp_productadd;1.

Default

1

Data Type

int