JDBC Adapter: Mapping: result contains only null values

[Former Member]

Hi,

I have a strange problem:

I am receiving the data from the jdbc-adapter correctly. You can see the receiving message in the xml-messages monitor (xsi_monitor).

Here the receiving-message:

<?xml version="1.0" encoding="utf-8" ?>

<resultset>

<row>

<TN_ID>A2E00231163</TN_ID>

<INFOS>B0V43C3532VM83</INFOS>

</row>

<row>

<TN_ID>A2E00231164</TN_ID>

<INFOS>B0V43C3732VM83</INFOS>

</row>

</resultset>

But after the mapping each value has the value "null"!?!?!?! I tried to replace the mapping with constants, "replaceValue" etc., then the target-value is correct! The test in the message-mapping editor is ok!!!!

Here the target-message:

<?xml version="1.0" encoding="UTF-8" ?>

<ns0:CompassZTable xmlns:ns0="http://...">

<ItemNumber>null</ItemNumber>

</ns0:CompassZTable>

I hope that anybody can help me! Thanks a lot!!!!

Regards,

Hannes

[former_member185751 · Accepted solution]

Hi Hannes,

Copy and paste your receiving message Integration builder test tool and execute.Don't use constants or "replacevalue".

Let us know what the result is. Also "Display Queue" for the source and target nodes and provide the details how the data looks in the queue.

Regards,

Sridhar

[Former Member · Accepted solution]

Hi Rajan,

Thanks a lot for your answer!

I figured out, that the XML namespace was absent in the receiving-message. That was the problem.

I added the namespace in the JDBC-adapter configuration, and now it works!!! Great!

[Former Member · Accepted solution]

Hi Hannes,

I guess, I have the same problem.

Can you explain me detailed, where I have to set a namespace?

Thanks

[Former Member · Accepted solution]

In the Sender channel, the value of the fields:

Document Name/Document Namespace should match exactly the message name/message namespace of the message that you use to retrieve the data.

Hope this helps,

Alessandro