Sender JDBC adapter...problem

[Former Member]

Hi,

the real problem is Sender JDBC adapter sends data in following format.

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

<resultset>

<row>

<Associate_ID>16444</Associate_ID>

<Associate_Name>Sudhir</Associate_Name>

<Status>false</Status>

</row>

</resultset>

But in Design time mapping...structure of source message will be like

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

<ns5:DB2File_DB_MT xmlns:ns5="urn:db2file">

<Resultset>

<Row>

<Associate_ID>16444</Associate_ID>

<Associate_Name>Sudhir</Associate_Name>

<Status>false</Status>

</Row>

</Resultset>

</ns5:DB2File_DB_MT>

How does this tag ... <ns5:DB2File_DB_MT xmlns:ns5="urn:db2file"> get generated in runtime

and apart from 1 to 1 mappings b/w the three fields above in the row tag...wt other mappings to be performed

Pls help...

Sunita

[Former Member]

Hi Sunita,

what i understood from your query is namespace tag is coming while message mapping. This namespace can be avoided in the message type if you keep the XML namespace field empty while creating message type. But i afraid you have to do the message mapping again.

Regards,

Satish