Installation guide

PegaRULES Process Commander Installation Guide v6.1 SP2

jdbc:microsoft:sqlserver://<your_host_name>:1433;SelectMethod=cursor;SendString

ParametersAsUnicode=false;DatabaseName=<Your_database_name>

</connection-url>

<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>

<user-name>DB_username</user-name>

<password>DB_user_password</password>

<type-mapping>sqlserver</type-mapping>

</metadata>

</local-tx-datasource>

</datasources>

To create the datasource, follow these steps:

1. Enter exactly the JNDI name jdbc/PegaRULES:

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

2. Modify the <connection-url> element, to specify the connection

information for your Process Commander database and add connection

properties as described for your database below.

SQL Server 2005 and 2008:

<connection-

url>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=MyDatabase</

connection-url>

– Replace localhost with the hostname of your database server.

– Confirm the port number of the server.

– Replace MyDatabase with the name of the database you created for

Process Commander.

– Add the following connection strings as URL parameters :

SelectMethod=cursor;

SendStringParametersAsUnicode=false;

For example, your connection URL might look like the following:

jdbc:sqlserver://PRPCServer:1433;

DatabaseName=pega>;SendStringParametersAsUnicode=false;SelectMethod=cursor;

Oracle

<connection-url>jdbc:oracle:thin:@youroraclehost:1521:yoursid</connection-url>

– Replace youroraclehost with the hostname of your database server.

– Confirm the port number of your database server.

– Replace yoursid with the name of your Process Commander database.