Converting International characters from Select Adapter Service response

, ,
1

Hi all - I’m trying to query data from an Oracle database that has international characters. The INSERT adapter service works fine, I can write Japanese characters into the table, but the SELECT has issues. This is the error I get:

com.wm.app.b2b.server.ServiceException: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service Emmy.Internationalization:selectAll.
[ADA.1.316] Cannot execute the SQL statement “SELECT t1.USERID,t1.DESCRIPTION,t1.TEXT FROM UTF8 t1”. "
(17055) Invalid character encountered in: failAL32UTF8Conv"

The Japanese characters are in the DESCRIPTION field. If I change the SELECT to just pick USERID and TEXT, it’s fine. So I assume this is because it can’t convert the international characters.

Has anyone resolved this issue?

2

Ok, figured it out. I was able to resolve this issue by using driverType=oci instead of “thin” in the db connection.