Welcome Guest! Log in
×

Notice

The forum is in read only mode.
Stambia versions 2.x, 3.x, S17, S18, S19 and S20 are reaching End of Support January, 15th, 2024. Please consider upgrading to the supported Semarchy xDI versions. See Global Policy Support and the Semarchy Documentation.

The Stambia User Community is moving to Semarchy! All the applicable resources have already been moved or are currently being moved to their new location. Read more…

Topic-icon Question error :com.sun.org.apache.xerces.internal.impl.io.MalformedByteSequenceException

More
05 Apr 2019 12:00 #1 by Sylvie INGABIRE
Hello,

I have this error when I execute an sql to parameters, with accents in a string value.
Example of the script :

<sqlToParameters>
<parameter name="../p_custtype_code" type="String">
select
case
when '${~/BusinessUnitCode}$' = '1' then 'réassort'
end
from %x{$MYTABLE/tech:physicalPath()}x%
</parameter>
</sqlToParameters>


Because of the accent (é) in 'réassort', I have the error : com.sun.org.apache.xerces.internal.impl.io.MalformedByteSequenceException: Octet 2 de la séquence UTF-8 à 3 octets non valide.
I only have this error when executing the sql to parameters on a runtime on windows. With a same version runtime on unix, I don't have the error.

Runtime version : S17.6.5

How could I fix this?

Thanks.
More
05 Apr 2019 18:15 #2 by Thomas BLETON
Hi,

The expression for the Sql To Parameters is based on XML.
XML often requires special characters to be encoded.
Try to replace "é" with "&#xE9;" and it should work.

I think that the error does not occur on Linux because it is not the same java vendor / version.

Note : we plan to provide in the future a new version of this Sql To Parameters action which will not have this kind of requirement.
More
08 Apr 2019 15:22 - 08 Apr 2019 15:25 #3 by Sylvie INGABIRE
Hello,

It does work when using
"&#xE9;"

Thanks

Sylvie
Last edit: 08 Apr 2019 15:25 by Sylvie INGABIRE.