RE: Character conversion between CCSID 13488 and CCSID 65535 not valid

I had the similar problem when I run a Java stored procedure on AS/400 by
using native JDBC driver.  I got the error message:

com.ibm.db2.jdbc.app.DB2DBException: Character conversion between CCSID
65535 and CCSID 13488 not valid. 

And the same code runs OK on PC with jt400.jar.

I still don't have any answer yet.

-----Original Message-----
From: Bruce Jin [mailto:JIN007M@hotmail.com]
Sent: Tuesday, January 28, 2003 5:50 PM
To: java400-j
Subject: Character conversion between CCSID 13488 and CCSID 65535 not
valid


I have a character field that is 400 in length.  When this field contains
packed data (which I get by calling a RPG program), update file using native
driver fails with following error:

 

com.ibm.db2.jdbc.app.DB2DBException: Character conversion between CCSID
13488 and CCSID 65535 not valid. 

 

If this field does not contain packed data, update file is OK. 

Also, the same code runs OK with remote database update (using jt400),
regardless this field contains packed data or not. 

 

Is this a bug in as400 native driver?

 

Thanks!

 

Bruce
_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo.cgi/java400-l
or email: JAVA400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.