on 10-25-2007 8:40 AM
Hi ,
We are facing a problem when we are inserting "Koren Charaters" in DB of type MS SQL using JDBC adapter.
What we tryed is:
We found that there is a problem in Code Page Conversion. We tried adding a Modules in Receiver Adapter of type JDBC.
Processing Sequence:
AF_Modules/XMLAnonymizer--
AF_Modules/TextCodepageConversionBean-Bean Local Enterprise Bean-- 2
CallSapAdapter----
Local Enterprise Bean -- 0
-
Module Configuration:
1 anonymizer.encoding UTF-16
2 Conversion.charset UTF-16.
But we are getting the error in CC as:
"Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: ERROR occured parsing request:com.sap.engine.lib.xml.parser.NestedSAXParserException: Fatal Error: com.sap.engine.lib.xml.parser.ParserException: XMLParser: No data allowed here: (hex) feff, 3c, feff(:main:, row:2, col:6)(:main:, row=2, col=6) -> com.sap.engine.lib.xml.parser.ParserException: XMLParser: No data allowed here: (hex) feff, 3c, feff(:main:, row:2, col:6)"
also should I have to check any patches related to JDBC driver from MS SQL which supports korean Code Page?
Any one who had face this problem pls give us inputs:
Thanks
Shankar
Use only the XMLAnonymizerBean, not the TextCodepageConversionBean which must not be used for XML payload.
Regards
Stefan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Stefan,
we have also tried with XMLAnonymizerBean, we are getting the error in receiver JDBC CC, error is below. ..
---
Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: ERROR occured parsing request:com.sap.engine.lib.xml.parser.NestedSAXParserException: Fatal Error: com.sap.engine.lib.xml.parser.ParserException: XMLParser: No data allowed here: (hex) feff, 3c, feff(:main:, row:2, col:6)(:main:, row=2, col=6) -> com.sap.engine.lib.xml.parser.ParserException: XMLParser: No data allowed here: (hex) feff, 3c, feff(:main:, row:2, col:6)"
---
Thanks
Shankar
Hi
In the XML sent to the channel you will have to use a special quoting
for any Unicode strings, which the JDBC Adapter will not produce on its
own. Instead, you need to add an attribute 'hasQuot="no"' to those
elements (most likely in the mapping where you produce the XML) and
explicitly enclose the data in single quotes prefixed with the letter N.
For clarity, one example:
If your original "INSERT" operation looks like this:
<StatementName2>
<dbTableName action="INSERT">
<table>realDbTableName</table>
<access>
<col1>val1</col1>
<col2>val2</col2>
</access>
</dbTableName>
</StatementName2>
and "col1" contains Unicode data, change the document as follows:
<StatementName2>
<dbTableName action="INSERT">
<table>realDbTableName</table>
<access>
<col1 hasQuot="no">N'val1'</col1>
<col2>val2</col2>
</access>
</dbTableName>
</StatementName2>
Regards
Shankar
User | Count |
---|---|
95 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.