Overview of settings and operations

This subsection gives an overview for the following resource adapter settings:

Settings for connecting to the database
Settings for connecting to the database (in the case of cluster connection pool)
Settings for connecting to other resources (when the resource adapter is used)
Common settings for resource adapters

For details on the settings for connecting to a database queue, see the manual Cosminexus Reliable Messaging.

Organization of this subsection: (1) Settings for connecting to the database; (2) Settings for connecting to the database (in the case of cluster connection pool); (3) Settings for connecting to other resources (when the resource adapter is used); (4) Common settings for resource adapters

This operation is necessary when using the DB Connector for connecting to the database.

Table 4-1 Overview of settings required for connecting to the database

Settings	Contents	Reference
Importing the DB Connector	Import the RAR file of the DB Connector and add the file to the resources that can be used from the J2EE server.	Subsection 4.2.1
Defining the DB Connector properties	Set the following information for the database connection: General information about the DB Connector Configuration properties Runtime properties Optional name information	Subsection 4.2.2
Deploying the DB Connector	Deploy the DB Connector on the basis of the imported RAR file. When deployed, the DB Connector can be used as a J2EE resource adapter.	Subsection 4.2.3
Testing the connectivity of DB Connector	Verify that the contents set in the DB Connector are correct.	Subsection 4.2.4
Starting the DB Connector	Start the DB Connector.	Subsection 4.2.5
Stopping the DB Connector	Stop the DB Connector.	Subsection 4.2.6
Undeploying the DB Connector	Delete the deployed DB Connector. Execute this setting as required when switching resource adapters.	Subsection 4.2.7
Exporting the DB Connector	Export the J2EE resource adapter as a RAR file. Execute this setting when required.	Subsection 4.2.8

This operation is required for using the clustered connection pool of the DB Connector.

Table 4-2 Overview of settings required for connecting to the database (in the case of cluster connection pool)

Settings	Contents	Reference
Setting the DB Connector for a member resource adapter	Execute all the operations up to importing, setting and testing the connectivity of the DB Connector for the member resource adapter.	Subsection 4.3.2
Setting the DB Connector for a root resource adapter	Execute all the operations up to importing, setting and testing the connectivity of the DB Connector for the root resource adapter.	Subsection 4.3.3
Starting and stopping the DB Connector for a member resource adapter	Start the DB Connector for the member resource adapter. Also, stop the DB Connector for a running member resource adapter.	Subsection 4.3.4
Starting and stopping the DB Connector for a root resource adapter	Start the DB Connector for the root resource adapter. Also, stop the DB Connector for a running root resource adapter.	Subsection 4.3.5
Checking the state of the connection pool	Reference the member connection pool state.	Subsection 4.3.6
Suspending the connection pool	Suspend the member connection pool.	Subsection 4.3.7
Resuming the connection pool	Resume the member connection pool that was suspended.	Subsection 4.3.8

This operation is required when using a resource adapter to connect to various resources like OpenTP1.

Table 4-3 Overview of settings required for connecting to other resources (when the resource adapter is used)

Settings	Contents	Reference
Importing the resource adapter	Import the resource adapter (RAR file) and add the resource adapter to the resources that can be used from the J2EE server.	Subsection 4.4.1
Defining the resource adapter properties	Set the following information for connecting to the database: General information of the resource adapter Configuration properties Runtime properties Optional name information	Subsection 4.4.2 or Subsection 4.4.3
Deploying the resource adapter	Deploy the resource adapter on the basis of the imported resource adapter. When deployed, the resource adapter can be used as a J2EE resource adapter.	Subsection 4.4.4
Testing the connectivity of a J2EE resource adapter	Verify whether the contents set in the resource adapter are correct.	Subsection 4.4.5
Starting the J2EE resource adapter	Start the J2EE resource adapter.	Subsection 4.4.6
Stopping the J2EE resource adapter	Stop the J2EE resource adapter.	Subsection 4.4.7
Undeploying the J2EE resource adapter	Delete the J2EE resource adapter. Execute this setting as required when switching resource adapters.	Subsection 4.4.8
Exporting the J2EE resource adapter	Export the J2EE resource adapter as a RAR file. Execute this setting when required.	Subsection 4.4.9

(4) Common settings for resource adapters

Common settings refer to the settings that are common to the resource adapters.

Table 4-4 Overview of the common settings for resource adapters

Settings	Contents	Reference
Displaying the state and list of J2EE resource adapters	Reference the state of deployed J2EE resource adapters and the list of connection definition identifiers.	Section 4.5
Displaying the list of resource adapters	Reference the list of imported resource adapters and the list of connection definition identifiers.	Section 4.6
Checking the connection pool state	Reference the state of the resource adapter connection pool. Furthermore, delete the connections within the connection pool, as and when required.	Section 4.7
Referencing and changing the resource adapter names registered in the JNDI name space	Reference the resource adapter names registered in the JNDI name space and specify an optional name, as and when required.	Section 4.8
Delete the resource adapter	Delete the resource adapters.	Section 4.9
Copy the resource adapter	The resource adapters can be copied to other folders.	Section 4.10