I would like to use the Oracle JDBC driver but would like to keep the driver in the Oracle home. How can I modify the XML Canon classpath so that it can point to the Oracle classpath or elsewhere?
Article ID: KB0092231
Updated On:
| Products | Versions |
|---|---|
| TIBCO XML Canon | - |
| Not Applicable | - |
Description
Resolution:
If your XML Canon is using the default TIBCO JDBC driver, then you must first change the “driverClassName” and its “url” in the /TIBCO/xmlcanon/3.1/tomcat/conf/server.xml file as per the following example:
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@OracleServer:OraclePort:SIDName</value>
</parameter>
Then modify the /TIBCO/xmlcanon/3.1/tomcat/bin/xmlcanon.tra file by appending the Oracle JDBC driver jar to the classpath of the “java properties” as per the follwong example:
# java properties
java.class.path %TOMCAT_HOME%/bin/bootstrap_xmlcanon.jar:/oracle/ora92/jdbc/lib/ojdbc14.jar
[or java.class.path %TOMCAT_HOME%/bin/bootstrap_xmlcanon.jar %PSP%/oracle/ora92/jdbc/lib/ojdbc14]
Alternatively, you can set an environment variable for the Oracle home and substitute the variable for the path.
And, do not forget to save the changes and restart the XML Canon server.
Issue/Introduction
Feedback
