0 Replies Latest reply on Jul 24, 2006 4:38 AM by carstenkeuch

    Dynamic QL - IN-Statement

    carstenkeuch

      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