Nonstop Database, HiRDB Version 9 UAP Development Guide
This section discusses migration to a Type4 JDBC driver of Java stored procedures that have been used with a Type2 JDBC driver.
If you use any of the platforms listed below, you can migrate Java stored procedures from a Type2 JDBC driver to a Type4 JDBC driver without having to change the programs:
If you use any other platform, you must change the settings as shown below when you migrate the internal driver from Type2 JDBC to Type4 JDBC.
Item requiring change | Type2 JDBC driver | Type4 JDBC driver |
---|---|---|
Driver name | "JP.co.Hitachi.soft.HiRDB.JDBC.PrdbDriver" | "JP.co.Hitachi.soft.HiRDB.JDBC.HiRDBDriver" |
Protocol name, subprotocol name, and subname specified in the URL when connection is established with HiRDB | jdbc:hitachi:PrdbDrive | jdbc:hitachi:hirdb |
Class name of DataSource class | JdbhDataSource | PrdbDataSource |
Cursor operation mode# | Specify by using one of the following methods:
|
Specify by using one of the following methods:
|
HiRDB's array update, array insertion, and array deletion facilities | Supported if this function is set to be used by one of the following methods:
|
Supported unconditionally. However, the setBlockUpdate method of the JdbcDbpsvPreparedStatement class is not supported. |
Maximum number of input or input-output ? parameters in the SQL statements to be executed | Specify by using one of the following methods:
|
Specify by using one of the following methods:
|
Maximum number of output items for the SQL statement to be executed | Specify by using one of the following methods:
|
Specify by using one of the following methods:
|
ResultSet object status after commit execution | Statement object status after commit execution | Type2 JDBC driver | Type4 JDBC driver |
---|---|---|---|
Invalid | Invalid | COMMIT_BEHAVIOR= "DELETE" (default value) | HIRDB_CURSOR=FALSE (default value) STATEMENT_COMMIT_BEHAVIOR=FALSE |
Valid | COMMIT_BEHAVIOR= "CLOSE" | HIRDB_CURSOR=FALSE (default value) STATEMENT_COMMIT_BEHAVIOR=TRUE (default value) |
|
Valid | Valid | COMMIT_BEHAVIOR= "PRESERVE" | HIRDB_CURSOR=TRUE STATEMENT_COMMIT_BEHAVIOR=TRUE or STATEMENT_COMMIT_BEHAVIOR=FALSE |
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.