[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-3972) Adding FETCH FIRST and OFFSET support to DerbyDialect
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3972?page=c...
]
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/d...
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira