Hi there,
i'm using dynamic-ql like shown in the jboss doc, section 11.6.5. DynamicQL http://docs.jboss.org/jbossas/jboss4guide/r3/html/ch11.chapter.html#ch11.dynamicql.sect.
At runtime by excecuting the select method a ParseException is thrown. The generated query looks like this:
SELECT OBJECTa) FROM bean AS a WHERE a.number BETWEEN 1 AND 2 AND a.keyOne = 5 AND a.keyTwo IN (?1, ?2, ?3)
Exception sais that: PareseException: Encountered "1" at line 1, column [...] expection one of: [...]
Seems that the parser doesn't like the generated parameters. It's not the 1 from BETWEEN-Statement. Just ruled it out... It'S definitly the first parameter! So whats wrong with this query?
Any ideas?
Best regards, Carsten