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

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

book

Article ID: 136624

calendar_today

Updated On:

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