Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 328972 - Three jpa complexaggregate tests failed with java.sql.SQLSyntaxErrorException: ORA-00904: "JERSEYNUMBER": invalid identifier
Summary: Three jpa complexaggregate tests failed with java.sql.SQLSyntaxErrorException...
Status: RESOLVED FIXED
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: Eclipselink (show other bugs)
Version: unspecified   Edit
Hardware: PC Windows XP
: P3 normal (vote)
Target Milestone: ---   Edit
Assignee: Nobody - feel free to take it CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-10-28 16:06 EDT by Yiping Zhao CLA
Modified: 2022-06-09 10:19 EDT (History)
2 users (show)

See Also:

Attachments
Proposed changes (5.09 KB, patch)
2010-10-29 10:54 EDT, Guy Pelletier CLA 		no flags Details | Diff
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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