ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Hugh Ross <hh4r...@gmail.com>
Subject Re: z/os DB2 V9 JDBC ibatis SQLCODE = -20210
Date Tue, 20 Apr 2010 13:33:31 GMT
iBatis/JDBC is all dynamic SQL -- at least not static in the DB2 sense.

>From a DB2 doc on SQLSTATE 560B8:

The SQL statement cannot be executed because it was precompiled at a
level that is incompatible with the current value of the ENCODING bind
option or special register.

I believe the term "precompiled" above can be interpreted as
"prepared" from the JDBC point of view.  On the other hand, the DB2
JDBC drivers do use some packages (e.g., SYSLN200) to handle dynamic
SQL.

So, I'd guess a problem with ENCODING or binding of DB2-supplied packages.

Hope that helps...

---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org


Mime
View raw message