Installation guide

For both SQL Server 2005 and 2008, use the appropriate driver for your JVM

– For Java 5: sqljdbc.jar

– For Java 6: sqljdbc4.jar

Oracle

Use the drivers provided by your application server or download the latest

drivers from the Oracle website. The appropriate file depends on the version

of your JVM:

– For Java 5: ojdbc5.jar

– For Java 6: ojdbc6.jar

If you are using the OCI (thick) driver, this directory must also contain the

Oracle Client software.

Note: Pegasystems recommends use of the Thin Client driver.

UDB

Follow the IBM instructions for installing the client software and the JDBC

drivers to make the db2jcc.jar available.

This JDBC driver is the Type 4 universal driver.

Create a DataSource configuration file

Create a DataSource for the new server. DataSource configuration file names end with the suffix

-ds.xml so that they will be recognized correctly by the JCA deployer.

Copy the sample datasource, -ds.xml file from the directory $JBOSS_HOME/docs/examples/jca

to the deploy directory of your server:

– Oracle: oracle-ds.xml

– IBM DB/2: db2-ds.xml

– SQL Server 2005

and 2008: mssql-ds.xml

For example:

#cp $JBOSS_HOME/docs/examples/jca/mssql-ds.xml

$JBOSS_HOME/server/pega/deploy/mssql-ds.xml

The following is a sample of what your datasource definition could look like for a SQL Server

datasource.

<local-tx-datasource>

<jndi-name>jdbc/PegaRULES</jndi-name>

<connection-url>