[ https://issues.apache.org/jira/browse/OPENJPA-27?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
David Wisneski closed OPENJPA-27. --------------------------------- Resolution: Duplicate duplicate of OPENJPA-22 > SQL Parameter markers generated for literals causes DB2 SQL error SQLCODE > -417(SQLSTATE 42609), 418(SQLSTATE 42610) > ------------------------------------------------------------------------------------------------------------------- > > Key: OPENJPA-27 > URL: https://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. - You can reply to this email to add a comment to the issue online.