This content has been marked as final. Show 2 replies
It would help if you showed the exception, as they usually point out where in the string it has a problem parsing. I can't tell anything about your query, but "INSTR" stands out since it is not a JPQL key word and I'm not familiar with it.
INSTR is not part of JPQL, you need to use the FUNC() or FUNCTION() operator to call this.