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.
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 |