This discussion is archived
2 Replies Latest reply: May 23, 2013 6:29 AM by JamesSutherland RSS

Getting JPA query parsing error during parsing the subquery

1009778 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points