Skip to Content
0
Former Member
May 09, 2005 at 08:35 AM

JDBC Adapter: Mapping: result contains only null values

22 Views

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