> Another issue. > I found that the "limit" and "offset" methods accept > only a simple integer as parameter (not a Field) so it's impossible to > set the limit as > a named param. > > There's some way to get that, or It will be implemented some day ???
This is implemented on SVN trunk and on GitHub: https://sourceforge.net/apps/trac/jooq/ticket/1129 Integration tests run smoothly for any of these SQL dialects: DB2, Derby, H2, HSQLDB, MySQL, Oracle, Postgres, SQLite, SQL Server, Sybase SQL Anywhere Some dialects need simulation of LIMIT / TOP clauses using ROW_NUMBER() filtering, when bind variables are involved These databases do not support any means (or workaround) to use bind values in LIMIT / TOP clauses: Ingres, Sybase ASE This is documented in the API Cheers Lukas
