The following comment has been added to this issue:
Author: Jan Hlavat�
Created: Sun, 10 Oct 2004 1:49 PM
Body:
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 ;)
---------------------------------------------------------------------
View this comment:
http://issues.apache.org/jira/browse/DERBY-37?page=comments#action_53873
---------------------------------------------------------------------
View the issue:
http://issues.apache.org/jira/browse/DERBY-37
Here is an overview of the issue:
---------------------------------------------------------------------
Key: DERBY-37
Summary: detection of incorrect types comparison is done at ? parameters
Type: Bug
Status: Unassigned
Priority: Major
Project: Derby
Assignee:
Reporter: Erik Bengtson
Created: Sun, 10 Oct 2004 1:36 PM
Updated: Sun, 10 Oct 2004 1:49 PM
Environment: Cloudscape 10 beta
Description:
java code:
PreparedStatement ps = conn.prepareStatement(statement);
This statement:
SELECT
THIS.CODE_EID,THIS.COMPOSED_EID,'org.jpox.samples.applicationidentity.ChildComposedIntID'
as JPOXMETADATA ,THIS.INTEGER_IDX AS
JPOXORDER0,ELEMENT_1.CODE,ELEMENT_1.COMPOSED,ELEMENT_1.DESCRIPTION,ELEMENT_1."NAME"
FROM NORMALLISTAPPLICATIONID_COMPOS THIS INNER JOIN CHILDCOMPOSEDINTID
"ELEMENT" ON THIS.CODE_EID = "ELEMENT".CODE AND THIS.COMPOSED_EID =
"ELEMENT".COMPOSED INNER JOIN COMPOSEDINTID ELEMENT_1 ON "ELEMENT".CODE =
ELEMENT_1.CODE AND "ELEMENT".COMPOSED = ELEMENT_1.COMPOSED WHERE
THIS.NORMALLISTAPPLICATIONID_ID_OID = ? AND THIS.INTEGER_IDX >= ? ORDER BY
JPOXORDER0
results in:
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.
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
