cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

CData in graphical mapping for line feed

Former Member
0 Kudos
1,396

Hello!

I have ABAP Proxy to JDBC asynchronous scenario.

SAP PI 7.4 single stack.

Elements with line feed (i.e. <BPFullName>Sample Name&#xA;</BPFullName> ) are sometimes sent from sender system.

These line feed symbols are converted to real line feeds after mapping (instead of &#xA; ).

Our JDBC receiver gives error in this case because SQL statement becomes separated into two lines:

     java.sql.SQLException: Found a quote for which there is no matching quote.


I know that this issue is solved when value is escaped by CData like this:


            <fname><![CDATA[line_1

            line_2]]></fname>


Please tell me how to wrap some element into CDATA using graphical mapping.


Best regards,

Andrey Petin

View Entire Topic
suman_sourabh
Participant
0 Kudos

Hi Andrey,

You can concat the original value with "<![CDATA[" and "]]>" in grapical map to add the Cdata segment.

Hope this will help.

Regards,
Suman