db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From derby-...@db.apache.org
Subject [jira] Commented: (DERBY-37) detection of incorrect types comparison is done at ? parameters
Date Sun, 10 Oct 2004 20:49:51 GMT
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


Mime
View raw message