[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Dynamic QL - IN-Statement

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..... 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 View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3960259#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...