Gel scripts with native Oracle driver after Clarity upgrade to 16.0.3+

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

After Clarity upgrade to 16.0.3+, the Oracle driver is no longer working. Here is the example used:

    <sql:setDataSource driver="${dbDriver}"
        password="${dbUserClarityPassword}"
        url="jdbc:oracle://${dbServer}:${dbPort};SID=${dbService};BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true"
        user="${dbUserClarity}" var="clarity"/>

Cause

Driver change from Data Direct to Oracle native driver

Resolution

Please follow the below example of Oracle native driver to use in your GEL scripts:

jdbc:oracle:thin:@//<hostname>:<port>/<service_name>/<service_name>