APAR status
Closed as program error.
Error description
EclipseLink ignores @AttributeOverride values on @ElementCollections if the @Column value is lowercase. This effects both JPQL and schema generation where the SQL doesn't match the expected attribute overrides.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All users of IBM WebSphere Application * * Server * **************************************************************** * PROBLEM DESCRIPTION: EclipseLink SQL and DDL generation * * ignores @AttributeOverride values * * when the overridden columns are lower * * case * **************************************************************** * RECOMMENDATION: * **************************************************************** EclipseLink's SQL and DDL generation will ignore @AttributeOverride values and generate statements that are unexpected. Example: ´´´ @Entity public class WealthyPerson { @Id protected String ssn; @ElementCollection @CollectionTable(name = "HOMES") // use default join column name @AttributeOverrides({ @AttributeOverride(name = "street", column = @Column(name = "home_street")) }) protected Set<Address> vacationHomes; } @Embeddable public class Address { @Column(name="du_street") protected String street; } ´´´ With this mapping, EclipseLink is generating DDL and JPQL that include the column name ´du_street´ instead of the column override ´home_street´.
Problem conclusion
The fix for this APAR changes the EclipseLink implementation and involves an update to the thirdparty source. See https://bugs.eclipse.org/bugs/show_bug.cgi?id=564260 This fix is currently targeted for WebSphere Application Server 9.0.5.7 and WebSphere Liberty 20.0.0.12. For more information, see 'Recommended Updates for WebSphere Application Server': https://www.ibm.com/support/pages/node/715553
Temporary fix
Comments
APAR Information
APAR number
PH29809
Reported component name
WEBSPHERE APP S
Reported component ID
5724J0800
Reported release
900
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-09-24
Closed date
2020-11-17
Last modified date
2020-11-17
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
WEBSPHERE APP S
Fixed component ID
5724J0800
Applicable component levels
R900 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.0","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
01 November 2021