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

Bug 328972

Summary: Three jpa complexaggregate tests failed with java.sql.SQLSyntaxErrorException: ORA-00904: "JERSEYNUMBER": invalid identifier
Product: z_Archived Reporter: Yiping Zhao <yiping.zhao>
Component: EclipselinkAssignee: Nobody - feel free to take it <nobody>
Status: RESOLVED FIXED QA Contact:
Severity: normal    
Priority: P3 CC: eclipselink.orm-inbox, guy.pelletier
Version: unspecified   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Whiteboard:
Attachments:
Description Flags
Proposed changes none

Description Yiping Zhao CLA 2010-10-28 16:06:57 EDT 
You can see the same test failures in Nightly Build JPA Test results here:

http://download.eclipse.org/rt/eclipselink/nightly/2.2.0/20101028/Eclipse/eclipselink-jpa-lrg-2.2.0.v20101028-r8429.html

The failed tests and errors:

1. org.eclipse.persistence.testing.tests.jpa.complexaggregate.NestedAggregateTest.NestedAggregateTest
2. org.eclipse.persistence.testing.tests.jpa.complexaggregate.AggregateReadOnlyMapKeyTest.AggregateReadOnlyMapKeyTest
3. org.eclipse.persistence.testing.tests.jpa.complexaggregate.ComplexAggregateJoin.ComplexAggregateJoin

Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00904: "JERSEYNUMBER": invalid identifier Error Code: 904 Call: SELECT PLAYERID, FNAME, LNAME, AGE, HEIGHT, WEIGHT, JERSEYNUMBER, PLAYER_POSITION, TEAM_ID, COACH_ID FROM CMP3_HOCKEY_PLAYER WHERE (TEAM_ID = ?) bind => [1] Query: ReadAllQuery(name="players" referenceClass=HockeyPlayer sql="SELECT PLAYERID, FNAME, LNAME, AGE, HEIGHT, WEIGHT, JERSEYNUMBER, PLAYER_POSITION, TEAM_ID, COACH_ID FROM CMP3_HOCKEY_PLAYER WHERE (TEAM_ID = ?)")

Note: The changes except those JAXB ones between 8409 and 8429 are:

SVN Changes since Last Build:
------------------------------------------------------------------------
r8429 | egwin | 2010-10-27 23:24:55 -0400 (Wed, 27 Oct 2010)
Changed paths:
   M /trunk/foundation/plugins/org.eclipse.persistence.oracle.jar
------------------------------------------------------------------------
r8428 | gyorke | 2010-10-27 16:31:45 -0400 (Wed, 27 Oct 2010)
Changed paths:
   M /trunk/foundation/org.eclipse.persistence.core/src/org/eclipse/persistence/internal/queries/MapContainerPolicy.java
   M /trunk/jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/tests/jpa/advanced/AdvancedJPAJunitTest.java
------------------------------------------------------------------------
r8427 | dmccann | 2010-10-27 16:13:37 -0400 (Wed, 27 Oct 2010)
Changed paths:
   A /trunk/moxy/eclipselink.moxy.test/resource/org/eclipse/persistence/testing/jaxb/externalizedmetadata/xmlvalue/adapter
   A /trunk/moxy/eclipselink.moxy.test/resource/org/eclipse/persistence/testing/jaxb/externalizedmetadata/xmlvalue/adapter/boolean.xml
   A /trunk/moxy/eclipselink.moxy.test/resource/org/eclipse/persistence/testing/jaxb/externalizedmetadata/xmlvalue/adapter/oxm.xml
   M /trunk/moxy/eclipselink.moxy.test/src/org/eclipse/persistence/testing/jaxb/externalizedmetadata/xmlvalue/XmlValueTestCases.java
   A /trunk/moxy/eclipselink.moxy.test/src/org/eclipse/persistence/testing/jaxb/externalizedmetadata/xmlvalue/adapter
   A /trunk/moxy/eclipselink.moxy.test/src/org/eclipse/persistence/testing/jaxb/externalizedmetadata/xmlvalue/adapter/MyValueAdapter.java
   A /trunk/moxy/eclipselink.moxy.test/src/org/eclipse/persistence/testing/jaxb/externalizedmetadata/xmlvalue/adapter/MyValueClass.java
   M /trunk/moxy/org.eclipse.persistence.moxy/resource/xsd/eclipselink_oxm_2_2.xsd
   M /trunk/moxy/org.eclipse.persistence.moxy/src/org/eclipse/persistence/jaxb/compiler/XMLProcessor.java
   M /trunk/moxy/org.eclipse.persistence.moxy/src/org/eclipse/persistence/jaxb/xmlmodel/XmlValue.java
------------------------------------------------------------------------
r8426 | dminsky | 2010-10-27 16:02:58 -0400 (Wed, 27 Oct 2010)
Changed paths:
   M /trunk/foundation/eclipselink.core.test/src/org/eclipse/persistence/testing/tests/feature/FeatureTestModel.java
   M /trunk/foundation/eclipselink.core.test/src/org/eclipse/persistence/testing/tests/queries/repreparation/AddJoinedAttributeTest.java
   M /trunk/foundation/eclipselink.core.test/src/org/eclipse/persistence/testing/tests/queries/repreparation/AddNonFetchedJoinedAttributeTest.java
   A /trunk/foundation/eclipselink.core.test/src/org/eclipse/persistence/testing/tests/writing/CommitOrderTest.java
   M /trunk/foundation/org.eclipse.persistence.core/src/org/eclipse/persistence/internal/expressions/ConstantExpression.java
   M /trunk/foundation/org.eclipse.persistence.core/src/org/eclipse/persistence/internal/helper/MappingCompare.java
   M /trunk/foundation/org.eclipse.persistence.core/src/org/eclipse/persistence/internal/sessions/CommitOrderCalculator.java
   M /trunk/foundation/org.eclipse.persistence.core/src/org/eclipse/persistence/internal/sessions/CommitOrderDependencyNode.java
   M /trunk/foundation/org.eclipse.persistence.core/src/org/eclipse/persistence/mappings/AggregateMapping.java
   M /trunk/foundation/org.eclipse.persistence.core/src/org/eclipse/persistence/mappings/DatabaseMapping.java
   M /trunk/foundation/org.eclipse.persistence.core/src/org/eclipse/persistence/mappings/ObjectReferenceMapping.java
   M /trunk/foundation/org.eclipse.persistence.core/src/org/eclipse/persistence/mappings/foundation/AbstractCompositeDirectCollectionMapping.java
   M /trunk/foundation/org.eclipse.persistence.core/src/org/eclipse/persistence/mappings/foundation/AbstractDirectMapping.java
   M /trunk/foundation/org.eclipse.persistence.core/src/org/eclipse/persistence/mappings/foundation/AbstractTransformationMapping.java
   M /trunk/foundation/org.eclipse.persistence.core/src/org/eclipse/persistence/mappings/structures/ReferenceMapping.java
------------------------------------------------------------------------
r8425 | gpelletie | 2010-10-27 16:00:52 -0400 (Wed, 27 Oct 2010)
Changed paths:
   M /trunk/foundation/org.eclipse.persistence.core/src/org/eclipse/persistence/exceptions/ValidationException.java
   M /trunk/foundation/org.eclipse.persistence.core/src/org/eclipse/persistence/exceptions/i18n/ValidationExceptionResource.java
   M /trunk/foundation/org.eclipse.persistence.core/src/org/eclipse/persistence/internal/localization/i18n/LoggingLocalizationResource.java
   M /trunk/jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/fieldaccess/advanced/PhoneNumber.java
   A /trunk/jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/fieldaccess/advanced/PhoneNumberMappedSuperclass.java
   D /trunk/jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/fieldaccess/advanced/PhoneNumberPK.java
   M /trunk/jpa/org.eclipse.persistence.jpa/src/org/eclipse/persistence/internal/jpa/metadata/MetadataLogger.java
   D /trunk/jpa/org.eclipse.persistence.jpa/src/org/eclipse/persistence/internal/jpa/metadata/PrimaryKeyMetadata.java
   M /trunk/jpa/org.eclipse.persistence.jpa/src/org/eclipse/persistence/internal/jpa/metadata/accessors/classes/MappedSuperclassAccessor.java
   A /trunk/jpa/org.eclipse.persistence.jpa/src/org/eclipse/persistence/internal/jpa/metadata/columns/PrimaryKeyMetadata.java (from /trunk/jpa/org.eclipse.persistence.jpa/src/org/eclipse/persistence/internal/jpa/metadata/PrimaryKeyMetadata.java:8422)
   M /trunk/jpa/org.eclipse.persistence.jpa/src/org/eclipse/persistence/internal/jpa/metadata/xml/XMLEntityMappingsMappingProject.java
------------------------------------------------------------------------
r8424 | gpelletie | 2010-10-27 14:21:24 -0400 (Wed, 27 Oct 2010)
Changed paths:
   M /trunk/jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/tests/jpa/advanced/AdvancedJPAJunitTest.java
------------------------------------------------------------------------
r8423 | kyuan | 2010-10-27 14:13:01 -0400 (Wed, 27 Oct 2010)
Changed paths:
   M /trunk/foundation/org.eclipse.persistence.oracle/build.properties
   M /trunk/jpa/eclipselink.jpa.test/build.properties
   M /trunk/jpa/eclipselink.jpa.wdf.test/build.properties
   M /trunk/jpa/org.eclipse.persistence.jpa.modelgen/build.properties
   M /trunk/moxy/org.eclipse.persistence.moxy/build.properties
   M /trunk/moxy/org.eclipse.persistence.moxy.dynamic/build.properties
------------------------------------------------------------------------
r8422 | gpelletie | 2010-10-27 13:31:37 -0400 (Wed, 27 Oct 2010)
Changed paths:
   M /trunk/foundation/org.eclipse.persistence.core/src/org/eclipse/persistence/mappings/AggregateObjectMapping.java
   M /trunk/jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/advanced/AdvancedTableCreator.java
   A /trunk/jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/advanced/Bag.java
   A /trunk/jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/advanced/Cost.java
   A /trunk/jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/advanced/Loot.java
   A /trunk/jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/models/jpa/advanced/Quantity.java
   M /trunk/jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/tests/jpa/advanced/AdvancedJPAJunitTest.java
   M /trunk/jpa/org.eclipse.persistence.jpa/src/org/eclipse/persistence/internal/jpa/metadata/MetadataDescriptor.java
   M /trunk/jpa/org.eclipse.persistence.jpa/src/org/eclipse/persistence/internal/jpa/metadata/accessors/mappings/MappingAccessor.java
------------------------------------------------------------------------
r8421 | gyorke | 2010-10-27 13:20:08 -0400 (Wed, 27 Oct 2010)
Changed paths:
   M /trunk/foundation/org.eclipse.persistence.core/src/org/eclipse/persistence/internal/queries/MapContainerPolicy.java
   M /trunk/jpa/eclipselink.jpa.test/src/org/eclipse/persistence/testing/tests/jpa/advanced/AdvancedJPAJunitTest.java
------------------------------------------------------------------------
r8420 | dmccann | 2010-10-27 10:59:49 -0400 (Wed, 27 Oct 2010)
Changed paths:
   M /trunk/moxy/eclipselink.moxy.test/resource/org/eclipse/persistence/testing/jaxb/externalizedmetadata/xmlelementrefs/eclipselink-oxm.xml
------------------------------------------------------------------------
r8419 | tware | 2010-10-27 09:17:23 -0400 (Wed, 27 Oct 2010)
Changed paths:
   M /trunk/jpa/eclipselink.jpa.test/.classpath
------------------------------------------------------------------------
r8418 | ssmith | 2010-10-27 09:13:34 -0400 (Wed, 27 Oct 2010)
Changed paths:
   A /trunk/jpa/plugins/javax.persistence/src/org/osgi
   A /trunk/jpa/plugins/javax.persistence/src/org/osgi/service
   A /trunk/jpa/plugins/javax.persistence/src/org/osgi/service/jpa
   A /trunk/jpa/plugins/javax.persistence/src/org/osgi/service/jpa/EntityManagerFactoryBuilder.java
------------------------------------------------------------------------
r8417 | ssmith | 2010-10-27 09:09:01 -0400 (Wed, 27 Oct 2010)
Changed paths:
   A /trunk/jpa/plugins/javax.persistence/src/org/eclipse/persistence/javax/persistence/osgi/OSGiProviderResolver.java
------------------------------------------------------------------------
r8416 | tware | 2010-10-27 08:05:43 -0400 (Wed, 27 Oct 2010)
Changed paths:
   M /trunk/foundation/org.eclipse.persistence.core/src/org/eclipse/persistence/sessions/interceptors/CacheInterceptor.java
Comment 1 Guy Pelletier CLA 2010-10-29 10:54:36 EDT 
Created attachment 182051 [details]
Proposed changes
Comment 2 Guy Pelletier CLA 2010-10-29 13:41:09 EDT 
Changes have been submitted.

Reviewed: Gordon Yorke

Tests should pass on the next nightly run.
Comment 3 Eclipse Webmaster CLA 2022-06-09 10:19:53 EDT 
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink