Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2009
    Posts
    16

    Unanswered: The data types of the operands for the operation "<operator>" are not compatible.

    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

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •