This Bugzilla instance is deprecated, and most Eclipse projects now use GitHub or Eclipse GitLab. Please see the deprecation plan for details.
Bug 323897 - Add support for sequences (Derby)
Summary: Add support for sequences (Derby)
Status: RESOLVED FIXED
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: Eclipselink (show other bugs)
Version: unspecified   Edit
Hardware: All All
: P3 enhancement (vote)
Target Milestone: ---   Edit
Assignee: James Sutherland CLA
QA Contact:
URL:
Whiteboard: submitted_patch
Keywords:
Depends on:
Blocks:
 
Reported: 2010-08-28 21:16 EDT by Andre Bargull CLA
Modified: 2022-06-09 10:08 EDT (History)
2 users (show)

See Also:
jamesssss: iplog+

Attachments
Simple subclass of DerbyPlatform with sequence support (997 bytes, patch)
2010-08-28 22:07 EDT, Andre Bargull CLA 		jamesssss: iplog+
Details | Diff
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Andre Bargull CLA 2010-08-28 21:16:26 EDT 
Build Identifier: 2.1.1.v20100817-r8050

Derby 10.6.1.0 added support for sequence objects [1], to enable this feature for JPA in EclipseLink, org.eclipse.persistence.platform.database.DerbyPlatform needs to be updated. In addition to #supportsSequenceObjects(), #isAlterSequenceObjectSupported() and #buildSequenceObjectDeletionWriter(Writer, String) must be implemented in DerbyPlatform. 


[1] https://issues.apache.org/jira/browse/DERBY-712

Reproducible: Always
Comment 1 Andre Bargull CLA 2010-08-28 22:07:20 EDT 
Created attachment 177669 [details]
Simple subclass of DerbyPlatform with sequence support
Comment 2 James Sutherland CLA 2011-01-26 11:09:58 EST 
Thank you for the submission, adding to 2.3/trunk.
Comment 3 James Sutherland CLA 2011-01-27 10:11:53 EST 
SVN commit, trunk: BUG#323897, 335464 - Derby pagination and sequencing

https://bugs.eclipse.org/bugs/show_bug.cgi?id=323897

Adds pagination and sequencing support to DerbyPlatform.  Thank you to A. Bargull for submitting the Derby sequencing patch.

Changes:
- Added sequence support for Derby (Derby added this as of 10.6) *** You must upgrade to Derby 10.6 or greater to run tests that use sequencing successfully.
- Added pagination support for Derby.
- Added fix to rollbackTransaction, was causing Derby test failures.
- Added fix to unwrapping JDBC Connection in JPA to support external connection pooling.

Code Review: Andrei (pending)
Comment 4 Eclipse Webmaster CLA 2022-06-09 10:08:48 EDT 
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink