You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Daniel John Debrunner (JIRA)" <de...@db.apache.org> on 2005/09/24 05:59:31 UTC
[jira] Commented: (DERBY-37) detection of incorrect types comparison is done at ? parameters
[ http://issues.apache.org/jira/browse/DERBY-37?page=comments#action_12330338 ]
Daniel John Debrunner commented on DERBY-37:
--------------------------------------------
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.
> detection of incorrect types comparison is done at ? parameters
> ---------------------------------------------------------------
>
> Key: DERBY-37
> URL: http://issues.apache.org/jira/browse/DERBY-37
> Project: Derby
> Type: Bug
> Components: SQL
> Environment: Cloudscape 10 beta
> Reporter: Erik Bengtson
>
> 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.
--
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
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira