Nonstop Database, HiRDB Version 9 UAP Development Guide
The tables in this subsection list the items that are not compatible with a Type4 JDBC driver for the various versions of DABroker for Java and Cosminexus.
Table 18-84 Items that are not compatible with a Type4 JDBC driver (part 1)
| Incompatible item | DABroker for Java | Type4 JDBC driver | |
|---|---|---|---|
| Handling of character string with a length of 0 by the setString and getString methods of the CallableStatement class | setString method | If the data type of a ? parameter is CHAR, VARCHAR, NCHAR, NVARCHAR, or MVARCHAR and a character string with a value of 0 is set in the argument, null is set in the ? parameter. | If the data type of a ? parameter is CHAR, VARCHAR, NCHAR, NVARCHAR, or MVARCHAR and a character string with a value of 0 is set in the argument, a character string with a length of 0 is set in the ? parameter. |
| getString method | If the acquired ? parameter value is a character string with a length of 0, null is set as the return value. | If the acquired ? parameter value is a character string with a length of 0, a character string with a length of 0 is set as the return value. | |
| Status of Statement after commit execution | If commit processing is performed, the objects of Statement are disabled. | If commit processing is performed, the objects of Statement are enabled. | |
Table 18-85 Items that are not compatible with a Type4 JDBC driver (part 2)
| Incompatible item | DABroker for Java | Type4 JDBC driver | |
|---|---|---|---|
|
executeQuery method |
|
Only retrieval SQL statements can be executed. |
| executeUpdate method |
|
Only non-retrieval SQL statements can be executed. | |
| getResultSet method | If the getResultSet method is executed after a non-retrieval SQL statement was executed by the execute, executeQuery, or executeUpdate method of Statement, a ResultSet containing no columns is returned. | If the getResultSet method is executed after a non-retrieval SQL statement was executed by the execute or executeUpdate method of Statement, null is returned. | |
Table 18-86 Items that are not compatible with a Type4 JDBC driver (part 3)
| Incompatible item | DABroker for Java | Type4 JDBC driver |
|---|---|---|
| Data received by the getString method of the CallableStatement class when 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 maximum size of data acquired by preprocessing is returned. 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. |
The data set by the stored procedure is returned. No spaces are added to the data set by the stored procedure. |
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.