20.1.3 Resource adapters used
This section describes the commands that can be executed with the root resource adapter and member resource adapter, gives an overview of the settings, and describes the notes.
- Organization of this subsection
(1) Executable commands
The following table describes the executability of commands for the root resource adapter and member resource adapter. Note that the commands other than those listed in the table can be executed with any resource adapter.
|
Command |
Types of resource adapters |
|
|---|---|---|
|
Root resource adapter |
Member resource adapter |
|
|
cjstartrar |
Y |
Y |
|
cjstoprar |
Y |
Y |
|
cjtestres |
Y |
Y |
|
cjlistrar |
Y |
Y |
|
cjclearpool |
N |
Y |
|
cjlistpool |
N |
Y |
|
cjsuspendpool |
N |
Y |
|
cjresumepool |
N |
Y |
- Legend:
-
Y: Can be executed
N: Cannot be executed
(2) DB Connector settings
The following table describes the items specified in DB Connector for the root resource adapter and member resource adapter.
|
Settings |
Types of resource adapters |
|
|---|---|---|
|
Root resource adapter |
Member resource adapter |
|
|
Transaction support level |
N |
Y#1 |
|
Can the log be collected |
Y |
Y |
|
Database connection information |
-- |
Y |
|
DB Connector-specific settings (such as the statement pool) |
-- |
Y |
|
Security information (user name and password) |
N |
Y#2 |
|
Connection pool size |
N |
Y |
|
Connection pool clustering-specific settings |
Y |
-- |
- Legend:
-
Y: Settings must be specified
N: Settings need not be specified
--: There are no settings
- #1
-
The transaction support levels of all the member resource adapters configuring one clustered connection pool must be the same.
- #2
-
The user names of all the member resource adapters configuring one clustered connection pool must be the same.
For details on the DB Connector settings, see 4.2 Settings for connecting to the database in the uCosminexus Application Server Application Setup Guide, or 20.6 HITACHI Connector Property file.
(3) Notes on the root resource adapters
-
You cannot execute the cjclearpool command. If the command is executed, a message is output and the command terminates abnormally. To clear the connections in a clustered connection pool with the cjclearpool command, execute the command for the member resource adapter.
-
You cannot execute the cjlistpool command. If the command is executed, a message is output and the command terminates abnormally. If you want to display the information of a connection pool within the clustered connection pool, execute the cjlistpool command by specifying the member resource adapter display name in -resname, or by specifying -resall.
-
You cannot mix and use a container-managed sign-on and component-managed sign-on in one clustered connection pool. When you use a component-managed sign-on, leave the user names of all the member resource adapters belonging to the root resource adapter blank.
-
You can start a root resource adapter when all the member resource adapters belonging to the root resource adapter are running. If you start the root resource adapter in the other cases, an error message is displayed on the console or on the screen, and the resource adapter fails to start.
(4) Notes on the member resource adapters
-
With the member resource adapters, the prerequisite functionalities are as follows. These functionalities are enabled by default and cannot be disabled.
-
Connection pooling
Specify a value greater than 0 as the maximum connection pool value. If 0 or less is specified, the operations are performed assuming that the default values are specified for the maximum and minimum connection pool values.
-
Detecting the connection errors when connections are obtained
Detecting the connection errors when connections are obtained and timeout for detecting the connection errors are enabled regardless of the set values.
-
Waiting for a connection when connections deplete
Waiting for a connection when connections deplete is enabled regardless of the set value.
-
loginTimeout
Specify a value greater than 0 in the loginTimeout property. If 0 or less is specified, the operations are performed assuming that the default value is specified.
-
-
The following functionalities cannot be used with the member resource adapters. These functionalities are disabled by default and cannot be enabled.
-
Retrying to obtain a connection
-
User-specified Namespace for the J2EE resources
-
-
All the connections in the member connection pool must be connected to the same database node; therefore, do not use the functionality to change the connection destination for a database. The examples of these functionalities are as follows. For the settings on disabling the functionality, see the Oracle documentation.
-
Client load balancing functionality
-
Connection failover functionality
-
Database service
-
Listener-based load balancing functionality
-
-
The member resource adapters are necessarily accessed via the root resource adapter. Therefore, you cannot specify the member resource adapters in the following locations:
-
Resource references of the J2EE applications
-
Mapping definitions of the CMP Entity Bean
-
-
You can stop a member resource adapter when the root resource adapter to which the member resource adapter belongs is stopped. If you stop a member resource adapter when the root resource adapter is running, an error message is displayed on the console or on the screen, and the resource adapter fails to stop.
-
When a member connection pool is blocked and suspended, to destroy the connections the unused connections are removed from the connection pool. At this time, if you restart the connection pool when the destruction of connections is not yet complete, the total number of connections in the connection pool and the unused connections removed from the connection pool might temporarily exceed the maximum number of connections in the connection pool.