MQSeries.net :: View topic - DataObject parsing issue

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 » DataObject parsing issue

DataObject parsing issue

« View previous topic :: View next topic »

Author

Message

nelson

Posted: Sun Nov 16, 2014 9:22 pm Post subject: DataObject parsing issue

Partisan

Joined: 02 Oct 2012
Posts: 313

Hi All,

This is weird. I have the following message flow:

Datadase Input Node -> Database Node

I'm not able to read the values of the row retrieved by the Database Input Node.

Debugging I get this (The message seems to be ok):

Code:

Message
DataObject
      DBINPUT_CUSTOMER
            PKEY:CHARACTER:cust3
            FIRSTNAME:CHARACTER:Nelson
            LASTNAME:CHARACTER:Lindora
            CCODE:CHARACTER:Dev1

Within the Database Node I have:

Code:

DECLARE PKEY CHARACTER;
SET PKEY = Root.DataObject.DBINPUT_CUSTOMER.PKEY;

But getting this (also debugging ):

Code:

PKEY:UNKNOWN:null

Is this path correct Root.DataObject ?

Thanks in advance for your help.

fjb_saper

Posted: Sun Nov 16, 2014 9:40 pm Post subject:

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY

Did you try replacing Root with $Root ?

_________________
MQ & Broker admin

nelson

Posted: Mon Nov 17, 2014 6:31 am Post subject:

Partisan

Joined: 02 Oct 2012
Posts: 313

fjb_saper wrote:

Did you try replacing Root with $Root ?

I think If I were using XPath that could work, but here in ESQL this doesn't work.

I know that Database Node use Root instead of InputRoot/OutputRoot, but not sure if I am missing something else.

nelson

Posted: Mon Nov 17, 2014 11:37 am Post subject:

Partisan

Joined: 02 Oct 2012
Posts: 313

Solved!

DatabaseInput Node script wizard creates and uses a namespace. The auto generated ESQL has something like this by default (database name and schema):

Code:

DECLARE ns NAMESPACE 'http://dbinput/admin';

So.. Accessed the value in this way:

Code:

Root.DataObject.DBINPUT_CUSTOMER.PKEY;

I'm wondering why the debugger does not display the namespace in the variables tab.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » DataObject parsing issue

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