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?