JDBC adapter , problem in inserting Korean Charaters in MS SQL

[Former Member]

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--

---

Bean Local Enterprise Bean 1

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

[stefan_grube]

Use only the XMLAnonymizerBean, not the TextCodepageConversionBean which must not be used for XML payload.

Regards

Stefan

[Former Member]

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

[Former Member]

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