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].
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en.
