please post 1. the criteria query i.e. the output of System.err.println(qDef); it should print a JPQL-like string
2. the SQL generated at execution with bind parameters. OpenJPA will print the SQL if configured as follows <property name="openjpa.Log" value="SQL=TRACE"> <property name="openjpa.ConnectionFactoryProperties" value="PrintParameters=true"/> ----- Pinaki Poddar Chair, Apache OpenJPA Project -- View this message in context: http://openjpa.208410.n2.nabble.com/Ordering-results-obtained-through-query-by-example-tp7584043p7584046.html Sent from the OpenJPA Users mailing list archive at Nabble.com.