openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Catalina Wei (JIRA)" <j...@apache.org>
Subject [jira] Created: (OPENJPA-27) SQL Parameter markers generated for literals causes DB2 SQL error SQLCODE -417(SQLSTATE 42609), 418(SQLSTATE 42610)
Date Mon, 21 Aug 2006 18:59:13 GMT
SQL Parameter markers generated for literals causes DB2 SQL error SQLCODE -417(SQLSTATE 42609),
418(SQLSTATE 42610)
-------------------------------------------------------------------------------------------------------------------

                 Key: OPENJPA-27
                 URL: http://issues.apache.org/jira/browse/OPENJPA-27
             Project: OpenJPA
          Issue Type: Bug
          Components: query
            Reporter: Catalina Wei


over usage of parameter markers for LITERALS causes DB2 SQL errors.
Literals in the JP query if generated 'as is' in the pushdown SQL, can avoid DB2 SQL errors.
Simple predicates caused DB2 SQL errors: 
    where substring(e.name, 1, 5) = 'Harry'
   where mod(e.empid, 2) > 0

-- 
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

        

Mime
View raw message