On 6/25/07, Eelco Hillenius <[EMAIL PROTECTED]> wrote: > > On Monday, June 25, 2007, 9:54:58 PM, Landry <[EMAIL PROTECTED]> wrote: > > > > > A problem remains, however : i don't know how to implement > > > IDataProvider.iterator(int first, int count). > > > Must be something like this in oracle : "select * from mytable where > > rownum>>=first and rownum <count " > > > > Actually, in Oracle, it's significantly more complex than the above, > > but let's not go there (unless you're actually doing that in Oracle?). > > > > > But how to do this in mysql ? (row_id could do the thing, but it is only > > > available when your primary key is integer). > > > > I've not used MySQL for years, but I think it's > > select * from mytable order by whatever limit first, count > > where 'first' is from 0. > > If you are using an ORM tool (JPA, Hibernate, JDO) the tool might do > specific optimizations for you. But I think what most people (/ > implementations) do is just scroll the result set cursor to the first > record needed. > > Eelco
In Hibernate, and more widely in JPA, you use setFirstResult() setMaxResults() on your query. ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Wicket-user mailing list Wicket-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wicket-user
