MQSeries.net :: View topic - MbNode.createSQLStatement() throws MbRecoverableException wi

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 » IBM MQ Java / JMS » MbNode.createSQLStatement() throws MbRecoverableException wi

MbNode.createSQLStatement() throws MbRecoverableException wi

« View previous topic :: View next topic »

Author

Message

GÃ¼nter

Posted: Thu Feb 21, 2002 1:52 am Post subject:

Newbie

Joined: 20 Feb 2002
Posts: 3

Hi folks,

following code

MbSQLStatement sm = createSQLStatement("GKPROP1", "SELECT T.NAME FROM Database.TABPROP1 AS T");

throws Exception:

<com.ibm.broker.plugin.MbRecoverableException class:JNI method: source:WMQIv210 key:2401 >

I tried hundreds of versions for the createSQLStatement parameters...
I cannot find any hint in the documentation ...

(
Has anyone a hint ?

Thanks, GÃ¼nter

GÃ¼nter

Posted: Mon Feb 25, 2002 5:37 am Post subject:

Newbie

Joined: 20 Feb 2002
Posts: 3

Ok guys,
the reason is:
it has to have real ESQL syntax including the assignment
(hard for a pure Java programmer...)

MbSQLStatement myStatement = createSQLStatement("GKPROP1","SET OutputRoot.XML.GKPROP1.NAME[] = (SELECT ITEM T.NAME FROM
Database.knauer.TABPROP1 AS T);");

and the next trap is
the ODBC registration has to be as system data source !

- GÃ¼nter

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » IBM MQ Java / JMS » MbNode.createSQLStatement() throws MbRecoverableException wi

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