org.springframework.jdbc.UncategorizedSQLException db2

[THEBEST]

org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select trecodeinf0_.TRECODE as TRECODE, trecodeinf0_.TRENAME as TRENAME27_, trecodeinf0_.TRELEVEL as TRELEVEL27_, trecodeinf0_.PAYBANKNO as PAYBANKNO27_, trecodeinf0_.RECKONTRECODE as RECKONTR5_27_, trecodeinf0_.UPTRECODE as UPTRECODE27_, trecodeinf0_.OFPROVTREA as OFPROVTREA27_, trecodeinf0_.OFCITYTREA as OFCITYTREA27_, trecodeinf0_.OFCOUNTYTREA as OFCOUNTY9_27_, trecodeinf0_.OFNODECODE as OFNODECODE27_, trecodeinf0_.ADDRESS as ADDRESS27_, trecodeinf0_.POSTALCODE as POSTALCODE27_, trecodeinf0_.PEOPLENAME as PEOPLENAME27_, trecodeinf0_.PEOPLEPHONE as PEOPLEP14_27_, trecodeinf0_.PEOPLEMOBILE as PEOPLEM15_27_, trecodeinf0_.EMAIL as EMAIL27_, trecodeinf0_.EFFECTFLAG as EFFECTFLAG27_, trecodeinf0_.EFFECTDATE as EFFECTDATE27_, trecodeinf0_.UPDATEAREA as UPDATEAREA27_ from TRECODEINFO trecodeinf0_ where (1=1 )]; SQL state [null]; error code [-99999]; Input length = 15767; nested exception is com.ibm.db2.jcc.b.SqlException: Input length = 15767


Caused by:
java.nio.charset.MalformedInputException: Input length = 15767
at com.ibm.db2.jcc.b.t.a(t.java:19)
at com.ibm.db2.jcc.b.eb.a(eb.java:1631)
... 67 more
Caused by:
sun.io.MalformedInputException
at java.lang.Throwable.<init>(Throwable.java:57)
at sun.io.ByteToCharEUC.convert(ByteToCharEUC.java:194)
at com.ibm.db2.jcc.b.t.a(t.java:16)
... 68 more

用spring,structs,hibernate查询db2数据库中某个表的时候出现这个错误，如果结果记录少的话不会报错，结果记录多的时候就会报这个错，但是另一个环境没这个问题，不知道这个是什么环境上没配置好。请教。。。谢谢。

[qiheia]

当输入字节序列对于给定 charset 来说是不合法的，或者输入字符序列不是合法的 16 位 Unicode 序列时，抛出此经过检查的异常。

[Trinx]

楼主这问题我也遇到过，期待吧！

[THEBEST]

我是查询，能不能说具体点？输入字节序列？只是一个查询语句，没有输入啊，而且是记录多的时候出这个错，少的时候不会有错误。