| Author |
Message |
 Topic: can't extract xml attributes in compute (iib v10) |
pavel112233
Replies: 37
Views: 13549
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Wed Oct 05, 2016 7:53 am Subject: can't extract xml attributes in compute (iib v10) |
Vitor and other participiants,
thank you very much! |
| Topic: can't extract xml attributes in compute (iib v10) |
pavel112233
Replies: 37
Views: 13549
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Oct 05, 2016 6:16 am Subject: can't extract xml attributes in compute (iib v10) |
solved!
I used the wrong odbc driver - oracle standard driver instead of
IBM Integration Bus (10.0.0.2) DataDirect Technologies 64-BIT Oracle Wire Protocol.
Here's the odbc connection configurati ... |
| Topic: can't extract xml attributes in compute (iib v10) |
pavel112233
Replies: 37
Views: 13549
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Oct 05, 2016 3:22 am Subject: can't extract xml attributes in compute (iib v10) |
funny, I tried simple insert
INSERT INTO Database.test1 (ID, val) VALUES ('test2', 2)
and result is still
整瑳 | 2
so I guess it has nothing to do XML parsing and enc ... |
| Topic: can't extract xml attributes in compute (iib v10) |
pavel112233
Replies: 37
Views: 13549
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Oct 05, 2016 1:43 am Subject: can't extract xml attributes in compute (iib v10) |
the trace was trimmed, full version is here :
https://www.ibm.com/developerworks/community/forums/html/topic?id=8284f416-9375-42f3-8d7d-84967dd86408&ps=25#repliesPg=0 |
| Topic: can't extract xml attributes in compute (iib v10) |
pavel112233
Replies: 37
Views: 13549
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Oct 05, 2016 1:31 am Subject: can't extract xml attributes in compute (iib v10) |
timber,
here comes the trace. but as you can see it's not english, it's in my local language, how can I switch it to english?
Instead, you should find out what the correct encoding is and use that. ... |
| Topic: can't extract xml attributes in compute (iib v10) |
pavel112233
Replies: 37
Views: 13549
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Oct 05, 2016 12:22 am Subject: can't extract xml attributes in compute (iib v10) |
rekarm01,
success! great thanx! this cast works:
<TestRoot><a>1</a></TestRoot> ====>
cast(InputRoot.XMLNSC.TestRoot.a as integer)
- as a result I put "1" into ... |
| Topic: can't extract xml attributes in compute (iib v10) |
pavel112233
Replies: 37
Views: 13549
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Oct 04, 2016 8:57 pm Subject: can't extract xml attributes in compute (iib v10) |
| "One thing to note here is that InputRoot.Properties.Encoding is an INTEGER, while InputRoot.XMLNSC.TestRoot.a (or the original InputRoot.XMLNSC.a / InputBody.a) is a CHARACTER. Perhaps a more ex ... |
| Topic: can't extract xml attributes in compute (iib v10) |
pavel112233
Replies: 37
Views: 13549
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Oct 04, 2016 12:59 pm Subject: can't extract xml attributes in compute (iib v10) |
what do you mean by user trace? I thought I did that - trace node..
No. When @timber mentions user trace (as I did earlier), we both mean running the flow with the
I did that:
mqsichangetrace ... |
| Topic: can't extract xml attributes in compute (iib v10) |
pavel112233
Replies: 37
Views: 13549
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Oct 04, 2016 12:10 pm Subject: can't extract xml attributes in compute (iib v10) |
Generally speaking I did nothing unusual, everything is by default, so why it still doesn't work "from the box"? It supposed to be very easy task to insert a row into table ((
Perhaps I'm ... |
| Topic: can't extract xml attributes in compute (iib v10) |
pavel112233
Replies: 37
Views: 13549
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Oct 04, 2016 12:05 pm Subject: can't extract xml attributes in compute (iib v10) |
I take back my comment about your ESQL field reference...you're already doing what I recommended.
Surely the next step is a user trace. That should provide some useful insight into what's going on ... |
| Topic: can't extract xml attributes in compute (iib v10) |
pavel112233
Replies: 37
Views: 13549
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Oct 04, 2016 12:01 pm Subject: can't extract xml attributes in compute (iib v10) |
Your ESQL is wrong. The root tag is TestRoot (as clearly shown in the Trace node output that you posted) so the ESQL field reference for accessing /TestRoot/a is InputRoot.XMLNSC.TestRoot.a
For the r ... |
| Topic: can't extract xml attributes in compute (iib v10) |
pavel112233
Replies: 37
Views: 13549
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Oct 04, 2016 11:55 am Subject: can't extract xml attributes in compute (iib v10) |
and when I try some properties of the message it works ok. the problem is in the BODY
INSERT INTO Database.test1 (ID, val) VALUES (InputRoot.Properties.Encoding, 2)
select * from test1
273 | 2 |
| Topic: can't extract xml attributes in compute (iib v10) |
pavel112233
Replies: 37
Views: 13549
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Oct 04, 2016 11:50 am Subject: can't extract xml attributes in compute (iib v10) |
A minor point is that you are calling both CopyMessageHeaders and CopyEntireMessage.
It's not an issue, the CopyEntireMessage will recopy all the things CopyMessageHeaders did.
It looks like yo ... |
| Topic: can't extract xml attributes in compute (iib v10) |
pavel112233
Replies: 37
Views: 13549
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Oct 04, 2016 11:24 am Subject: can't extract xml attributes in compute (iib v10) |
Could you show us the XML you're getting in (names changed to protect the annoying) with the XML you're trying to produce?
i have this message on the input of compute node:
https://www.ibm.com/dev ... |
| Topic: can't extract xml attributes in compute (iib v10) |
pavel112233
Replies: 37
Views: 13549
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Oct 04, 2016 11:22 am Subject: can't extract xml attributes in compute (iib v10) |
Could you show us the XML you're getting in (names changed to protect the annoying) with the XML you're trying to produce?
what do you mean by " the XML you're getting in"
isn't it <Te ... |
