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?
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.