I am trying to generate a query using EntityManager.createQuery
for my ORM mapping classes. The resulting query's order by included the primary key field of the class by default even though I have specified two fields to order by in @OrderBy
(sequenceOrderNo asc, nextXpath asc
).
Can anyone advise me how to remove the default primary included in order by clause of the generated query? I have been looking the for a solution for more than 4 days.
I have used below in my project
DB: Oracled 10g openjpa 2.0 jar