20.6.1 Properties that you can specify in the <config-property> tag set up for DB Connector

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.

• If you specify true

  The auto-resume functionality of the connection pool is enabled.

• If you specify false

  The auto-resume functionality of the connection pool is disabled.

The default value is true.

enableAutoPoolSuspend

java.lang.Boolean

Specifies whether to enable or disable the auto-suspend functionality of the connection pool.

• If you specify true

  The auto-suspend functionality of the connection pool is enabled.

• If you specify false

  The auto-suspend functionality of the connection pool is disabled.

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.

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.

• If you specify true

  The SQL statement being executed is cancelled.

• If you specify false

  The SQL statement being executed is not cancelled.

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.

• If you specify true

  The connection ID is generated for each DataSource#getConnection method.

• If you specify false

  The connection ID is generated for the first DataSource#getConnection method and is not updated thereafter.

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