It could be related to this other problem from the other day that I have yet to fix "Joined subclass problem".
The sql in the log that is generated is. INFO 2009-03-17 12:49:00,183 27480ms Loader GetResultSet - select author0_.id as id0_, author0_1_.name as name0_, author0_.country as country2_ from author author0_ inner join person author0_1_ on author0_.id=author0_1_.id INFO 2009-03-17 12:49:00,183 27480ms Loader GetResultSet - select author0_.id as id0_, author0_1_.name as name0_, author0_.country as country2_ from author author0_ inner join person author0_1_ on author0_.id=author0_1_.id INFO 2009-03-17 12:49:00,226 27524ms Loader GetResultSet - select borrower0_.id as id0_, borrower0_1_.name as name0_, borrower0_.user_name as user2_1_ from borrower borrower0_ inner join person borrower0_1_ on borrower0_.id=borrower0_1_.id INFO 2009-03-17 12:49:00,226 27524ms Loader GetResultSet - select borrower0_.id as id0_, borrower0_1_.name as name0_, borrower0_.user_name as user2_1_ from borrower borrower0_ inner join person borrower0_1_ on borrower0_.id=borrower0_1_.id On Tue, Mar 17, 2009 at 1:44 PM, Dario Quintana <[email protected]> wrote: > Into your log4net configuration you can paste this to see what actually NH > is generating > > ... > <logger name="NHibernate.SQL"> > <level value="DEBUG" /> > </logger> > ... > > On Mon, Mar 16, 2009 at 11:01 PM, Craig van Nieuwkerk <[email protected]> > wrote: >> >> I am using nHibernate and trying to implement some paging. If I run this >> code >> >> IList list = session.CreateQuery("FROM Author").List(); >> >> it returns 8 records. If I run this code though >> >> IList list = session.CreateQuery("FROM Author") >> .SetFirstResult(1).SetMaxResults(5).List(); >> >> it returns 0 records. When I look at the SQL generated I can't see >> that there is any paging logic. >> >> What is the most likely errors with this? >> >> >> Craig >> >> >> > > > > -- > Dario Quintana > http://darioquintana.com.ar > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
