[Hibernate-issues] [Hibernate-JIRA] Created: (HB-204) Problem with Query and LIMIT (HSQL)

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

Message:

  A new issue has been created in JIRA.

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

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


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-204
    Summary: Problem with Query and LIMIT (HSQL)
       Type: Bug

     Status: Unassigned
   Priority: Major

    Project: Hibernate2
 Components: 
             core
   Versions:
             2.0.1

   Assignee: 
   Reporter: Sebastien Guimont

    Created: Thu, 17 Jul 2003 9:15 AM
    Updated: Thu, 17 Jul 2003 9:15 AM

Description:
Reference: http://sourceforge.net/forum/message.php?msg_id=2086382

I use HyperSQL 1.7.2 alpha M.

/** Code sampl **/ 
hibernateSession = getSession(session); 

Query hibernateQuery = hibernateSession.createQuery(query); 

for (int i = 0; i < params.length; i++) { 
hibernateQuery.setParameter(i, params[i]); 
} 

hibernateQuery.setFirstResult(startRow); 
hibernateQuery.setMaxResults(resultSize); 
results = hibernateQuery.list(); 

/** Exception **/ 

When I call the list method I got this exception: 

Could not execute query: Wrong data type: LIMIT n m in statement [select limit 'CA' 1 referenceValue.REF_VAL_ID as REF_VAL_ID, referenceValue.CITY_CNTRY_ID as CITY_CN11_, referenceValue.CITY_STATEPROV_ID as CITY_ST12_, referenceValue.UPID as UPID, referenceValue.CD as CD, referenceValue.CREATED as CREATED, referenceValue.CREATED_BY as CREATED_BY, referenceValue.LAST_UPD as LAST_UPD, referenceValue.LAST_UPD_BY as LAST_UPD8_, referenceValue.REF_ORDER as REF_ORDER, referenceValue.DESC_ID as DESC_ID from REF_VAL referenceValue, REF_VAL countryr0_, DESCRIPT descript1_ where referenceValue.TYP='SYS_CITY' and referenceValue.DESC_ID=descript1_.DESC_ID and (((countryr0_.CD=25 and referenceValue.CITY_CNTRY_ID=countryr0_.REF_VAL_ID))) order by descript1_.DEFAULT_DESC asc] 

It looks like the parameters list for the prepared statement are not ordered correctly.


---------------------------------------------------------------------
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