This article outlines the configuration steps needed to define an IDMS JDBC Data Source under JBoss Application Server version 7.1.
This document describes how to define both an XA and a non-XA type IDMS Data Source for use with JBoss/AS 7.1, in a JBoss 'Standalone Server' type configuration. Rather than using the JBoss Administration Console (which can be somewhat clumsy and temperamental), we will be modifying the JBoss configuration XML files directly. Once defined, you can modify your IDMS Data Source definitions using the Admin Console if you'd like.
The following steps should be followed:
- Copy file 'jbossidms.zip' (attached to this Knowledge Document) to location: "<JBOSS_ROOT>/modules/com".
- Extract all files within the zip file into the current directory. Make sure to use the "Use folder names" option when the extract is performed.
- Copy your current 'idmsjdbc.jar file (usually found within directory " C:\Program Files\CA\CA IDMS Server\Java\lib") into directory "<JBOSS_ROOT>/modules/com/ca/idms/main".
- Take a backup of the JBoss 'standalone.xml' file, in the event you need to reverse the changes were about to make. You can find the 'standalone.xml' file under directory: "<JBOSS_ROOT>/standalone/configuration"
- Open the JBoss 'standalone.xml' file with Notepad, WordPad or any text file editor of your choice.
- Open file: 'Template updates to standalone xml for IDMS.txt'. You will find this file within directory "<JBOSS_ROOT>/modules/com/ca/idms/main".
- Customize file 'Template updates to standalone xml for IDMS.txt' to meet your site requirements. This file contains several strings that will need to be modified, as follows… Note that many of these strings occur in multiple locations:
- MyIdmsDs - Replace with your non-XA IDMS Data Source name
- MyIdmsHostName - Replace with the TCP/IP Host Name where your IDMS CV is running
- MyIdmsPortNbr - Replace with the TCP/IP Port Number referenced in your TCPJSRV bulk Listener PTE within your IDMS CV.
- MyIdmsDBName - Replace with the DBNAME you wish to target within your IDMS CV.
- MyIdmsUid - Replace with the User-id authorized to access your IDMS CV.
- MyIdmsPwd - Replace with the Password for the UID named above.
- MyIdmsXaDs - Replace with your XA IDMS Data Source name.
- Copy the 2 IDMS Data Source definitions within file 'Template updates to standalone xml for IDMS.txt' into your windows cut/paste buffer. This text block starts with string
"<datasource jta=…" and ends with string "</xa-datasource>".
- Paste your cut/paste buffer into the appropriate location within your JBoss 'standalone.xml' file (opened in step 2). This paste must be done within the "<datasources>" XML tags.
- Copy the IDMS 'Driver' definition within file 'Template updates to standalone xml for IDMS.txt' into your windows cut/paste buffer. This text block starts with string
"<driver name="IDMS"" and ends with string "</driver>".
- Paste your cut/paste buffer into the appropriate location within your JBoss 'standalone.xml' file (opened in step 2). This paste must be done within the "<drivers>" XML tags.
- Save your updates to the 'standalone.xml' file.
- Cycle JBoss/AS (that is, stop and restart the JBoss Application Server).
Your new IDMS Data Sources should now be ready for use. To test your IDMS connectivity you can use the JBoss Administration Console. Note that by default, the JBoss Admin Console can be accessed via a browser at url: http://localhost:9990/console/App.html#server-overview. Use the following procedure toperform the test:
- Click on the "Profile" action on the top-right portion of the page.
- On the middle-top portion of the page select either "Datasources" or "XA Datasources".
- Under the "Available (XA) Datasources" label, click the newly created IDMS Data Source to make it 'current'.
- Under the "Selection" label (in the middle of the page) you will see the following items:
- Attributes Connection Security Properties Pool Validation
- Select the "Connection" item.
- Select the "Test Connection" button.
For more information on the use of the CA IDMS Server JDBC Driver see the "JDBC Programmer Reference" section within the CA IDMS Server User Guide (provided with the product install).