Hello,

I am getting following exception.

Its bit urgent any help will be appreciated.

Caused by: com.ibm.db2.jcc.b.eo: The data types of the operands for the operation "=" are not compatible.. SQLCODE=-401, SQLSTATE=42818, DRIVER=3.53.95
at com.ibm.db2.jcc.b.bd.a(bd.java:676)
at com.ibm.db2.jcc.b.bd.a(bd.java:60)
at com.ibm.db2.jcc.b.bd.a(bd.java:127)
at com.ibm.db2.jcc.b.gm.c(gm.java:2484)
at com.ibm.db2.jcc.b.gm.d(gm.java:2461)
)at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement. setObject(WSJdbcPreparedStatement.java:2363)
at com.sun.sql.rowset.internal.CachedRowSetXReader.de codeParams(CachedRowSetXReader.java:508)
at com.sun.sql.rowset.internal.CachedRowSetXReader.re adData(CachedRowSetXReader.java:177)
at com.sun.sql.rowset.CachedRowSetXImpl5.execute(Cach edRowSetXImpl5.java:865)


Thanks in advance

I think the error says it all. You are trying to compare two values that the data types are not comparable. Like a DATE to an INTEGER, or a CHAR to an INTEGER.

Andy