Does the JDBC connection for XML Canon 3.2 support the use of Oracle service name?

Does the JDBC connection for XML Canon 3.2 support the use of Oracle service name?

book

Article ID: KB0088723

calendar_today

Updated On:

Products Versions
TIBCO XML Canon -
Not Applicable -

Description

Resolution:
Description:
=========
This FAQ addresses the lack of XML Canon support for Oracle 10g/11g in a grid (i.e. load-balanced).

Environment:
==========
XML Canon: 3.x
OS: All
Oracle: 10.x and 11.x

Resolution:
===========
XML Canon 3.2 does not support the use of Oracle service name in its JDBC connection URL. Only the native Oracle thin-client driver is supported and only via the following Oracle JDBC URL:

jdbc:oracle:thin:@[host][:port]:SID

Attachments:
===========
None

Issue/Introduction

Does the JDBC connection for XML Canon 3.2 support the use of Oracle service name?