20.3.2 Setting the DB Connector for a member resource adapter

(a) Execution format

cjimportres [server-name] [-nameserver provider-URL] -type rar -f file-path

Specify the RAR file in file-path.

The RAR file is stored in the following directory:

• In Windows

  Cosminexus-installation-directory\CC\DBConnector\ClusterPool\

• In UNIX

  /opt/Cosminexus/CC/DBConnector/ClusterPool/

The RAR files to be imported as member resource adapters are explained below:

DBConnector_Oracle_CP_ClusterPool_Member.rar

The DBConnector_Oracle_CP_ClusterPool_Member.rar is a member resource adapter of the cluster connection pool. Use this RAR file when you use a local transaction or when you do not use a transaction (when LocalTransaction or NoTransaction is specified in the transaction support level). Connect to Oracle by using ConnectionPoolDataSource of Oracle JDBC Thin Driver.

You cannot set this RAR file in the resource references of the J2EE applications.

(b) Example of execution

cjimportres MyServer -type rar -f "c:\Program Files\Hitachi\Cosminexus\CC\DBConnector\ClusterPool\DBConnector_Oracle_CP_ClusterPool_Member.rar"

For details on the cjimportres command, see cjimportres (import resource) in the uCosminexus Application Server Command Reference Guide.

(a) General information regarding the DB Connector for member resource adapters

The following table describes the settings for general information attributes (<outbound-resourceadapter> tag) of the DB Connector that can be set:

Items	Mandatory	Corresponding tags
Transaction support level#	Y	<transaction-support>
Scope of re-authentication support	Y	<reauthentication-support>

For details on the property settings, see 4.1.1 Specifications of the HITACHI Connector Property file in the uCosminexus Application Server Application and Resource Definition Reference Guide.

(b) Configuration properties for member resource adapters

The configuration properties (<config-property> tag) and settings of DB Connector for member resource adapters are the same as that of the corresponding resource adapter (DBConnector_Oracle_CP.rar). For details on the configuration properties of the corresponding resource adapter, see 4.2.2 Defining the DB Connector properties in the manual uCosminexus Application Server Application Setup Guide.

(c) Runtime properties

The following table describes the settings for runtime properties (<outbound-resourceadapter> - <connection-definition> - <connector-runtime> tag) of the DB Connector for the member resource adapter:

Items	Corresponding tags
Property name	<property-name>
Property data type	<property-type>
Property value	<property-value>

Repeat the above settings for all the properties that you want to define.

Setup the following items in the property name (<property-name>):

Property items	Settings of property name (<property-name>)
User name#	User
Password#	Password
Minimum number of connections to be pooled in the connection pool	MinPoolSize
Maximum number of connections to be pooled in the connection pool	MaxPoolSize
Choose whether to output the log	LogEnabled
Period from the last usage of connection until you determine whether to cancel the connection automatically (connection sweeper)	ConnectionTimeout
Interval for canceling the connection automatically (connection sweeper)	SweeperInterval
Maximum waiting time when the connection acquisition requests (when the connections are used up) are managed in a queue	RequestQueueTimeout
Choose whether to enable alert output for monitoring the connection pool	WatchEnabled
Interval for monitoring the connection pool	WatchInterval
Threshold value for monitoring the usage state of the connection pool	WatchThreshold
Choose whether to output the file with the connection pool monitoring results	WatchWriteFileEnabled
Interval for operating the connection count adjustment function	ConnectionPoolAdjustmentInterval
Choose whether to enable the warming up function of the connection pool	Warmup

Note:

The following items are always Enabled regardless of the scope of settings for the member resource adapters:

Property items	Valid values	Settings of property name (<property-name>)
Minimum number of connections to be pooled in connection pool	Connection pooling function is enabled. Default value 10 is assumed even if 0 is specified in MinPoolSize and MaxPoolSize.	MinPoolSize
Maximum number of connections to be pooled in connection pool		MaxPoolSize
Choose a method to check whether a failure has occurred in the connections inside the pool	Always 1 (Failure detected when the connection is acquired)	ValidationType
Choose whether to manage the connection acquisition requests in a queue when the connections are used up	Always true	RequestQueueEnable
Choose whether to enable the timeout of the network failure detection function	Always true	NetworkFailureTimeout

The retry function for acquiring connections is always disabled regardless of the settings for connection retry count (RetryCount) and connection retry waiting time (RetryInterval) of runtime properties.