Specifying the Catalog/Package field in a JDBC Call Procedure when calling a DB2 stored procedure.

Specifying the Catalog/Package field in a JDBC Call Procedure when calling a DB2 stored procedure.

book

Article ID: KB0089269

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks -
Not Applicable -

Description

Resolution:
Description:
============
I am able to select a value for the Catalog/Package field. But at run time the following error is reported:

BW-JDBC-100014 Job-1000 Error in [Process Definition.process/JDBC Call Procedure]
"JDBC error reported: (SQLState = HY000) - java.sql.SQLException: [tibcosoftwareinc][DB2 JDBC Driver][DB2]The Specified library "&ltschema>.&ltCatalog/package>.&ltprocedure>" could not be loaded."
caused by: java.sql.SQLException: [tibcosoftwareinc][DB2 JDBC Driver][DB2]The Specified library "&ltschema>.&ltCatalog/package>.&ltprocedure>" could not be loaded.

Environment
===========
All platforms
All BW versions
[SME-Comments] My recommendation for the Scope for the KB Article : Customer

Resolution:
==========
A DB2 stored procedure is qualified by &ltschema name>.&ltprocedure name>. That is, the fully qualified procedure name does not have a  catalog or package name. To resolve the error, you need to set the Catalog/Package field to blank.

Issue/Introduction

Specifying the Catalog/Package field in a JDBC Call Procedure when calling a DB2 stored procedure.