Nonstop Database, HiRDB Version 9 UAP Development Guide

[Contents][Index][Back][Next]

18.13.1 System properties related to the DABroker for Java-compatible facility

You use system properties to specify connection information related to the DABroker for Java-compatible facility. The table below lists and describes the system properties to be specified.

Note that for an internal driver, system property specifications are ignored.

Table 18-83 System properties related to the DABroker for Java-compatible facility

Property name Description Specification
HiRDB_for_Java_DAB_CONVERT_NULL Specifies whether the setString and getString methods of the CallableStatement class are to be run in the DABroker for Java-compatible mode. If this property is omitted, FALSE is assumed. The specified value is not case sensitive.

TRUE
Runs the methods in the DABroker for Java-compatible mode.
If the data type of a ? parameter in the setString method is CHAR, VARCHAR, NCHAR, NVARCHAR, MCHAR, or MVARCHAR, and a character string with a length of 0 is specified in the argument, null is set in the ? parameter.
If the ? parameter value acquired by the getString method is a character string with a length of 0, null is set as the return value.

FALSE
Does not run the methods in the DABroker for Java-compatible mode.
If the data type of a ? parameter in the setString method is CHAR, VARCHAR, NCHAR, NVARCHAR, MCHAR, or MVARCHAR, and a character string with a length of 0 is specified in the argument, a character string with a length of 0 is set in the ? parameter.
If the ? parameter value acquired by the getString method is a character string with a length of 0, a character string with a length of 0 is set as the return value.

Other
The driver assumes that FALSE is specified.
Optional
HiRDB_for_Java_DAB_STATEMENT_COMMIT_BEHAVIOR Specifies whether the processing for disabling the objects of Statement during commit execution is to be run in the DABroker for Java-compatible mode. If this property is omitted, FALSE is assumed. The specified value is not case sensitive.

TRUE
Makes the processing compatible with DABroker for Java.
If commit processing is performed, the objects of Statement are disabled.

FALSE
Does not make the processing compatible with DABroker for Java.
The driver uses a value specified by another method. For details about the specification method, see 18.11(1) List of connection information priorities.

Other
The driver assumes that FALSE is specified.
Optional
HiRDB_for_Java_DAB_EXECUTESQL_NOCHK Specifies whether the executeQuery and executeUpdate methods of Statement are to be run in the DABroker for Java-compatible mode. If this property is omitted, FALSE is assumed. The specified value is not case sensitive.

TRUE
Runs the methods in the DABroker for Java-compatible mode.
  • The executeQuery method of Statement can be used to execute non-retrieval SQL statements.
  • The executeUpdate method of Statement can be used to execute retrieval SQL statements.
  • If a non-retrieval SQL statement is executed by the execute, executeQuery, or executeUpdate method of Statement and then the getResultSet method is executed, the driver returns a ResultSet containing no columns.

FALSE
Does not run the methods in the DABroker for Java-compatible mode.
  • If the executeQuery method of Statement is used to execute a non-retrieval SQL statement, the driver throws an SQLException.
  • If the executeUpdate method of Statement is used to execute a retrieval SQL statement, the driver throws an SQLException.
  • If a non-retrieval SQL statement is executed by the execute or executeUpdate method of Statement and then the getResultSet method is executed, the driver returns null.

Other
The driver assumes that FALSE is specified.
Optional
HiRDB_for_Java_DAB_OUTPARMSIZE_MAX Specifies whether the registerOutParameter method of the CallableStatement class is to be run in the DABroker for Java-compatible mode. If this property is omitted, FALSE is assumed. The specified value is not case sensitive.

TRUE
Runs the method in the DABroker for Java-compatible mode.
If the VARCHAR, NVARCHAR, or MVARCHAR data type has been acquired for INOUT or OUT parameters by CALL statement preprocessing and this data type is registered as java.sql.Types.CHAR by the registerOutParameter method of the CallableStatement class, the getString method of the CallableStatement class returns the maximum size of data acquired by preprocessing.
If the data set by the stored procedure is smaller than the maximum size of data acquired by preprocessing, spaces are added to the data set by the stored procedure to match the maximum size acquired by preprocessing.

FALSE
Does not run the method in the DABroker for Java-compatible mode.
If the VARCHAR, NVARCHAR, or MVARCHAR data type has been acquired for INOUT or OUT parameters by CALL statement preprocessing and this data type is registered as java.sql.Types.CHAR by the registerOutParameter method of the CallableStatement class, the getString method of the CallableStatement class returns the data set by the stored procedure as is. No spaces are added to the data set by the stored procedure.

Other
The driver assumes that FALSE is specified.
Optional