Skip to Content

How to mapping response message with same fields name in jdbc receiver adapter

hi ,experts.

I have a problem about jdbc receiver adapter. I want to query data from 3rd system database.I used SOAP-JDBC adapter to do this interface , and it seems work fine.Problem occurs when it comes to the response message.

The SQL syntax is below:

select t1.*,t2.* from JIS_TOD_SAP_TITLE as t1 left join JIS_TOD_SAP_MESSAGE as t2 on t1.Lelve_1_GUID=t2.Lelve_1_GUID

Both tables have some fields with same field name and different value,i need both of these fields values,when i get the XML fromat response message from receiver jdbc adapter,same field name tags with different values in it.But how can i define a Data Type with same field names in IR.

I'll be appreciate if someone give a solutions!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jun 22, 2017 at 09:49 AM

    Hi Zhu!

    First of all, using Select * in SQL query is not the good practice.

    Use the following syntax instead:

    Select a.field1 as field1_a, b.field1 as field1_b

    Regards, Evgeniy.

    Add comment
    10|10000 characters needed characters exceeded