Thanks, Pinaki, that's exactly what I meant by a demonstrated example. A pity that the JEE 6 Tutorial does not have a similar example to your codes - it would have helped tremendously as far as understanding JPA is concerned.
As for the WHERE clause of the query, I'll investigate it further on how to implement it as part of my learning. Also, I have figured out a way to display the @rownum by using Primefaces dataTable's rowIndexVar attribute - so I guess I don't need the @rownum as part of the SQL query anymore. -- View this message in context: http://openjpa.208410.n2.nabble.com/Is-this-possible-with-CriteriaBuilder-method-tp6283183p6297772.html Sent from the OpenJPA Users mailing list archive at Nabble.com.
