Configure and get a data source working on JBoss Application Server with Sterling Multi-Channel Fulfillment (MCF) Application

Answer

To configure a data source on JBoss Application Server:

In versions lower than MCF 8.0

1. Copy <JBOSS_HOME>/docs/examples/jca/oracle-ds.xml to <JBOSS_HOME>/server/<server_name directory>/deploy folder.

2. Customize the oracle-ds.xml -
a. JNDI name defaults to OracleDS. (There is no need to change the JNDI name)
b. Update the “connection-url”, “user-name” and “password” tags with appropriate values.
c. Add new tags for providing pool size.
i. <min-pool-size>5</min-pool-size>
ii. <max-pool-size>100</max-pool-size>
d. Add a tag to provide timeout on idle as <idle-timeout-minutes>5</idle-timeout-minutes>

3. Restart the Application Server.

1. In the <INSTALL_DIR>/properties/customer_overrides.properties, add the following properties:
a. jdbcService.oraclePool.datasource=java:OracleDS (should be java:/OracleDS in v8.5)
b. jdbcService.oraclePool_NoTrans.datasource=java:OracleDS (should be java:/OracleDS in v8.5)
Where “java:OracleDS” is the name of the data source created on the JBoss side.

2. In the JBoss startup script (run.sh), add -Dsci.dblogin.datasource.name=java:OracleDS and -Dvendor=jboss to JAVA_OPTS.

A. Update jdbc.properties with invalid username/password in all occurrences.
B. Start the application server (The logs will show that the connection pool “OracleDS” is in use).
C. If the application server starts properly without errors, then the connection pool is working.