LIMIT and TOP command are not supported by Sybase version < 15 Why not to use SET ROWCOUNT function instead. Here is a patched version of SybaseDialect. I tested it on an application with paged results and it improved a lot the performances.