| Author |
Message
|
| muthu121521 |
 Posted: Fri Sep 04, 2015 8:32 am Post subject: How to handle junk or high end or low values in mf |
 |
|
Apprentice
Joined: 31 Aug 2015
Posts: 36
|
Our IIB service we are exposing a web service which invokes a stored procedure and gets the response and then construct the message in XML format.
We are getting high or low end values or junk characters from db2 main frame
Our requirement is that we can get these values in any element if that occurs i will have to show that as null otherwise the whatever valid value i have to display it in the response
How can i handle this ?
Below is the error we are getting when we are invoking,i think the error occurred when come soap reply node.We are using inherit as validation property
Error Making JNI Call: method_com_ibm_broker_axis2_Axis2Invoker_prepareToSendReplyNonSOAP:Frame : 0 org.apache.axiom.om.OMException: javax.xml.stream.XMLStreamException: An invalid XML character (Unicode: 0x0) was found in the element content of the document.| @: o |
|
| Back to top |
|
 |
| Vitor |
| Posted: Fri Sep 04, 2015 8:44 am Post subject: Re: How to handle junk or high end or low values in mf |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| muthu121521 wrote: |
| How can i handle this ? |
Write code (ESQL?) to null out invalid XML characters
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Fri Sep 04, 2015 8:59 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Perhaps you should review this with the DB team and make sure that the values you are getting back are not in a different codepage than you expect?
_________________
chmod -R ugo-wx / |
|
| Back to top |
|
|
| muthu121521 |
| Posted: Fri Sep 04, 2015 9:35 am Post subject: |
|
|
Apprentice
Joined: 31 Aug 2015
Posts: 36
|
Write code (ESQL?) to null out invalid XML characters//
We are using only ESQL to call stored procedure ,transform the messages and construct the message in xml format
how can i null out these values ? by casting it as CCSID 1208 |
|
| Back to top |
|
|
| Vitor |
| Posted: Fri Sep 04, 2015 9:52 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| muthu121521 wrote: |
| how can i null out these values ? by casting it as CCSID 1208 |
No, because characters valid in 1208 are not valid in XML.
You'll have to remove the undesired characters with logic, and escape characters than have to be escaped.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| inMo |
| Posted: Fri Sep 04, 2015 10:08 am Post subject: |
|
|
Master
Joined: 27 Jun 2009
Posts: 216
Location: NY
|
| Please see the part of your post where you indicate that you use ESQL to transform the message. |
|
| Back to top |
|
|
| timber |
| Posted: Fri Sep 04, 2015 2:09 pm Post subject: |
|
|
Grand Master
Joined: 25 Aug 2015
Posts: 1292
|
| Quote: |
| how can i null out these values ? by casting it as CCID 1208 |
Where ( exactly ) do these 'high values' and 'low values' and 'junk characters' appear. Think carefully before answering - if you don't understand the problem then you have no chance of getting the right solution. |
|
| Back to top |
|
|
|
|
