Summary

Pegasystems recommends to customers that they utilize JDBC Datasources to establish the database connections with V4.2. However, customers who are running Oracle 9.2.0.4 or later must use the compatibility switch for proper Process Commander operation.  Setting a "custom property" for Oracle Datasources in Websphere is undocumented by IBM.

Suggested Approach

Configure the JDBC Datasource as documented in the 04-02 install manual.  If running Oracle 9.2.0.4 or later, add a custom property as follows.

1. In the AdminConsole, go to Resources -> JDBC Providers -> Oracle JDBC Driver -> Data Sources-> Custom Properties -> New
2. Enter for Name: connectionProperties
3. Enter for Value: oracle.jdbc.V8Compatible=true
4. Click OK.
5. Save the configuration.
6. Restart the application server.