You can use a custom string type handler.
--
Cheers,
Gilles
Hey all,
I would like to share you guys this problem im getting constantly by using
Ibatis via jdbc to do queries on DB2...
Let's say we have written a simple query like this
SELECT PCT_SCO_MAX,
FROM$schema$.FLES_PERC_SCO
WHERE COD_COMPANY = #codCompany#
I can assure you, it's not iBATIS doing that... iBATIS does not translate
any values. So your JDBC driver is the problem here, and it appears you've
found a way for iBATIS to solve it. I've known other drivers to do the same
thing. I belive NULL and '' are equal in Sybase/SQL Server as well...
yea with a typeHandler like this i cen get through the problem
public Object getResult(CallableStatement cs, int columnIndex)
throws SQLException {
Object s = cs.getString(columnIndex);
if(cs.wasNull())
return Constants.
