Hi Team,
We are running on Pega 8.8.3 with Apache Tomcat and Oracle 19c.
Current setup:
- Application server: Apache Tomcat
- Database: Oracle 19c
- Datasource: jdbc/PegaRULES
- Datasource file: Tomcat context.xml
- Current JDBC driver: Oracle JDBC Thin 19.10
- Planned JDBC driver: Oracle JDBC Thin 23.9+
Our DB/OaaS team has recommended applying Tomcat datasource changes along with the JDBC Thin 23.9 upgrade.
Main proposed changes are:
- Set testOnBorrow=“True”
- Remove validationQuery so JDBC Connection.isValid() is used
- Adjust pool settings such as maxTotal, maxWaitMillis, removeAbandonedTimeout, validationInterval, etc.
We are not planning to configure Oracle UCP, as Pega Support previously advised UCP is not supported/recommended for Pega primary DB connection on Tomcat.
Question:
For Pega 8.8.3 running on Tomcat, is it safe and supported to apply these Tomcat context.xml datasource changes for jdbc/PegaRULES along with Oracle JDBC Thin 23.9 upgrade?
Please advise if there are any Pega-specific concerns with these changes.