How to use different implementation for ebean SqlLimiter in playframework

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 ?

+5
source share
1 answer

. , , ServerConfig . ebean, , play.plugins. ServerConfig .

0

All Articles