SQL Exception: Comparisons between 'VARCHAR' and 'INTEGER' are not supported.

possible cause:

The INTEGER_IDX is an INTEGER column. While running the prepareStatement, JDBC/Cloudscape thinks I'm comparing INTEGER_IDX with ? (question mark) (INTEGER vs VARCHAR). This is not true, ? (question mark) is a parameter that will be later substitued in my code by an integer value.

Activity

If this is the whole error message then error reporting in Derby needs an overhaul I hate error messages of the type "Some error occured, but you have to guess what it is".

Are you sure its not something else? It's hard for us to tell without all the tables we don't have. Did you try removing the part with ? params? If you could strip the statement down to something reproducible on our side, it would help

Jan Hlavatý
added a comment - 10/Oct/04 21:49 If this is the whole error message then error reporting in Derby needs an overhaul I hate error messages of the type "Some error occured, but you have to guess what it is".
Are you sure its not something else? It's hard for us to tell without all the tables we don't have. Did you try removing the part with ? params? If you could strip the statement down to something reproducible on our side, it would help

Daniel John Debrunner
added a comment - 24/Sep/05 13:58 Should this be resolved as 'cannot reproduce'? Unless the sql definitions for the tables involved in the original query are supplied I don't see any way to move forward on this.