[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-912) Use of DetachedCriteria

[Steve Van Reeth (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-912?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=31930#action_31930 ] 

Steve Van Reeth commented on HHH-912:
-------------------------------------

I have the same problem: for performance purpose, I have to do this:

SELECT this_.ID AS id33_0_, this_.in_record_id AS in2_33_0_,
       this_.created_ts AS created3_33_0_, this_.ext_app_id AS ext4_33_0_,
       this_.file_id AS file8_33_0_, this_.line_number AS line5_33_0_,
       this_.linked_ts AS linked6_33_0_, this_.status_id AS status7_33_0_
  FROM myschema.ext_in_record this_
 WHERE this_.ID IN (SELECT ID
                      FROM (SELECT   ID
                                FROM myschema.ext_in_record
                               WHERE status_id = 0
                            ORDER BY ID)
                     WHERE ROWNUM < = 500);

It's impossible to do with Criteria in Hibernate 3.2.6.

> Use of DetachedCriteria
> -----------------------
>
>                 Key: HHH-912
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-912
>             Project: Hibernate Core
>          Issue Type: Improvement
>          Components: core
>    Affects Versions: 3.0.5
>         Environment: All
>            Reporter: Frank Verbruggen
>            Priority: Minor
>
> The class org.hibernate.criterion.DetachedCriteria should represent a criteria object on which all the operations available to a Criteria object that do NOT require a Session object are available.
> Two such operations are setFirstResult() and setMaxResults().
> These are unfortunately enough not available.
> There probably are more methods missing that need to be added but these two in particular are important to me.
> See http://opensource2.atlassian.com/projects/spring/browse/SPR-1254.
> Can they be added in the next release ?
> Kind regards
> Frank Verbruggen

-- 
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
-
For more information on JIRA, see: http://www.atlassian.com/software/jira