[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-3391) DerbyDialect should support limits

[Evan Leonard (JIRA)]

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

Evan Leonard commented on HHH-3391:
-----------------------------------

Just ran into a situation where we needed this. Have big databases in production (some derby) that we have to prune, and we can't run a select through hibernate. When we try hibernate doesn't limit the number of rows returned, so derby tries to grab all of them, which practically speaking, takes forever - as in never returns.  Please consider adding this soon.

Thank you,
Evan

> DerbyDialect should support limits
> ----------------------------------
>
>                 Key: HHH-3391
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3391
>             Project: Hibernate Core
>          Issue Type: New Feature
>          Components: core
>         Environment: Apache Derby 10.4.1.3
>            Reporter: Marijo
>
> From Apache Derby FAQ http://db.apache.org/derby/faq.html#limit
> "Starting with the 10.4.1.3 release Derby also supports limiting the number of rows using the ROW_NUMBER function."
> The DerbyDialect class should support limiting for the actual Derby release, too.

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