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

carstenkeuch do-not-reply at jboss.com
Mon Jul 24 04:38:36 EDT 2006


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

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3960259#3960259

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3960259



More information about the jboss-user mailing list