2 Replies Latest reply: May 23, 2013 8:29 AM by JamesSutherland RSS

    Getting JPA query parsing error during parsing the subquery

    1009778
      StringBuffer query = new StringBuffer();
      query
      .append("SELECT e FROM DBMGPersonMetaData e WHERE e.moduleUniqueId.extension= ?1 AND e.ConsType ");
      query
      .append("IN ( SELECT CASE WHEN " +
      "INSTR(p.description, ' ') =0 "
      + " THEN SUBSTR(p.description,1) "
      + " WHEN INSTR(p.description, ' ') !=0 "
      + " THEN SUBSTR(p.description,1,INSTR(p.description, ' ')-1) END"
      + " AS ee FROM DBProjectMetaData p WHERE p.projectUniqueId.extension= ?2");
      dbModuleperson = (DBMGPersonMetaData) entityManager.createQuery(
      query.toString()).setParameter(1,"12").setParameter(2,"123").getSingleResult

      Edited by: 1006775 on May 19, 2013 11:11 AM