[Hibernate-issues] [Hibernate-JIRA] Commented: (HB-137) Error with limit clause using HSQL Dialect, setFirstResult and named parameters

[<leg...@at...>]

The following comment has been added to this issue:

     Author: William Drai
    Created: Sun, 13 Jul 2003 12:25 PM
       Body:
I have seen that you have fixed this problem in the last CVS tree.

Thank you for this.


William

---------------------------------------------------------------------
View the issue:

  http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-137


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-137
    Summary: Error with limit clause using HSQL Dialect, setFirstResult and named parameters
       Type: Bug

     Status: Resolved
   Priority: Minor
 Resolution: WON'T FIX

    Project: Hibernate2
 Components: 
             core
   Versions:
             2.0 final

   Assignee: Gavin King
   Reporter: William Drai

    Created: Mon, 16 Jun 2003 6:50 AM
    Updated: Tue, 17 Jun 2003 1:45 AM

Description:
When using the setFirstResult and setMaxResults on a HSQLDB Query with named parameters, the results is incorrect because the parameters are populated in the wrong order.

In HSQLDialect the limit syntax is 'select limit ? ? xxx from yyy where zzz'
In all other dialects using the limit syntax it is something like 'select xxx from yyy where zzz limit ?, ?'.
The problem is in the method prepareQueryStatement of the class net.sf.hibernate.loader.Loader. The bindPagingSelectParameters is always called after the bindNamedParameters and that does not work with an HSQL statement.




---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.

If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira