Nonstop Database, HiRDB Version 9 UAP Development Guide

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

18.13.2 Items that are not compatible with a Type4 JDBC driver

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.

DABroker for Java and Cosminexus versions:
  • DABroker for Java Version 2 02-10 or earlier
  • Cosminexus Studio Version 5 05-05-/E or earlier
  • Cosminexus Application Server Version 5 05-05-/E or earlier
  • Cosminexus Developer Version 5 05-05-/E or earlier

    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.

DABroker for Java and Cosminexus versions:
  • DABroker for Java Version 2 02-07 or earlier
  • Cosminexus Studio Version 5 05-05 or earlier
  • Cosminexus Application Server Version 5 05-05 or earlier
  • Cosminexus Developer Version 5 05-05 or earlier

    Table 18-85 Items that are not compatible with a Type4 JDBC driver (part 2)

    Incompatible item DABroker for Java Type4 JDBC driver

    • Types of SQL statements that can be executed by the executeQuery and executeUpdate methods of Statement
    • Return value of the getResultSet method after execution of a non-retrieval SQL statement
    executeQuery method
    • All SQL statements can be executed.
    • If a non-retrieval SQL statement is executed, a ResultSet containing no columns is returned.
    Only retrieval SQL statements can be executed.
    executeUpdate method
    • All SQL statements can be executed.
    • If a retrieval SQL statement is executed, -1 is returned.
    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.

DABroker for Java and Cosminexus versions:
  • Cosminexus DABroker 03-00-/D or earlier
  • Cosminexus DABroker for Java 02-06-/B or earlier
  • Cosminexus Studio Version 5 05-00-/D or earlier
  • Cosminexus Application Server Version 5 05-00-/D or earlier
  • Cosminexus Developer Version 5 05-00-/D or earlier

    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.