Hi all,

I'm active in the Apache Derby community where I'm currently working on adding the ROW_NUMBER() rank function, the SQL standard equivalent to MYSQLs dialect 'LIMIT' and 'OFFSET' functionality. I've seen the use of the ROW_NUMBER() approach to LIMIT on the Hibernate forums, and I want to make sure that the SQL standard solution is sufficient for Hibernate use(rs)?

The reason for doing this is to (hopefully) give the Hibernate + Derby/JavaDB combo a nice performance boost with pagination type queries using HQLs Query.setFirstResult() and Query.setMaxResults(). There is currently no plan to implement the mysql dialects "LIMIT" and "OFFSET" in Derby/JavaDB, but adding this could be raised to the Derby community for discussion if needed.

BTW, apart from row_number(), and possibly sequences, are there any other issues with Derby/JavaDB that you'd like to see fixed in future releases of Derby/JavaDB?

If there is another, more appropriate, forum where this should be posted please let me know.

Thomas