Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 323897

Summary: Add support for sequences (Derby)
Product: z_Archived Reporter: Andre Bargull <andrebargull+eclipse>
Component: EclipselinkAssignee: James Sutherland <jamesssss>
Status: RESOLVED FIXED QA Contact:
Severity: enhancement    
Priority: P3 CC: jamesssss, tom.ware
Version: unspecifiedFlags: jamesssss: iplog+
Target Milestone: ---   
Hardware: All   
OS: All   
Whiteboard: submitted_patch
Attachments:
Description Flags
Simple subclass of DerbyPlatform with sequence support jamesssss: iplog+

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