4:30 p.m.
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.3.1, 3.2.0.ga
Reporter: Evan Leonard
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
9:30 p.m.
New subject: [Hibernate-JIRA] Updated: (HHH-3972) Adding FETCH FIRST and OFFSET support to DerbyDialect
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3972?page=c...
]
Steve Ebersole updated HHH-3972:
--------------------------------
Assignee: Steve Ebersole
Fix Version/s: 3.5
3.3.x
3.2.x
Requires Release Note: (was: [Affirmative])
Will take a look, thanks..
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
1:52 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3972) Adding FETCH FIRST and OFFSET support to DerbyDialect
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3972?page=c...
]
Steve Ebersole commented on HHH-3972:
-------------------------------------
The first step is to decide when we want to drop "support" for pre-10.5
versions.
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
3:31 p.m.
New subject: [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
3:38 p.m.
New subject: [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:
-----------------------------------
One more note: Its would be possible for the DerbyDialect to detect the derby version by
doing something like this:
import org.apache.derby.tools.sysinfo;
....
private int driverVersionMajor;
private int driverVersionMinor;
loadDriverVersion
{
driverVersionMajor = sysinfo.getMajorVersion()
driverVersionMinor = sysinfo.getMinorVersion()
}
....
This would require v10.1.2.1. Wrapping the calls to sysinfo in a try
catch(NoClassDefFoundError e) could preserve further backward compatibility.
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
3:59 p.m.
New subject: [Hibernate-JIRA] Updated: (HHH-3972) Adding FETCH FIRST and OFFSET support to DerbyDialect
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3972?page=c...
]
Evan Leonard updated HHH-3972:
------------------------------
Attachment: Derby_Dialect_FETCH_FIRST_and_OFFSET_support_with_back_compat_.patch
Here's a patch that should only use the FETCH FIRST and OFFSET query syntax if the
Derby driver version loaded is 10.5 or greater.
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,
Derby_Dialect_FETCH_FIRST_and_OFFSET_support_with_back_compat_.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
3:08 p.m.
New subject: [Hibernate-JIRA] Updated: (HHH-3972) Adding FETCH FIRST and OFFSET support to DerbyDialect
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3972?page=c...
]
Steve Ebersole updated HHH-3972:
--------------------------------
Fix Version/s: (was: 3.3.2)
3.3.x
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,
Derby_Dialect_FETCH_FIRST_and_OFFSET_support_with_back_compat_.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
7:26 a.m.
New subject: [Hibernate-JIRA] Updated: (HHH-3972) Adding FETCH FIRST and OFFSET support to DerbyDialect
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3972?page=c...
]
Steve Ebersole updated HHH-3972:
--------------------------------
Fix Version/s: (was: 3.5.0.Beta-1)
3.5-tmp
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,
Derby_Dialect_FETCH_FIRST_and_OFFSET_support_with_back_compat_.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
10:51 a.m.
New subject: [Hibernate-JIRA] Closed: (HHH-3972) Adding FETCH FIRST and OFFSET support to DerbyDialect
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3972?page=c...
]
Steve Ebersole closed HHH-3972.
-------------------------------
Resolution: Fixed
Fix Version/s: (was: 3.3.x)
(was: 3.2.x)
I applied a slightly modified version of this. Thanks Evan.
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.5
Attachments: Added_FETCH_FIRST_and_OFFSET_support_to_Derby_Dialect.patch,
Derby_Dialect_FETCH_FIRST_and_OFFSET_support_with_back_compat_.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
1:12 p.m.
New subject: [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:
-----------------------------------
Great. Thanks Steve!
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.5
Attachments: Added_FETCH_FIRST_and_OFFSET_support_to_Derby_Dialect.patch,
Derby_Dialect_FETCH_FIRST_and_OFFSET_support_with_back_compat_.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
5537
days inactive
5669
days old
hibernate-issues@lists.jboss.org
9 comments
2 participants
participants (2)
-
Evan Leonard (JIRA) -
Steve Ebersole (JIRA)