Pagination with SqlRow

[kryptos]

Hi guys,

I can't paginate my query result with a SqlRow.. but an entity bean..
so I'm wondering how can I paginate my result with a sqlRow type, if
possible.

Regards

[Rob Bygrave]

No, Ebean doesn't have a feature to page result with a SqlQuery (returning SqlRow's) unfortunately.  That sounds like a feature request. Hmmm.

You could look to use com.avaje.ebean.RawSql with a entity bean as an alternative option.

Cheers, Rob.

[kryptos]

Thanks, I'll see RawSql.. but I found others solution here in the
forum..
1. Using RawSql (as you mention).
2. Using SqlRow and transform it to a defined custom entity.
3. @SqlSelect

Regards and thanks!.

On May 16, 6:27 pm, Rob Bygrave <robin.bygr...@gmail.com> wrote:
> No, Ebean doesn't have a feature to page result with a SqlQuery (returning
> SqlRow's) unfortunately.  That sounds like a feature request. Hmmm.
>
> You could look to use com.avaje.ebean.RawSql with a entity bean as an
> alternative option.
>
> Cheers, Rob.
>