Nonstop Database, HiRDB Version 9 UAP Development Guide

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

18.7 Connection information setup and acquisition interface

The DataSource, ConnectionPoolDataSource, and XADataSource classes provided by the JDBC2.0 Optional Package provide methods for setting and getting connection information necessary for connection to the database, in addition to the methods prescribed by the JDBC2.0 Optional Package specifications.

The following table lists the methods for setting and getting connection information.

Table 18-64 Methods for setting and getting connection information

Method Function
setDescription Sets the additional connection information needed for connection to the database.
getDescription Gets the additional connection information needed for connection to the database.
setDBHostName Sets the host name of the HiRDB to be connected.
getDBHostName Gets the host name of the HiRDB to be connected.
setJDBC_IF_TRC Sets whether or not a JDBC interface method trace is to be acquired.
getJDBC_IF_TRC Gets the setting information about whether or not a JDBC interface method trace is to be acquired.
setTRC_NO Sets the number of entries in the JDBC interface method trace.
getTRC_NO Gets the number of entries in the JDBC interface method trace.
setUapName Sets a UAP name.
getUapName Gets the UAP name.
setUser Sets an authorization identifier for database connection.
getUser Gets the authorization identifier for database connection.
setPassword Sets a password for database connection.
getPassword Gets the password for database connection.
setXAOpenString Sets an XA open character string.
getXAOpenString Gets the XA open character string.
setXACloseString Sets an XA close character string.
getXACloseString Gets the XA close character string.
setLONGVARBINARY_Access Sets the method of accessing data of the LONGVARBINARY type (a JDBC SQL type corresponding to HiRDB's BLOB and BINARY data types).
getLONGVARBINARY_Access Gets the method of accessing data of the LONGVARBINARY type (a JDBC SQL type corresponding to HiRDB's BLOB and BINARY data types).
setSQLInNum Sets the maximum number of input ? parameters in the SQL statements to be executed.
getSQLInNum Gets the maximum number of input ? parameters in the SQL statements to be executed.
setSQLOutNum Sets the maximum number of retrieval items for the SQL statements to be executed.
getSQLOutNum Gets the maximum number of retrieval items for the SQL statements to be executed.
setSQLWarningLevel Sets the warning retention level for warnings that occur during SQL execution.
getSQLWarningLevel Gets the warning retention level for warnings that occur during SQL execution.
setXALocalCommitMode Sets whether or not the auto-commit facility is to be enabled if a transaction during an XA connection is not a distributed transaction.
getXALocalCommitMode Gets the setting information about whether or not the auto-commit facility is to be enabled if a transaction during an XA connection is not a distributed transaction.
setSQLWarningIgnore Sets whether or not warnings returned from the database are to be discarded by the Connection class.
getSQLWarningIgnore Gets the setting information about whether or not warnings returned from the database are to be discarded by the Connection class.
setHiRDBCursorMode Sets whether or not objects of the ResultSet class are to be validated when HiRDB executes commit processing.
getHiRDBCursorMode Gets the setting information about whether or not objects of the ResultSet class are to be validated when HiRDB executes commit processing.
setNotErrorOccurred Sets whether or not the calling of ConnectionEventListener.connectionErrorOccurred is to be suppressed.
getNotErrorOccurred Gets the setting information about whether or not the calling of ConnectionEventListener.connectionErrorOccurred has been suppressed.
setEnvironmentVariables Sets client environment definitions for HiRDB.
getEnvironmentVariables Gets the client environment definitions for HiRDB that were set.
setEncodeLang Sets the name of the conversion character set for data conversion.
getEncodeLang Gets the name of the conversion character set for data conversion that was set.
setMaxBinarySize Sets the maximum data size for retrieval of data of the LONGVARBINARY type (a JDBC SQL type).
getMaxBinarySize Gets the maximum data size for retrieval of data of the LONGVARBINARY type (a JDBC SQL type).
setStatementCommitBehavior Sets whether or not statement objects are to remain valid after a transaction is committed.
getStatementCommitBehavior Gets the setting information about whether or not statement objects are to remain valid after a transaction is committed.
setLONGVARBINARY_AccessSize Sets the LONGVARBINARY (a JDBC SQL type) data length for one access request to the HiRDB server.
getLONGVARBINARY_AccessSize Gets the LONGVARBINARY (a JDBC SQL type) data length for one access request to the HiRDB server.
setLONGVARBINARY_TruncError Sets whether or not an exception is to be thrown if truncation occurs during acquisition of data of the LONGVARBINARY type (a JDBC SQL type).
getLONGVARBINARY_TruncError Gets the setting information about whether or not an exception is to be thrown if truncation occurs during acquisition of data of the LONGVARBINARY type (a JDBC SQL type).
setStatementCloseBehavior Sets whether preprocessing results are to be ignored during execution of the close method of Statement (Statement, PreparedStatement, and CallableStatement classes).
getStatementCloseBehavior Gets the setting information about whether preprocessing results are ignored during execution of the close method of Statement (Statement, PreparedStatement, and CallableStatement classes).
setHiRDBINI Sets a directory for the HiRDB.INI file.
getHiRDBINI Gets the directory for the HiRDB.INI file.
setBatchExceptionBehavior Sets whether a JDBC standard-compliant update count is to be set as the return value of the getUpdateCounts method of java.sql.BatchUpdateException.
getBatchExceptionBehavior Gets the setting information about whether a JDBC standard-compliant update count is set as the return value of the getUpdateCounts method of java.sql.BatchUpdateException.
Organization of this section
18.7.1 setDescription
18.7.2 getDescription
18.7.3 setDBHostName
18.7.4 getDBHostName
18.7.5 setJDBC_IF_TRC
18.7.6 getJDBC_IF_TRC
18.7.7 setTRC_NO
18.7.8 getTRC_NO
18.7.9 setUapName
18.7.10 getUapName
18.7.11 setUser
18.7.12 getUser
18.7.13 setPassword
18.7.14 getPassword
18.7.15 setXAOpenString
18.7.16 getXAOpenString
18.7.17 setXACloseString
18.7.18 getXACloseString
18.7.19 setLONGVARBINARY_Access
18.7.20 getLONGVARBINARY_Access
18.7.21 setSQLInNum
18.7.22 getSQLInNum
18.7.23 setSQLOutNum
18.7.24 getSQLOutNum
18.7.25 setSQLWarningLevel
18.7.26 getSQLWarningLevel
18.7.27 setXALocalCommitMode
18.7.28 getXALocalCommitMode
18.7.29 setSQLWarningIgnore
18.7.30 getSQLWarningIgnore
18.7.31 setHiRDBCursorMode
18.7.32 getHiRDBCursorMode
18.7.33 setNotErrorOccurred
18.7.34 getNotErrorOccurred
18.7.35 setEnvironmentVariables
18.7.36 getEnvironmentVariables
18.7.37 setEncodeLang
18.7.38 getEncodeLang
18.7.39 setMaxBinarySize
18.7.40 getMaxBinarySize
18.7.41 setStatementCommitBehavior
18.7.42 getStatementCommitBehavior
18.7.43 setLONGVARBINARY_AccessSize
18.7.44 getLONGVARBINARY_AccessSize
18.7.45 setLONGVARBINARY_TruncError
18.7.46 getLONGVARBINARY_TruncError
18.7.47 setStatementCloseBehavior
18.7.48 getStatementCloseBehavior
18.7.49 setHiRDBINI
18.7.50 getHiRDBINI
18.7.51 setBatchExceptionBehavior
18.7.52 getBatchExceptionBehavior