4.2 Settings for connecting to the database
To connect to the database, you set up the DB Connector that is a resource adapter for connecting to the database.
The connection to the database with a DB Connector refers to the process of accessing only the database table using the JDBC interface.
To access a queue by using the JMS interface, use the DB Connector for Cosminexus RM and Cosminexus RM to connect to the database. For details, see the manual Cosminexus Reliable Messaging.
To set up the DB Connector, first set up the environment for the database to be used. Also, you must set up HiRDB Type4 JDBC Driver, Oracle JDBC Thin Driver, or SQL Server JDBC Driver depending on the types of DB Connector to be used.
Set up the DB Connector with the following procedure:
-
Import the DB Connector.
-
Define the properties.
-
Deploy the DB Connector.
Deploying refers to the process of deploying the DB connector as a shared and standalone module (J2EE resource adapter) on the J2EE server.
-
Check the connectivity.
You can confirm if the connection is correct with the help of a connectivity test.
For the deployed DB Connector, you need to resolve the resource adapter references by using the J2EE application property settings. For details, see 9.3.3 Defining resource adapter references.
- Reference note
-
To set up new DB Connector properties, you can use the template file provided in Cosminexus Component Container.
The template file of the HITACHI Connector Property file is stored in the following directory:
-
In Windows:
Cosminexus-installation-directory\CC\admin\templates\
-
In UNIX:
/opt/Cosminexus/CC/admin/templates/
You can use this template file to edit the HITACHI Connector Property file before importing the DB Connector. Copy and use the template file.
For details on the template file names of the HITACHI Connector Property file, see 4.1.13 Template files of the HITACHI Connector Property File in the uCosminexus Application Server Application and Resource Definition Reference Guide.
You do not use the template file when you change the properties of DB Connector for which properties are already specified. You obtain the Connector properties of an imported DB Connector, and then edit the HITACHI Connector Property file.
-
- Organization of this section