MQSeries.net :: View topic - DatabaseRetrieve Node

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » DatabaseRetrieve Node

DatabaseRetrieve Node

« View previous topic :: View next topic »

Author

Message

PEPERO

Posted: Sat Nov 17, 2012 8:02 am Post subject: DatabaseRetrieve Node

Disciple

Joined: 30 May 2011
Posts: 177

Hi all;
When using the java compute node to connect to a DB2 server using Type 4 JDBC driver , i've defined the collection name through the environmentparms of the jdbcCollection and every thing is ok.
Within the JDBCProvider configurable service parameters :

Code:

.
.
.
environmentParms : jdbcCollection=USER1PKG
.
.
.

But when using the same JDBCProvider configurable service within the DataSource field of the DatabaseRetrieve node , it doesn't detect the related package and an error issues as follows :

Code:

DB2 SQL Error : SQL CODE=-551, SQLSTATE=42501, SQLERRMC=USER1;EXECUTE PACKAGE;NULLID.SYSLH200, DRIVER=3.57.91, ...

Since there has being defined a package name "USER1PKG" with the "jdbcCollection" through the "environmentparms" of the "JDBCProvider" configurable service, i don't know why it is using the NULLID package?

So is there any specific "environmentParms" related to the DATABASERETRIEVE node instead of the jdbcCollection?

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » DatabaseRetrieve Node

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP