JasperReports - use Oracle service name instead SID in context.xml

Products

• CA Identity Manager
• CA Identity Governance
• CA Identity Portal
• CA Identity Suite

Issue/Introduction

What is the syntax of the connection URL to the Oracle database via ServiceName?

Resolution

This is the syntax for connecting to the ServiceName of the Jasper Oracle database.

jdbc:tibcosoftwareinc:oracle://<host>:<port1521>;ServiceName=<ServiceName> 

For example,

jdbc:tibcosoftware:oracle://myora-cluster.broadcom.com:1521;ServiceName=VIDM01.broadcom.com