[OPENJPA-27] SQL Parameter markers generated for literals causes DB2 SQL error SQLCODE -417(SQLSTATE 42609), 418(SQLSTATE 42610)

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Component/s: query
• Assignee: Unassigned
• Reporter: Catalina Wei
• Created: 21/Aug/06 18:57
• Updated: 01/Feb/07 01:18
• Resolved: 01/Feb/07 01:18

Description

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