A fix is available
APAR status
Closed as program error.
Error description
When using an AggregateObjectMapping (like an Embeddable) and EclipseLink's Cursor API to get a resultSet, EclipseLink calculates the wrong attribute index in the query, resulting in an exception: java.lang.NumberFormatException: For input string: "fieldName" at org.eclipse.persistence.exceptions.Conve rsionException.couldNotBeConverted(ConversionException.java:93) at org.eclipse.persistence.internal.helper.ConversionManager.con vertObjectToInteger(ConversionManager.java:560) at org.eclipse. persistence.internal.helper.ConversionManager.convertObject(Conv ersionManager.java:131) at org.eclipse.persistence.internal.dat abaseaccess.DatasourcePlatform.convertObject(DatasourcePlatform. java:225) at org.eclipse.persistence.mappings.foundation.Abstra ctDirectMapping.getObjectValue(AbstractDirectMapping.java:625)
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: All users of IBM WebSphere Application * * Server - Java Persistence API - JPA 2.1 & * * EclipseLink * **************************************************************** * PROBLEM DESCRIPTION: Using EclipseLink's QueryHint, * * ´eclipselink.cursor´, with an * * Embeddable results in * * ConversionException thrown * **************************************************************** * RECOMMENDATION: * **************************************************************** When using EclipseLink's org.eclipse.persistence.queries.Cursor API to obtain a result set, EclipseLink calculates the wrong index for @Embeddable attributes. This causes EclipseLink to throw a ConversionException as the wrong index is used. Example: Query query = em.createQuery("SELECT e.mappingField1, e.aggregateObjectMapping FROM SimpleMappingEntity e"); query.setHint(QueryHints.CURSOR, HintValues.TRUE); org.eclipse.persistence.queries.Cursor cursor = (org.eclipse.persistence.queries.Cursor) query.getSingleResult();
Problem conclusion
The fix for this APAR changes the EclipseLink implementation and involves an update to the third-party source. See https://bugs.eclipse.org/bugs/show_bug.cgi?id=471144 This fix is currently targeted for WebSphere Application Server 9.0.5.3 and WebSphere Liberty 19.0.0.11. For more information, see 'Recommended Updates for WebSphere Application Server': http://www.ibm.com/support/docview.wss?rs=180&uid=swg27004980
Temporary fix
Comments
APAR Information
APAR number
PH16920
Reported component name
WEBS APP SERV N
Reported component ID
5724H8800
Reported release
900
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-09-16
Closed date
2020-01-23
Last modified date
2020-01-23
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
WEBS APP SERV N
Fixed component ID
5724H8800
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:
02 November 2021