Probably you are not using the right dialect for the Oracle version you are using. btw you are even using an old version of NH (probably 2.0) because that dialect was removed.
2009/11/30 江名峰 <[email protected]> > Hi fabio maulo > > my web.config like: > <hibernate-configuration xmlns="urn:nhibernate-configuration-2.2"> > <session-factory> > > <property > name="dialect">NHibernate.Dialect.OracleDialect</property> > <property > name="connection.provider">NHibernate.Connection.DriverConnectionProvider</property> > > <property > name="connection.driver_class">NHibernate.Driver.OracleClientDriver</property> > <property name="connection.connection_string">User ID=user > id;Password=pas;Data Source=ndwf</property> > <property > name="proxyfactory.factory_class">NHibernate.ByteCode.Castle.ProxyFactoryFactory, > NHibernate.ByteCode.Castle</property> > </session-factory> > </hibernate-configuration> > > and there is no exceptions, I have 10 records in DB, and set page size as > 2,it can return the first page,but other pages are empty: > > > IQuery query = DataSession.CreateQuery(m_defaultSelectCommand); > query.SetMaxResults(2); > query.SetFirstResult(0);// return first page with 2 > rows(index:0 to 1). > > ------------------------------------------------------------------------------------------------------------- > > IQuery query = DataSession.CreateQuery(m_defaultSelectCommand); > query.SetMaxResults(2); > query.SetFirstResult(2);// return empty . > > > > > 2009/11/29 Fabio Maulo <[email protected]> > > exception ? OracleDriver ? OracleDialect ? >> >> 2009/11/29 江名峰 <[email protected]> >> >>> Dear all >>> >>> how to do paging on oracle database with NHibernate ? >>> >>> I have a solution to do paging on MSSQL database like : >>> IQuery query = DataSession.CreateQuery(m_defaultSelectCommand); >>> query.SetMaxResults(maximumRows); >>> query.SetFirstResult(startRowIndex); >>> >>> but it does not work on oracle database. >>> >>> -- >>> 江名峰(James.Jiang) >>> msn：[email protected] >>> >>> -- >>> 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]<nhusers%[email protected]> >>> . >>> For more options, visit this group at >>> http://groups.google.com/group/nhusers?hl=en. >>> >> >> >> >> -- >> Fabio Maulo >> >> >> -- >> 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]<nhusers%[email protected]> >> . >> For more options, visit this group at >> http://groups.google.com/group/nhusers?hl=en. >> > > > > -- > 江名峰(James.Jiang) > msn：[email protected] > > -- > 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]<nhusers%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > -- Fabio Maulo -- 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.
