Clarity - set up JDBC URL to retry Connections on Oracle thin driver

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Getting Connection Reset and Connection Timeouts, trying to set up the JDBC URL in Clarity CSA / properties.xml to use the ConnectionRetryCount=20;ConnectionRetryDelay=15;

They do not seem to be working with Oracle native think JDBC driver.

During upgrade the below error may be thrown:

Apr 02, 2024 2:19:37 AM org.apache.tomcat.jdbc.pool.ConnectionPool terminateTransaction
WARNING: Unable to terminate transaction, connection will be closed.
java.sql.SQLRecoverableException: Closed Connection

Cause

JDBC URL is now using Oracle thin driver and the corresponding syntax

Resolution

Set up the JDBC URL to follow the proper Oracle thin driver syntax. Example as below:

jdbc:oracle:thin:@ (DESCRIPTION=(CONNECT_TIMEOUT=15)(RETRY_COUNT=20) (RETRY_DELAY=3)(ADDRESS_LIST =(LOAD_BALANCE=ON)  (ADDRESS=(PROTOCOL=tcp)(HOST=primaryscan)(PORT=1521))) (CONNECT_DATA=(SERVICE_NAME=myorcldbservicename)))