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

Bug 294971

Summary: Aliased column names result in ORA-00972 - identifer is too long
Product: z_Archived Reporter: Richard Wood <richard.m.wood>
Component: EclipselinkAssignee: Nobody - feel free to take it <nobody>
Status: CLOSED DUPLICATE QA Contact:
Severity: normal    
Priority: P3 CC: gordon.yorke, tom.ware
Version: unspecified   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Whiteboard:

Description Richard Wood CLA 2009-11-12 09:36:17 EST 
User-Agent:       Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; i-NavFourF; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)
Build Identifier: 1.2.0.v20091016-r5565

This bug has been reported before, but for older versions of Eclipselink.
And it has not been fixed yet. https://bugs.eclipse.org/bugs/show_bug.cgi?id=262923

The workaround to switch of Oracle rownumfiltering is not really acceptable as it disables the ability for the Oracle database to return only the required rows.

The naming algorithm for aliases needs to be extended to provide distinct names with a maximum length of 30 characters.



Reproducible: Always

Steps to Reproduce:
1. See https://bugs.eclipse.org/bugs/show_bug.cgi?id=262923
2.
3.
Comment 1 Gordon Yorke CLA 2009-11-19 10:47:46 EST 

*** This bug has been marked as a duplicate of bug 262923 ***
Comment 2 Tom Ware CLA 2009-11-19 11:13:24 EST 
Note: The bug has been marked a duplicate because the fix for this issue was checked into our 1.2 stream after 1.2 shipped.  this issue should be fixed in all our upcoming releases.  (2.0, and 1.2.1) and is already fixed in 1.1.3
Comment 3 Eclipse Webmaster CLA 2022-06-09 10:17:15 EDT 
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink
Comment 4 Eclipse Webmaster CLA 2022-06-09 10:29:36 EDT 
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink