it blows up with an invalid character oracle error, which it's complain about the percent sign being in the query. I've tried escaping it and doing all sorts of stuff to try and get it to work ...

Describe the bug The entity manager produces incorrect queries for Oracle when given valid JPQL. Below I have code and logs of 3 different examples of this behavior. To reproduce Steps/resources to ...

Developers can use the ORDER SIBLINGS BY feature of Oracle 10g and later to sort the records in a hierarchy created by the START WITH and CONNECT BY clauses in a SELECT statement.