SOAP to JDBC scenario

[Former Member]

Hi everybdoy,

I ahev a soap to JDBC scenario, the response sent by the SQL team  has a different structure then the one maintained in PI but still message is getting processed successfully but output is empty.

My doubt is whe the strcuture is not correct how come messages are not failing in Moni.

I tested in Message mapping and found that the nodes appear in red but mapping is getting executed successfully with out error.

Could some one tell me why is this happening.

The response from SQL:

<Stmt_resp>

    <resp1>

          <ID>2</ID>

    </resp1>

<resp2> 

          <Name>Test</Name>

</resp2>

</Stmt_resp>

The response structure in PI is:

<Stmt_resp>

    <resp1>

          <Name>2</Name>

    </resp1>

</Stmt_resp>

Thanks

Newa

[Former Member]

Hi,

We fixed the issue.

The reason for the incorrect structure is by the SQL team , once they corrected it we were able to get the right response.

However one thing  is that, the message mapping executed successfully even when we used the incorrect structure received from the SQL.

Thanks

Newa

[markangelo_dihiansan]

Hello,

That is because the occurrence of the target structure is 0..1 meaning it is not required to exist.

Regards,

Mark

[markangelo_dihiansan]

Hello,

You could change the response structure in PI so that it matches the one from JDBC. Maybe the reason it is not failing because the occurrence is 0..1 in the data type.

Regards,

Mark