JDBC drivers not working in QA for multibye characters

[Former Member]

Hi,

we have a problem with JDBC and deployed in DEV system and its works fine, but the same when we deply in QA its not working.

the problem we are trying to use the simple select query from ORACLE DB.

In ORACLE DB they converted the chenise char to English after that our JDBC drivers are not able to pick the multibite char.

XI JDBC Adapter shows below error with a SELECT Query

SELECT Query:SELECT * FROM APPS.ITEM_XI_V The Chinese character are converted to English and becomes multibye characters.

Error:Error during conversion of query result to XML: java.sql.SQLException: Fail to convert between UTF8 and UCS2: failUTF8Conv

Assumption is that the issue with older version of ojdbc14.zip (JDBC Driver file)

Reference:http://www.coderanch.com/t/299231/JDBC/java/UTF-conversion

implement SAP Note 941317 in order to resolve the current issue.

Note 941317 - XI / PI JDBC Adapter: Known Problems / Incompatibilities JDBC Driver Deployment. Refer to SAP Note 831162

after apply as per note for DEV system its works fine, but the same when we did for our QA system still the same error.

Thanks,

Venkat.

[Former Member]

In select statment used the convert(DESCRIPTION, 'UTF8', 'WE8ISO8859P1') format and its worked.

Thanks,

Venkat

[Former Member]

Hi Gurus,

Any idea where i am doing wrong.. in QA i am able to extract data with simple select statment with normal tables...

Thanks,

Venkat