What is the syntax of the connection URL to the Oracle database via ServiceName?
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