| Author |
Message
|
| RudraHubli |
 Posted: Wed Jan 21, 2015 3:21 am Post subject: How to handle special characters in ESQL |
 |
|
Apprentice
Joined: 18 Oct 2014
Posts: 28
|
Hi All,
Getting XML parsing error for below data -
<AgentName>PIONEER FILM & TV PROD LTD</AgentName>
Any idea how to handle it ESQL and avoid xml parsing error which is containing "&" ??
Regards,
Rudra |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Wed Jan 21, 2015 3:29 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20697
Location: LI,NY
|
Why would you be getting a parsing error over this?
What parser are you using? 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| RudraHubli |
| Posted: Wed Jan 21, 2015 3:33 am Post subject: |
|
|
Apprentice
Joined: 18 Oct 2014
Posts: 28
|
| I am getting above data as response from backend system and its failing in our side i mean after receivng response and parsing with XMLNS parser. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Wed Jan 21, 2015 3:36 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20697
Location: LI,NY
|
| RudraHubli wrote: |
| I am getting above data as response from backend system and its failing in our side i mean after receivng response and parsing with XMLNS parser. |
Did you run a user debug trace. What did it yield. I would expect that the parsing error is either prior or post or due to a bad/missing/incorrect namespace.
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| RudraHubli |
| Posted: Wed Jan 21, 2015 3:41 am Post subject: |
|
|
Apprentice
Joined: 18 Oct 2014
Posts: 28
|
I am getting error in SIT testing on AIX environment. Not able to trace it exactly.
Error is -An XML parsing error 'The entity name must immediately follow the '&' in the entity reference.'
I dont think its related to namespace issue. |
|
| Back to top |
|
|
| RudraHubli |
| Posted: Wed Jan 21, 2015 3:42 am Post subject: |
|
|
Apprentice
Joined: 18 Oct 2014
Posts: 28
|
| How to handle those type of data in ESQL ??? |
|
| Back to top |
|
|
| kimbert |
| Posted: Wed Jan 21, 2015 3:51 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
|
| Back to top |
|
|
| RudraHubli |
| Posted: Wed Jan 21, 2015 3:56 am Post subject: |
|
|
Apprentice
Joined: 18 Oct 2014
Posts: 28
|
Even i also thinking same...& has been encoded twice i.e
&amp;
If that is case...how to hanlde it in ESQL ??
I am using XMLNSC parser..sorry typo mistake. |
|
| Back to top |
|
|
| kimbert |
| Posted: Wed Jan 21, 2015 6:06 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
| Quote: |
| If that is case...how to hanlde it in ESQL ?? |
Don't. IF our guess is correct then the input XML is badly-formed. So you would need find why it is happening and ( if possible ) fix the application that generates the XML.
But first you need to diagnose the error that is being reported by the flow.
_________________
Before you criticize someone, walk a mile in their shoes. That way you're a mile away, and you have their shoes too. |
|
| Back to top |
|
|
|
|
