Hi
I am using ibatis to create XML file from database, i have the following
sqlMap
<select id="getFooter4" resultClass="xml" parameterClass="
java.math.BigDecimal" xmlResultName="FOOTER4">
SELECT P704SPEC, P704LINE, P704DETL, P704USER, P704DATE, P704TIME
FROM PU27041 WHERE P704SPEC = #value#
</select>
This works fine, but some times P704DETL has german characters like Ö
(umlout) in this case the program fails and gives the following error
org.xml.sax.SAXParseException: Character conversion error: "Malformed UTF-8
char -- is an XML encoding declaration missing?" (line number may be too
low).
at org.apache.crimson.parser.InputEntity.fatal(InputEntity.java:1100)
at org.apache.crimson.parser.InputEntity.fillbuf(InputEntity.java:1072)
at org.apache.crimson.parser.InputEntity.isXmlDeclOrTextDeclPrefix(
InputEntity.java:914)
at org.apache.crimson.parser.Parser2.maybeXmlDecl(Parser2.java:1183)
at org.apache.crimson.parser.Parser2.parseInternal(Parser2.java:653)
at org.apache.crimson.parser.Parser2.parse(Parser2.java:337)
at org.apache.crimson.parser.XMLReaderImpl.parse(XMLReaderImpl.java:448)
at org.apache.crimson.jaxp.DocumentBuilderImpl.parse(
DocumentBuilderImpl.java:185)
at javax.xml.parsers.DocumentBuilder.parse(DocumentBuilder.java:76)
at com.ashishk.test.data.TestGetXMLData.<init>(TestGetXMLData.java:37)
at com.ashishk.test.data.TestGetXMLData.main(TestGetXMLData.java:74)
Is there a work around with this issue,
Ashish
