I am using ebean as ORM and SQL Server in reverse order. While trying to setMaxRows, I got an SQL syntax error exception. The generated sql has something like
select .... from ... where ... LIMIT 5
while this might work for mysql, he doesn't like SQLServer.
After some searching, I found that the default SqlLimiter used by EBean, LimitOffsetSqlLimiter, creates sql like this. I am wondering if I can configure ebean so that it can use another implementation, such as RowNumberSqlLimiter, or even my own implementation, as mentioned here ?
source
share