This subsection describes the values that you can specify in the <config-property> tag set up for DB Connector.
Table 4-1 Properties that you can specify when using DBConnector_HiRDB_Type4_CP.rar, DBConnector_HiRDB_Type4_CP_Cosminexus_RM.rar, DBConnector_HiRDB_Type4_XA.rar, or DBConnector_HiRDB_Type4_XA_Cosminexus_RM.rar
config-property-name | config-property-type | config-property-value | Specifiable value | Default | Version |
---|---|---|---|---|---|
CallableStatementPoolSize | java.lang.Integer | Specifies the pool size of CallableStatement for each connection allocated to the connection pool. The valid range is from 0 to 4095. | Specify an integer value from 0 to 4095. | 10 | 07-00 |
CancelStatement | java.lang.Boolean | Specifies whether to cancel the SQL statement during a transaction timeout or an UAP forced termination.
| You can specify the following strings:
| true | 07-00 |
DBHostName | java.lang.String | Specifies the host name of HiRDB and XDM/RD E2 to be connected. The set value is passed to the setDBHostName method of the DataSource node interface of HiRDB Type4 JDBC Driver. | There are no limitations for the input value. | (Null character string) | 07-00 |
description | java.lang.String | Specifies the additional connection information required for connecting to the database. The set value is passed to the setDescription method of the DataSource node interface of HiRDB Type4 JDBC Driver. | There are no limitations for the input value. | (Null character string) | 07-00 |
encodeLang | java.lang.String | Specifies the character set name for data conversion. The set value is passed to the setEncodeLang method of the DataSource node interface of HiRDB Type4 JDBC Driver. | There are no limitations for the input value. | (Null character string) | 07-10 |
environmentVariables | java.lang.String | Specifies the HiRDB client environment variables. The set value is passed to the setEnvironmentVariables method of the DataSource node interface of HiRDB Type4 JDBC Driver. | There are no limitations for the input value. | (Null character string) | 07-10 |
HiRDBCursorMode | java.lang.Boolean | Specifies whether to enable the object of the ResultSet class when commit is executed in HiRDB. The set value is passed to the setHiRDBCursorMode method of the DataSource node interface of HiRDB Type4 JDBC Driver. | You can specify the following strings:
| false | 07-00 |
JDBC_IF_TRC | java.lang.Boolean | Specifies whether to collect the JDBC interface method trace. The set value is passed to the setJDBC_IF_TRC method of the DataSource node interface of HiRDB Type4 JDBC Driver. | You can specify the following strings:
| false | 07-00 |
loginTimeout | java.lang.Integer | Specifies the maximum standby period (unit: seconds) for an attempt to establish a physical connection with the HiRDB server when the Connection object is acquired with the getConnection method. The set value is passed to the setLoginTimeout method of the DataSource node interface of HiRDB Type4 JDBC Driver. | There are no limitations for the input value. | 8 | 07-00 |
logLevel | java.lang.String | Specifies the log trace level that DB Connector outputs.
| Specify any one of the following:
| ERROR | 07-00 |
LONGVARBINARY_Access | java.lang.String | Specifies how to access the JDBC SQL type LONGVARBINARY (serial property BLOB and serial property BINARY that are HiRDB data types) database. The set value is passed to the setLONGVARBINARY_Access method of the DataSource node interface of HiRDB Type4 JDBC Driver. | There are no limitations for the input value. | REAL | 07-00 |
LONGVARBINARY_AccessSize | java.lang.Integer | Specifies the length of the JDBC SQL type LONGVARBINARY data to be requested at one time for the HiRDB server. The set value is passed to the setLONGVARBINARY_AccessSize method of the DataSource node interface of HiRDB Type4 JDBC Driver. | There are no limitations for the input value. | 0 | 07-00 |
LONGVARBINARY_TruncError | java.lang.Boolean | Specifies that an exception is to be thrown when truncate occurs during the acquisition of the JDBC SQL type LONGVARBINARY data. The set value is passed to the setLONGVARBINARY_TruncError method of the DataSource node interface of HiRDB Type4 JDBC Driver. | You can specify the following strings:
| true | 07-10 |
maxBinarySize | java.lang.Integer | Specifies the upper limit for the data size when the JDBC SQL type LONGVARBINARY data is acquired. The set value is passed to the setMaxBinarySize method of the DataSource node interface of HiRDB Type4 JDBC Driver. | There are no limitations for the input value. | 0 | 07-10 |
PreparedStatementPoolSize | java.lang.Integer | Specifies the pool size of PreparedStatement for each connection allocated to the connection pool. The valid range is from 0 to 4095. | Specify an integer value from 0 to 4095. | 10 | 07-00 |
SQLInNum | java.lang.Integer | Specifies the maximum number of input ? parameters of the SQL statement to be executed. The set value is passed to the setSQLInNum method of the DataSource node interface of HiRDB Type4 JDBC Driver. | There are no limitations for the input value. | 300 | 07-10 |
SQLOutNum | java.lang.Integer | Specifies the maximum number of search items of the SQL statement to be executed. The set value is passed to the setSQLOutNum method of the DataSource node interface of HiRDB Type4 JDBC Driver. | There are no limitations for the input value. | 300 | 07-10 |
SQLWarningIgnore | java.lang.Boolean | Specifies whether to retain the warning returned from the database, in the Connection class. The set value is passed to the setSQLWarningIgnore method of the DataSource node interface of HiRDB Type4 JDBC Driver. | You can specify the following strings:
| false | 07-00 |
SQLWarningLevel | java.lang.String | Specifies the warning level that occurred during the execution of the SQL statement. The set value is passed to the setSQLWarningLevel method of the DataSource node interface of HiRDB Type4 JDBC Driver. | There are no limitations for the input value. | SQLWARN | 07-10 |
TRC_NO | java.lang.Integer | Specifies the entry count of the JDBC interface method trace. The set value is passed to the setTRC_NO method of the DataSource node interface of HiRDB Type4 JDBC Driver. | There are no limitations for the input value. | 500 | 07-00 |
uapName | java.lang.String | Specifies the application name. The set value is passed to the setUapName method of the DataSource node interface of HiRDB Type4 JDBC Driver. | There are no limitations for the input value. | (Null character string) | 07-10 |
Table 4-2 Properties that you can specify when using DBConnector_HiRDB_Type4_CP.rar or DBConnector_HiRDB_Type4_CP_Cosminexus_RM.rar
config-property-name | config-property-type | config-property-value |
---|---|---|
linkedResourceAdapterName | java.lang.String | Specifies the display name of the Cosminexus RM resource adapter to be integrated. You can specify this property when using DBConnector_HiRDB_Type4_CP_Cosminexus_RM.rar. |
Table 4-3 Properties that you can specify when using DBConnector_HiRDB_Type4_XA.rar or DBConnector_HiRDB_Type4_XA_Cosminexus_RM.rar
config-property-name | config-property-type | config-property-value |
---|---|---|
linkedResourceAdapterName | java.lang.String | Specifies the display name of the Cosminexus RM resource adapter to be integrated. You can specify this property when using DBConnector_HiRDB_Type4_XA_Cosminexus_RM.rar. |
XACloseString | java.lang.String | Specifies the XA close character string. The set value is passed to the setXACloseString method of the DataSource node interface of HiRDB Type4 JDBC Driver. |
XALocalCommitMode | java.lang.String | Specifies whether to enable the auto-commit functionality when the transaction is not a global transaction. The set value is passed to the setXALocalCommitMode method of the DataSource node interface of HiRDB Type4 JDBC Driver. Note that when you specify false, the resource connection test (cjtestres command) and the connection failure detection functionality does not operate normally. If you want to use the resource connection test (cjtestres command) and the connection failure detecting functionality, do not specify false. Do not specify false, when using DBConnector_HiRDB_Type4_XA_Cosminexus_RM.rar. |
XAOpenString | java.lang.String | Specifies the XA open character string. The set value is passed to the setXAOpenString method of the DataSource node interface of HiRDB Type4 JDBC Driver. |
For the values that you can specify in the properties, see the Oracle documentation.
Table 4-4 Properties that you can specify when using DBConnector_Oracle_CP.rar, DBConnector_Oracle_CP_Cosminexus_RM.rar, DBConnector_Oracle_XA.rar, or DBConnector_Oracle_XA_Cosminexus_RM.rar
config-property-name | config-property-type | config-property-value | Specifiable value | Default | Version |
---|---|---|---|---|---|
CallableStatementPoolSize | java.lang.Integer | Specifies the pool size of CallableStatement for each connection allocated to the connection pool. | Specify an integer value from 0 to 2147483647. | 10 | 07-00 |
CancelStatement | java.lang.Boolean | Specifies whether to cancel the SQL statement being executed in the Statement class, CallableStatement class, and PreparedStatement class, if the transaction times out or if the business application is terminated forcibly.
| You can specify the following strings:
| true | 07-00 |
ConnectionIDUpdate | java.lang.Boolean | Specifies whether to update the connection ID for each DataSource#getConnection method.
| You can specify the following strings:
| false | 07-00 |
databaseName | java.lang.String | Specifies a specific database name (SID) on the Oracle server. The set value is passed to the setDatabaseName method of the DataSource node interface of Oracle JDBC Thin Driver. | There are no limitations for the input value. | (Null character string) | 07-00 |
loginTimeout | java.lang.Integer | Specifies the timeout (unit: milliseconds) for attempting to connect to the database. If you specify 0, the timeout value becomes infinite and is blocked until a connection is established or an error occurs. The default value is 8000. The specified value is passed to the setLoginTimeout method of the DataSource node interface of Oracle JDBC Thin Driver. For Oracle JDBC Thin Driver 9.2.0.8 or later, 10.1.0.5 or later, and 10.2 or later, the value is rounded off to the seconds unit, and the value is passed to the setLoginTimeout method. | There are no limitations for the input value. | 8000 | 07-00 |
logLevel | java.lang.String | Specifies the log trace level that the DB Connector outputs. You can specify the following values:
| Specify any one of the following:
| ERROR | 07-00 |
portNumber | java.lang.Integer | Specifies the port number by which the Oracle server listens to the request. The set value is passed to the setPortNumber method of the DataSource node interface of Oracle JDBC Thin Driver. | There are no limitations for the input value. | 1521 | 07-00 |
PreparedStatementPoolSize | java.lang.Integer | Specifies the pool size of PreparedStatement for each connection allocated to the connection pool. | Specify an integer value from 0 to 2147483647. | 10 | 07-00 |
serverName | java.lang.String | Specifies the host name or the IP address of the Oracle server. The set value is passed to the setServerName method of the DataSource node interface of Oracle JDBC Thin Driver. | There are no limitations for the input value. | (Null character string) | 07-00 |
url | java.lang.String | Specifies the JDBC URL required by the Oracle JDBC Thin Driver to connect to the database. The values you specify are passed to the setURL method of the DataSource system interface of Oracle JDBC Thin Driver. When a value is set in this property, the value specified in databaseName, portNumber, and serverName is ignored. Specifies a thin driver in JDBC URL, when the user specifies a url. (Example) jdbc:oracle:thin:@ServerA:1521:service1 | There are no limitations for the input value. | (Null character string) | 07-00 |
Table 4-5 Properties that you can specify when using DBConnector_Oracle_CP.rar or DBConnector_Oracle_XA.rar
config-property-name | config-property-type | config-property-value | Specifiable value | Default | Version |
---|---|---|---|---|---|
appendZero | java.lang.Boolean | When you want to acquire the decimal point having an integer part as 0, from the NUMBER type or FLOAT type column, by using the getString method of the java.sql.ResultSet interface, specify whether to fill the integer part with 0.
| You can specify the following character strings:
| false | 09-50 |
forceFixedString | java.lang.Boolean | When you specify a value of the CHAR type (fixed length character string) column in the setString method or the setObject method of the java.sql.PreparedStatement interface and the specified value is smaller than the size of the column, specify whether to add blank characters to match the size to the size of the column.
| You can specify the following character strings:
| false | 09-50 |
Table 4-6 Properties that you can specify when using DBConnector_Oracle_CP_Cosminexus_RM.rar or DBConnector_Oracle_XA_Cosminexus_RM.rar
config-property-name | config-property-type | config-property-value |
---|---|---|
linkedResourceAdapterName | java.lang.String | Specify the display name for the Reliable Messaging resource adapter to be integrated. You can specify this value only when using DBConnector_Oracle_CP_Cosminexus_RM.rar. |
Table 4-7 Properties that you can specify when using DBConnector_Oracle_XA.rar or DBConnector_Oracle_XA_Cosminexus_RM.rar
config-property-name | config-property-type | config-property-value |
---|---|---|
sessionTimeout | java.lang.Integer | Specifies the session timeout (maximum time period in which the transaction branch is not active) in Oracle server in seconds. You must specify a time period longer than the transaction timeout in the J2EE server. The default value is 300 seconds. The set value is passed to the XAResource.setTransactionTimeout method of Oracle JDBC Thin Driver. |
Table 4-8 Properties that you can specify when using DBConnector_SQLServer2005_CP.rar
config-property-name | config-property-type | config-property-value | Specifiable value | Default | Version |
---|---|---|---|---|---|
applicationIntent | java.lang.String | When you use the SQL Server 2012 availability group or the SQL Server 2012 failover cluster functionality, specify the connection to a failover destination database as read-only or read and write only. The value you specify is passed to the setApplicationIntent method of the DataSource system interface of JDBC Driver 4.0 for SQL Server. For details, see the manual of JDBC Driver 4.0 for SQL Server. You can specify this value only when using JDBC Driver 4.0 for SQL Server. | Specify any of the following:
| ReadWrite | 09-50 |
applicationName | java.lang.String | Specifies the name of the application connecting to SQL Server. The set value is displayed on the management tool of SQL Server. The set value is passed to the setApplicationName method of the DataSource node interface of SQL Server JDBC Driver. | There are no limitations for the input value. | (Null character string) | 07-50 |
CallableStatementPoolSize | java.lang.Integer | Specifies the pool size of CallableStatement for each connection allocated to the connection pool. | Specify an integer value from 0 to 2147483647. | 10 | 07-00 |
CancelStatement | java.lang.Boolean | Specifies whether to execute the cancel statement functionality, in the case of a transaction timeout or a forced termination of an application.
| You can specify the following strings:
| true | 07-00 |
databaseName | java.lang.String | Specifies the database name of SQL Server to be connected. If no value is specified, the connection is established with a defined database. The set value is passed to the setDatabaseName method of the DataSource node interface of SQL Server JDBC Driver. | There are no limitations for the input value. | (Null character string) | 07-00 |
failoverPartner | java.lang.String | Specifies the name of the failover server used in a database mirroring configuration. Use this property in combination with the databaseName property. The set value is passed to the setFailoverPartner method of the DataSource node interface of SQL Server JDBC Driver. For details, see the SQL Server JDBC Driver documentation. | There are no limitations for the input value. | (Null character string) | 07-50 |
instanceName | java.lang.String | Specifies the instance name of SQL Server to be connected to. If no value is specified, the connection is established with an existing instance. The set value is passed to the setInstanceName method of the DataSource node interface of SQL Server JDBC Driver. | There are no limitations for the input value. | (Null character string) | 07-50 |
integratedSecurity | java.lang.Boolean | Specifies how to perform authentication for connecting to SQL Server.
| You can specify the following strings:
| false | 07-50 |
lastUpdateCount | java.lang.Boolean | Specifies whether to return only the last update count from the SQL statements passed to the server.
| You can specify the following strings:
| true | 07-50 |
lockTimeout | java.lang.Integer | Specifies the standby time (unit: milli-seconds) until the database reports the lock timeout. If you specify -1, the timeout becomes infinite. If you specify 0, the system does not standby. The set value is passed to the setLockTimeout method of the DataSource node interface of SQL Server JDBC Driver. | There are no limitations for the input value. | -1 | 07-50 |
loginTimeout | java.lang.Integer | Specifies the maximum standby period (unit: seconds) of the data source when trying to connect to the database. The set value is passed to the setLoginTimeout method of DataSource node interface of SQL Server JDBC Driver. | There are no limitations for the input value. | 8 | 07-00 |
logLevel | java.lang.String | Specifies the log trace level output by the DB Connector. You can specify the following values:
| Specify any one of the following:
| ERROR | 07-00 |
multiSubnetFailover | java.lang.Boolean | When you use the SQL Server 2012 availability group or the SQL Server 2012 failover cluster functionality, specify true. The value you specify is passed to the setApplicationIntent method of the DataSource system interface of JDBC Driver 4.0 for SQL Server. For details, see the manual of JDBC Driver 4.0 for SQL Server. You can specify this value only when using JDBC Driver 4.0 for SQL Server | The specifiable character strings are as follows:
| false | 09-50 |
packetSize | java.lang.Integer | Specifies the network packet size (unit: bytes) used for communication with SQL Server. The set value is passed to the setPacketSize method of the DataSource node interface of SQL Server JDBC Driver. For details, see the SQL Server JDBC Driver documentation. | There are no limitations for the input value. | 4096 | 07-50 |
portNumber | java.lang.Integer | Specifies the port number of SQL Server to be connected to. The set value is passed to the setPortNumber method of the DataSource node interface of SQL Server JDBC Driver. | There are no limitations for the input value. | 1433 | 07-00 |
PreparedStatementPoolSize | java.lang.Integer | Specifies the pool size of PreparedStatement for each connection allocated to the connection pool. | Specify an integer value from 0 to 2147483647. | 10 | 07-00 |
selectMethod | java.lang.String | Specifies whether to use the database cursor when executing the select statement. Set the value in lower case.
| You can specify the following strings:
| cursor | 07-00 |
sendStringParametersAsUnicode | java.lang.Boolean | Specifies whether to send the character string parameter to be sent to SQL Server as Unicode or as the default character encoding of the database.
| You can specify the following strings:
| true | 07-00 |
serverName | java.lang.String | Specifies the host name or the IP address of SQL Server to be connected to. The set value is passed to the setServername method of the DataSource node interface of SQL Server JDBC Driver. | There are no limitations for the input value. | (Null character string) | 07-00 |
workstationID | java.lang.String | Specifies the host name of Application Server. The set value is displayed on the management tool of SQL Server. The set value is passed to the setWorkstationID method of DataSource node interface of SQL Server JDBC Driver. | There are no limitations for the input value. | (Null character string) | 07-50 |
xopenStates | java.lang.Boolean | Specifies the SQL standards for the return value of the java.sql.SQLException.getSQLState method.
| You can specify the following strings:
| false | 07-50 |
Table 4-9 Properties that you can specify when using DBConnector_CP_ClusterPool_Root.rar
config-property-name | config-property-type | config-property-value |
---|---|---|
algorithm | java.lang.String | Specifies how to select the connection pool of the cluster connection pool functionality.
|
dbCheckInterval | java.lang.Integer | Specifies an integer value from 2 to 2147483647 (unit: seconds) for the interval to check the DB node status in the suspended connection pool. If you specify a value outside the valid range, the default value is assumed. The default value is 30. When the Oracle JDBC Thin Driver is used in the member resource adapter, specify a time period longer than the loginTimeout property value of each member resource adapter. |
enableAutoPoolResume | java.lang.Boolean | Specifies whether to enable or disable the auto-resume functionality of the connection pool.
|
enableAutoPoolSuspend | java.lang.Boolean | Specifies whether to enable or disable the auto-suspend functionality of the connection pool.
|
logLevel | java.lang.String | Specifies the log trace level output by the DB Connector. You can specify the following values:
|
memberResourceAdapterName[n] | java.lang.String | Specifies the display name of the member resource adapter of priority n. This property is not defined by default, so add this property as and when required. For n, specify the value from 1 to 100. |
memberResourceAdapterName1 | java.lang.String | Specifies the display name of the member resource adapter of priority 1. Smaller the specified value, higher the priority order. |
memberResourceAdapterName2 | java.lang.String | Specifies the display name of the member resource adapter of priority 2. |
Table 4-10 Properties that you can specify when using DBConnector_Oracle_CP_ClusterPool_Member.rar
config-property-name | config-property-type | config-property-value |
---|---|---|
CallableStatementPoolSize | java.lang.Integer | Specifies the pool size of CallableStatement for each connection allocated to the connection pool. The default value is 10. |
CancelStatement | java.lang.Boolean | Specifies whether to cancel the SQL statement being executed in the Statement class, CallableStatement class, and PreparedStatement class, in the case of a transaction timeout or a forced termination of an application.
Specify false when connecting to an exclusive server. |
ConnectionIDUpdate | java.lang.Boolean | Specifies whether to update the connection ID for each DataSource#getConnection method.
|
databaseName | java.lang.String | Specifies a specific database name (SID) on the Oracle server. The set value is passed to the setDatabaseName method of the DataSource node interface of Oracle JDBC Thin Driver. |
loginTimeout | java.lang.Integer | Specifies an integer value (unit: milli-seconds) from 1 to 2147483647 when trying to connect to the database. If you specify a value outside the valid range, the default value is assumed. The default value is 8000. The set value is passed to the setLoginTimeout method of the DataSource node interface of Oracle JDBC Thin Driver. For Oracle JDBC Thin Driver 10.1.0.5 or later and 10.2 or later, the value is rounded off to the seconds unit, and the value is passed to the setLoginTimeout method. |
logLevel | java.lang.String | Specifies the log trace level output by the DB Connector. You can specify the following values:
|
portNumber | java.lang.Integer | Specifies the port number by which the Oracle server listens to the request. The default port number is 1521. The set value is passed to the setPortNumber method of the DataSource node interface of Oracle JDBC Thin Driver. |
PreparedStatementPoolSize | java.lang.Integer | Specifies the pool size of PreparedStatement for each connection allocated to the connection pool. The default value is 10. |
serverName | java.lang.String | Specifies the host name or IP address of the Oracle server. The set value is passed to the setServerName method of the DataSource node interface of Oracle JDBC Thin Driver. |
url | java.lang.String | Specifies the JDBC URL required by the Oracle JDBC Thin Driver to connect to the database. The value you specify is passed to the setURL method of Oracle JDBC Thin Driver. When a value is set in this property, the value specified in databaseName, portNumber, and serverName is ignored. Specifies a thin driver in JDBC URL, when the user specifies a url. (Example) jdbc:oracle:thin:@ServerA:1521:service1 |