[nhibernate-issues] [JIRA] Updated: (NH-837) Error using Limits with DB2400Dialect

[NHibernate J. <mik...@us...>]

     [ http://jira.nhibernate.org/browse/NH-837?page=all ]

Sergey Koshcheyev updated NH-837:
---------------------------------

    Fix Version: 1.2.0.Beta3
       Priority: Minor  (was: Major)

> Error using Limits with DB2400Dialect
> -------------------------------------
>
>          Key: NH-837
>          URL: http://jira.nhibernate.org/browse/NH-837
>      Project: NHibernate
>         Type: Bug
>   Components: Data Providers
>     Versions: 1.2.0.Beta2
>     Reporter: Christophe Vigouroux
>     Priority: Minor
>      Fix For: 1.2.0.Beta3

>
> Using with DB2400Dialect :
> query.SetFirstResult(startRow);
> query.SetMaxResults(maxRows);
> IList<Core.Imprimante> retour = query.List<Core.Imprimante>();
> results in the generation of the following SQL statement :
> select * from (select rownumber() over() as rownum, this_.CDIMPLOG as CDIMPLOG0_0_, this_.CDSOC as CDSOC0_0_, this_.LBIMP as LBIMP0_0_ FROM TIMPRIM this_) as tempresult where rownum <= ?
> This statement is for use with DB2 UDB, but not compatible with DB2 for iSeries.
> The statement should use RRN(table) instead of rownumber() and use "fetch first n rows" instead of over().
> DB2400Dialect should override GetLimitString of DB2Dialect to provide with functionality.
> Thanks for your support !

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.nhibernate.org/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira