20.6.1 Properties that you can specify in the <config-property> tag set up for DB Connector
This section describes the values that you can specify in the <config-property> tag which is to be set for the following DB Connectors:
- Organization of this subsection
-
(1) When connecting to Oracle by using cluster connection pool (root resource adapter)
-
DBConnector_CP_ClusterPool_Root.rar
Use the above when the transaction is not managed or when a local transaction is used.
For details on the properties that you can specify, see the following table.
Table 20‒11: 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 connection pool clustering functionality.
-
RoundRobin
An attempt is made to acquire the connections as per the priority order from the connection pool that is next in the priority
list below the last chosen connection pool. When the connection pool with the lowest priority is reached, the connection pool
with the highest priority is chosen. An exception is thrown when you cannot acquire a connection from the entire connection
pool.
Specified when the cluster database is active/active configuration and aims at load distribution in each instance.
The default value is RoundRobin.
|
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.
The default value is true.
|
enableAutoPoolSuspend
|
java.lang.Boolean
|
Specifies whether to enable or disable the auto-suspend functionality of the connection pool.
The default value is true.
|
logLevel
|
java.lang.String
|
Specifies the log trace level output by the DB Connector.
You can specify the following values:
-
0 or ERROR
-
10 or WARNING
-
20 or INFORMATION
The default value is 0 or ERROR.
|
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.
|
To Page Top
(2) When connecting to Oracle by using the cluster connection pool (member resource adapter)
-
DBConnector_Oracle_CP_ClusterPool_Member.rar
Use the above when the transaction is not managed or when a local transaction is used.
For details on the properties that you can specify, see the following table.
Table 20‒12: Properties that you can specify when using DBConnector_Oracle_CP_ClusterPool_Member.rar
config-property-name
|
config-property-type
|
config-property-value
|
CallableStatementPoolSize
uCosminexus Application Server Common Container Functionality Guide
|
java.lang.Integer
|
Specifies the pool size of CallableStatement for each connection allocated to the connection pool. The default value is 10.
When 0 is specified, statements are not pooled.
|
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.
The default value is true.
Specify false when connecting to an exclusive server.
|
ConnectionIDUpdate
|
java.lang.Boolean
|
Specifies whether to update the connection ID for each DataSource#getConnection method.
The default value is false.
|
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: milliseconds) 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 specified value is rounded up in increments of 1 second, and is passed to the setLoginTimeout method of the DataSource system interface of Oracle JDBC Thin Driver.
|
logLevel
|
java.lang.String
|
Specifies the log trace level output by the DB Connector.
You can specify the following values:
-
0 or ERROR
-
10 or WARNING
-
20 or INFORMATION
The default value is 0 or ERROR.
|
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
uCosminexus Application Server Common Container Functionality Guide
|
java.lang.Integer
|
Specifies the pool size of PreparedStatement for each connection allocated to the connection pool. The default value is 10.
When 0 is specified, statements are not pooled.
|
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
|
To Page Top