Skip to Content
0

JDBC to FILE- exception in XML Parser for Character "&#x1a"

May 01 at 02:08 PM

22

avatar image
Former Member

Hello Guys,

I am working on JDBC to File scenario. JDBC adapter fetched some special character "" in the XML payload which results into SAXParseException as below:

Only one field has this special character. I am not using any mapping. Is there any way to deal with this special character by writing some UDF for that particular field? Or in the JDBC SQL (Select) query to remove/replace this special character?

Regards,

Simran

lssf9.png (24.2 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Priyanka Anagani May 04 at 09:33 AM
0

Hi Simran,

I've faced the similar issue. There are 2 alternatives.

Option1 is to clean the data in the DB itself. But, sometimes the characters which XML is stating as invalid XML char, are not invalid in DB perspective. If that's the case, we have to handle in PI.

Option2 is to write a javamapping in PI to remove the special characters. This javamapping should be the first mapping to be called and then your actual mapping.

I used option2 and removed the chars using javamapping.

--Priyanka

Share
10 |10000 characters needed characters left characters exceeded