Jaydebeapi giving error in python for CharConversionException

Question

Getting CharConversionException in python Jaydebeapi when trying to pull data ? Not sure where how to set db2.jcc.charsetDecoderEncoder property in python to resolve this.

Exact error - com.ibm.db2.jcc.am.SqlException: com.ibm.db2.jcc.am.SqlException: [jcc][t4][1065][12306][4.25.13] Caught java.io.CharConversionException. See attached Throwable for details. ERRORCODE=-4220, SQLSTATE=null

Please help in setting charsetDecoderEncoder property in python. Thanks in advance!

Which exact jre/jdk are you using? – mao Sep 02 '20 at 07:49 — mao, Sep 02 '20 at 07:49
java version "14.0.1" – Shashank Srivastava Sep 03 '20 at 11:36 — Shashank Srivastava, Sep 03 '20 at 11:36

F Rowe · Answer 1 · 2020-09-02T01:13:41.573

0

Since you've tagged this with WebSphere, I assume you're trying to use wsadmin to invoke a jython script, if so do something like wsadmin -D<propName>=<propValue> -f myJythonScript.py.

edited Sep 02 '20 at 01:13

answered Sep 01 '20 at 22:19

F Rowe

2,042
1
11
12

then just add the -D part to the command line where you invoke the python script. – F Rowe Sep 02 '20 at 12:41
This did not helped. – Shashank Srivastava Sep 04 '20 at 11:15
python script.py -D db2.jcc.charsetDecoderEncoder=3 – Shashank Srivastava Sep 10 '20 at 04:38

Jaydebeapi giving error in python for CharConversionException

1 Answers1