We are using hibernate 3. I am using jdbc 3 sqljdb.jar file and seam entity query api.

I am using pagination on server side to talk to sql server 2005. The queries being fired look like-



But I have read in other forums, hibernate and sql server now supports row_num() function, so the sql query being fired should use row_num() but it is not using instead it is top which is really inefficient.

Please clarify me here if hibernate supports row_num function or not, if yes which version, so I can check it out.

Thanks

Any one here to reply?