Skip to main content

         This documentation site is for previous versions. Visit our new documentation site for current releases.      

This content has been archived and is no longer being updated.

Links may not function; however, this content may be relevant to outdated versions of the product.

How to use JDBC DataSources with Oracle 9.2.04 and IBM WebSphere

Updated on August 28, 2019


Pegasystems recommends to customers that they utilize JDBC Datasources to establish the database connections with V4.2. However, customers who are running Oracle 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 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.

Have a question? Get answers now.

Visit the Support Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best. is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us