[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-912) Use of DetachedCriteria
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-912?page=co...
]
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira