Configuration Guide › Relational Database Management › How To Create a JDBC Data Source › Create a JDBC Data Source for JBoss Application Servers

Create a JDBC Data Source for JBoss Application Servers

To create a JDBC datasource for JBoss

1. Create a copy of the following file:

   jboss_home\server\default\deploy\objectstore-ds.xml

   jboss home

   The installed location of the Jboss application server where CA Identity Manager is installed

   The new file should exist in the same location.

2. Rename the file to userstore-ds.xml.
3. Edit userstore-ds.xml as follows:
   1. Locate the <jndi-name> element.
   2. Change the value of the <jndi-name> element from jdbc/objectstore to userstore as follows:

      <jndi-name>userstore</jndi-name>

   3. In the <connection-url> element, change the DatabaseName parameter to the name of the database that serves as the user store as follows:

      <connection-url>

      jdbc:sqlserver://ipaddress:port;selectMethod=cursor;DatabaseName=userstore_name

      </connection-url>

      ipaddress

      Specifies the IP address of the machine where the user store is installed

      port

      Specifies the port number for the database

      userstore_name

      Specifies the name of the database that serves as the user store

4. Perform the following steps if you plan to create a JBoss security realm, which is required for support FIPS:
   1. Rename the security-domain to <security-domain>imuserstoredb</security-domain>.
   2. Save the file.
   3. Omit the remaining steps. Instead, complete the steps in Create a JBoss Security Realm for the JDBC Data Source.
5. Make the following additional changes to userstore-ds.xml:
   1. Change the value of the <user-name> element to the username for an account that has read and write access to the user store.
   2. Change the value of the <password> element to the password for the account specified in the <user-name> element.

   Note: The user-name and password appear in clear text in this file. Therefore, you may decide to create a JBoss Security realm instead of editing userstore-ds.xml.

6. Save the file.