[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-3972) Adding FETCH FIRST and OFFSET support to DerbyDialect

[Evan Leonard (JIRA)]

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

Evan Leonard commented on HHH-3972:
-----------------------------------

Its possible to test for the version of the loaded derby driver. See the static methods on this class:

http://developers.sun.com/docs/javadb/10.5.1.1/javadoc/jdbc4/org/apache/derby/tools/sysinfo.html

While this is the doc for 10.5.1.1 the sysinfo class has been part of derby since 10.1.2.1:

http://db.apache.org/derby/releases/release-10.1.2.1.html.new

Also, here's the reference to the Derby bug for the FETCH FIRST and OFFSET clauses: 

https://issues.apache.org/jira/browse/DERBY-4079

> Adding FETCH FIRST and OFFSET support to DerbyDialect
> -----------------------------------------------------
>
>                 Key: HHH-3972
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3972
>             Project: Hibernate Core
>          Issue Type: Patch
>          Components: core
>    Affects Versions: 3.2.0.ga, 3.3.1
>            Reporter: Evan Leonard
>            Assignee: Steve Ebersole
>             Fix For: 3.2.x, 3.3.x, 3.5
>
>         Attachments: Added_FETCH_FIRST_and_OFFSET_support_to_Derby_Dialect.patch
>
>
> I've add support to the DerbyDialect for its recent addition of a limit clause [1].
> Attached is a patch for this addition. 
> Thank you,
> Evan Leonard
> [1] - http://db.apache.org/derby/docs/10.5/ref/rrefsqljoffsetfetch.html

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