JPOX
JPOX
 Project  |  Ver 1.1  |  Ver 1.2  |  JDO  |  JPA  |  Guides  |  Tools
1.2 | Persistence | JDO ORM | JPA ORM | Runtime | JDO Runtime | JPA Runtime | Extensions | Developer
Development
Testing
Summary

[ summary] [ package list] [ test cases]

TestsErrorsFailuresSuccess rateTime(s)
66510797.44%100.44

Note: failuresare anticipated and checked for with assertions while errorsare unanticipated.

Package List

[ summary] [ package list] [ test cases]

PackageTestsErrorsFailuresSuccess RateTime
org.jpox.tests 66510797.44%100.44

Note: package statistics are not computed recursively, they only sum up all of its testsuites numbers.

org.jpox.tests
ClassTestsErrorsFailuresSuccess RateTime
Success HashSetTest 1800100.00%1.619
Success SecondaryTableTest 200100.00%0.463
Success SchemaTest 3200100.00%4.979
Success PersistentAbstractClassesTest 500100.00%1.010
Success ArrayListTest 2300100.00%2.005
Success ListTest 2200100.00%2.036
Failure JDOQLBasicTest 580394.83%9.084
Success TreeSetTest 1800100.00%1.904
Error JDOQLContainerTest 718187.32%12.307
Success MapTest 2700100.00%4.141
Success ValueGeneratorTest 1100100.00%7.139
Success OptimisticTest 2100100.00%1.041
Success SQLQueryTest 1900100.00%1.992
Success PersistenceModelsTest 600100.00%2.325
Success CollectionSerialTest 1000100.00%0.936
Success HashtableTest 1900100.00%2.279
Success SetTest 2100100.00%1.848
Failure ReachabilityTest 140192.86%6.861
Success MapForeignKeyTest 200100.00%1.192
Success DatastoreIdentityTest 100100.00%0.640
Failure RelationshipTest 320196.88%3.687
Success LinkedListTest 1900100.00%1.694
Success VectorTest 1900100.00%1.760
Success PersistentInterfacesTest 700100.00%1.346
Success StackTest 1900100.00%1.704
Error JDOQLResultTest 291096.55%3.236
Success LinkedHashMapTest 1900100.00%2.299
Success DependentFieldTest 1400100.00%4.206
Success AbstractClassesTest 900100.00%1.450
Success HashMapTest 1900100.00%2.353
Error InterfacesTest 171188.24%3.836
Success QueueTest 100100.00%0.611
Success CollectionPrimitiveTest 300100.00%0.518
Success LinkedHashSetTest 1800100.00%1.644
Success ObjectsTest 200100.00%0.863
Success InheritanceTest 1300100.00%1.124
Success CollectionTest 1800100.00%1.677
Success PropertiesTest 700100.00%0.631
Test Cases

[ summary] [ package list] [ test cases]

HashSetTest
Success testNormalAddCollection0.33
Success testNormalChildAddCollection0.06
Success testNormalRemoveCollection0.10
Success testNormalRetainCollection0.07
Success testNormalChildRemoveCollection0.06
Success testNormalRemoveItem0.07
Success testNormalClearIsEmpty0.05
Success testNormalInheritance0.06
Success testNormalQuery0.10
Success testNormalAttachDetach0.13
Success testInverseAddCollection0.07
Success testInverseRemoveCollection0.06
Success testInverseRetainCollection0.06
Success testInverseAddElement0.06
Success testInverseClearIsEmpty0.05
Success testInverseInheritance0.08
Success testInverseQuery0.09
Success testInverseAttachDetach0.12
SecondaryTableTest
Success testSecondaryTable0.41
Success testQuerySecondaryTable0.04
SchemaTest
Success testTableColumnNames0.58
Success testColumnSpecifications0.02
Success testUnique0.27
Success testColumnWidth0.46
Success testReadOnlyDatastore0.43
Success testFixedDatastore0.43
Success testClassUsingSQLKeywords0.47
Success testClassWithLongName0.33
Success testClassAsSQLKeyword0.00
Success testTableReuseForDifferentClasses0.13
Success test1To1Bidir0.06
Success testSecondaryTableSchema0.03
Success testInterfaces0.18
Success testObjectFields0.05
Success test1To1UnidirectionalSchema0.04
Success testOverridingColumnsBaseNewTableSubNewTable0.29
Success testOverridingColumnsBaseSubclassTableSubNewTable0.02
Success testOverridingColumnsBaseNewTableSubSuperclassTable0.01
Success testEmbeddedPCSchema0.13
Success testEmbeddedPCCollectionSchema0.02
Success testEmbeddedPCListSchema0.01
Success testEmbeddedPCMapSchema0.02
Success testMtoN0.08
Success testArrayNonPC0.29
Success testArrayPC0.02
Success testSet0.23
Success testList0.09
Success testMap0.13
Success testDefaultedFields0.02
Success testUnmappedColumns0.01
Success testIsNullable0.07
Success testNullsAllowed0.03
PersistentAbstractClassesTest
Success testMakePersistent0.78
Success testQuery0.04
Success testObjectWithReferenceToPersistentInterface0.17
Success testNewInstance0.00
Success testNewInstance30.00
ArrayListTest
Success testNormalAddCollection0.36
Success testNormalAddItem0.10
Success testNormalChildAddCollection0.07
Success testNormalRemoveCollection0.08
Success testNormalRetainCollection0.08
Success testNormalChildRemoveCollection0.06
Success testNormalRemoveItem0.07
Success testNormalRemoveAt0.06
Success testNormalGetItem0.06
Success testNormalClearIsEmpty0.05
Success testNormalInheritance0.07
Success testNormalQuery0.10
Success testNormalAttachDetach0.15
Success testInverseAddCollection0.06
Success testInverseRemoveCollection0.06
Success testInverseRetainCollection0.06
Success testInverseRemoveItem0.06
Success testInverseRemoveAt0.06
Success testInverseGetItem0.05
Success testInverseClearIsEmpty0.04
Success testInverseInheritance0.06
Success testInverseQuery0.08
Success testInverseAttachDetach0.15
ListTest
Success testNormalAddCollection0.36
Success testNormalChildAddCollection0.07
Success testNormalRemoveCollection0.10
Success testNormalRetainCollection0.11
Success testNormalChildRemovalCollection0.06
Success testNormalRemoveItem0.06
Success testNormalRemoveAt0.06
Success testNormalGetItem0.05
Success testNormalContains0.08
Success testNormalClearIsEmpty0.05
Success testNormalInheritance0.06
Success testNormalQuery0.13
Success testNormalAttachDetach0.14
Success testInverseAddCollection0.07
Success testInverseRemoveCollection0.07
Success testInverseRetainCollection0.06
Success testInverseRemoveItem0.06
Success testInverseGetItem0.06
Success testInverseClearIsEmpty0.05
Success testInverseInheritance0.06
Success testInverseQuery0.08
Success testInverseAttachDetach0.18
JDOQLBasicTest
Success testInvalidOperator0.11
Success testDeclareImports0.08
Success testCandidateCollection0.37
Success testQueryUsesInnerJoin0.34
Success testQueryReturnSameObject0.10
Success testStringIndexOf0.10
Success testStaticFields0.12
Success testStringStartsWith0.10
Success testStringEndsWith0.08
Success testStringSubstring0.03
Success testStringTranslate0.00
Success testStringToLowerCase0.16
Success testStringToUpperCase0.05
Success testStringMatches0.12
Success testArrayContains0.17
Success testArrayLength0.05
Success testArrayParameter0.06
Success testMathAbs0.07
Success testMathSqrt0.09
Failure testAvg0.05
Exception thrown executing JDOQL query with AVG : [JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.types.basic.BasicTypeHolder' AS JPOXMETADATA,THIS.BASICTYPEHOLDER_ID,THIS.BOOLEAN_FIELD,THIS.BOOLEAN_OBJ_FIELD,THIS.BYTE_FIELD,THIS.BYTE_OBJ_FIELD,THIS.CHAR_FIELD,THIS.CHAR_OBJ_FIELD,THIS.INT_FIELD,THIS.INT_OBJ_FIELD,THIS.LONG_FIELD,THIS.LONG_OBJ_FIELD,THIS.SHORT_FIELD,THIS.SHORT_OBJ_FIELD FROM BASICTYPEHOLDER THIS , BASICTYPEHOLDER UNBOUND_P WHERE THIS.LONG_FIELD = AVG(UNBOUND_P.LONG_FIELD)" : Not a condition in statement [SELECT 'org.jpox.samples.types.basic.BasicTypeHolder' AS JPOXMETADATA,THIS.BASICTYPEHOLDER_ID,THIS.BOOLEAN_FIELD,THIS.BOOLEAN_OBJ_FIELD,THIS.BYTE_FIELD,THIS.BYTE_OBJ_FIELD,THIS.CHAR_FIELD,THIS.CHAR_OBJ_FIELD,THIS.INT_FIELD,THIS.INT_OBJ_FIELD,THIS.LONG_FIELD,THIS.LONG_OBJ_FIELD,THIS.SHORT_FIELD,THIS.SHORT_OBJ_FIELD FROM BASICTYPEHOLDER THIS , BASICTYPEHOLDER UNBOUND_P WHERE THIS.LONG_FIELD = AVG(UNBOUND_P.LONG_FIELD)].
Success testDateTimeMethods0.05
Success testPCLiteralOnQueryCompile0.10
Success testJDOHelperGetObjectID10.45
Success testJDOHelperGetObjectID20.10
Success testAnalysisRollup0.00
Success testSingleString0.05
Success testSingleStringKeywordAsFieldName0.00
Success testSingleStringParameters0.11
Success testNamedQueries0.10
Success testNonstandardCharacters0.07
Success testInstanceof0.23
Success testSingleQuotes0.09
Success testCharLiteralInvalidComparison0.09
Success testEscapeSingleQuoteInString0.05
Failure testEq_Neq_UnboundVariables0.08
expected:<2> but was:<0>
Success testQueryUnboundVariables0.10
Success testQueryUnboundVariablesInheritance10.20
Success testQueryUnboundVariablesInheritance20.14
Success testQueryUnboundVariablesInheritanceRightHandDeclared10.15
Success testQueryUnboundVariablesInheritanceRightHandDeclared20.04
Success testConcatStringAndNumbers0.09
Success testNullEqualsNull0.04
Success testUseOfParentheses0.04
Success testQueryCheckValueDiffFields0.07
Success testCast0.15
Success testKeepResultsQueryAfterQueryClose0.01
Success testKeepResultsQueryAfterTxClose0.01
Success testKeepResultsQueryAfterPMClose0.00
Success testQueryWithNonNullFieldCondition0.12
Success testBoolean0.07
Success testQueryWithDetachedObjects0.11
Success testModuloOperator0.03
Success testInheritanceCastWithDiscriminator0.57
Failure testInheritanceCastWithUnion0.04
Exception thrown during test [JPOX-052500] Range variable THIS_INST already in use in query : SELECT 'org.jpox.samples.inheritance.ABase' AS JPOXMETADATA FROM ABASE THIS LEFT OUTER JOIN ASUB2 SUBELEMENT0 ON SUBELEMENT0.ASUB2_ID = THIS.ABASE_ID LEFT OUTER JOIN ASUB1 SUBELEMENT1 ON SUBELEMENT1.ASUB1_ID = THIS.ABASE_ID INNER JOIN ASUB1 THIS_INST ON THIS_INST.ASUB1_ID = THIS.ABASE_ID WHERE SUBELEMENT0.ASUB2_ID IS NULL AND SUBELEMENT1.ASUB1_ID IS NULL UNION SELECT 'org.jpox.samples.inheritance.ASub2' AS JPOXMETADATA FROM ABASE THIS INNER JOIN ASUB2 "ELEMENT" ON "ELEMENT".ASUB2_ID = THIS.ABASE_ID INNER JOIN ASUB1 THIS_INST ON THIS_INST.ASUB1_ID = THIS.ABASE_ID UNION SELECT 'org.jpox.samples.inheritance.ASub1' AS JPOXMETADATA FROM ABASE THIS INNER JOIN ASUB1 "ELEMENT" ON "ELEMENT".ASUB1_ID = THIS.ABASE_ID INNER JOIN ASUB1 THIS_INST ON THIS_INST.ASUB1_ID = THIS.ABASE_ID
Success testDeleteByQuery0.02
Success testClose0.05
Success testMultipleActiveQueryCandidateCollection1.80
Success testMultipleActiveQueryMapGet1.39
TreeSetTest
Success testNormalAddCollection0.40
Success testNormalChildAddCollection0.08
Success testNormalRemoveCollection0.11
Success testNormalRetainCollection0.09
Success testNormalChildRemoveCollection0.06
Success testNormalRemoveItem0.08
Success testNormalClearIsEmpty0.06
Success testNormalInheritance0.06
Success testNormalQuery0.11
Success testNormalAttachDetach0.15
Success testInverseAddCollection0.08
Success testInverseRemoveCollection0.07
Success testInverseRetainCollection0.07
Success testInverseAddElement0.06
Success testInverseClearIsEmpty0.05
Success testInverseInheritance0.09
Success testInverseQuery0.09
Success testInverseAttachDetach0.14
JDOQLContainerTest
Success testNotContainsValuesInMapFields0.72
Success testNotContainsValuesInMapFieldsInverse0.10
Success testNotContainsKeysInMapFields0.32
Success testNotContainsKeysInMapFieldsInverse0.25
Success testNotContainsEntryInMapFields0.23
Success testNotContainsEntryInMapFieldsInverse0.26
Success testGetInMapFields0.20
Failure testGetInOrderingInMapFields0.18
expected:<2> but was:<3>
Success testNegateContains0.34
Success testContainsInListFields0.04
Success testContainsInSetFields0.08
Success testContainsInMapFields0.26
Success testContainsInParameterCollection0.24
Success testContainsInParameterArray0.32
Error testContainsInParameterArray20.20
[JPOX-021060] Error binding "dept0" to "ObjectExpression "UNBOUND_DEPT0.DEPARTMENT_ID"" since it was previously bound to "ObjectExpression "UNBOUND_DEPT0.DEPARTMENT_ID"".
Success testContainsResultVariable0.18
Success testContainsResultVariableNestedContains0.20
Success testContainsInParameterCollectionOfPCleanInstances0.15
Success testContainsInImplicitParameterCollection0.15
Success testContainsInImplicitParameterCollectionOfPCleanInstances0.14
Success testMapGetMethod0.16
Error testMapGetAsLiteralWithKeyAsExpression0.14
Cannot perform operation "getMethod" on MapKeyLiteral "('2 doors')" and StringExpression "THIS.MODEL"
Success testCollectionSize0.09
Success testCollectionIsEmpty0.10
Success testMapSize0.15
Success testMapIsEmpty0.12
Success testQueryUsesContainsOnceOnOneUnboundVariable0.17
Success testQueryUsesContainsOnceAndEqualsOnOneUnboundVariable0.13
Success testQueryUsesContainsValueOnceOnOneUnboundVariable0.24
Success testQueryUsesContainsValueAndEqualsOnceOnOneUnboundVariable0.16
Success testQueryUsesContainsValueOnceOnOneUnboundVariableInverse0.24
Success testQueryContainsKeyOnCharacter0.05
Success testQueryUsesContainsKeyOnceOnOneUnboundVariableInverse0.22
Success testQueryUsesContainsKeyOnceOnOneUnboundVariable0.28
Success testQueryUsesContainsOnceOnOneUnboundVariableUsingParameters0.15
Success testQueryUsesContainsValueOnceOnOneUnboundVariableUsingParameters0.17
Success testQueryUsesContainsValueOnceOnOneUnboundVariableUsingParametersInverse0.17
Success testQueryUsesContainsKeyOnceOnOneUnboundVariableUsingParametersInverse0.16
Success testQueryUsesContainsKeyOnceOnOneUnboundVariableUsingParameters0.15
Success testQueryUsesContainsOnceOnOneUnboundVariableImplicitVariables0.17
Success testQueryUsesContainsValueOnceOnOneUnboundVariableImplicitVariables0.17
Success testQueryUsesContainsValueOnceOnOneUnboundVariableImplicitVariablesInverse0.19
Success testQueryUsesContainsKeyOnceOnOneUnboundVariableImplicitVariablesInverse0.16
Success testQueryUsesContainsKeyOnceOnOneUnboundVariableImplicitVariables0.16
Success testQueryUsesContainsOnceOnOneUnboundVariableInverse0.15
Success testQueryUsesContainsOnceOnOneUnboundVariableInverseImplicitVariables0.15
Success testQueryUsesContainsOnceOnOneUnboundVariableInverseUsingParameter0.17
Success testQueryUsesContainsOnceOnOneUnboundVariableMtoN0.07
Success testQueryUsesContainsTwiceOnOneUnboundVariable0.13
Success testQueryUsesContainsValueTwiceOnOneUnboundVariable0.17
Success testQueryUsesContainsValueTwiceOnOneUnboundVariableInverse0.19
Success testQueryUsesContainsKeyTwiceOnOneUnboundVariableInverse0.17
Success testQueryUsesContainsKeyTwiceOnOneUnboundVariable0.15
Success testQueryUsesContainsTwiceOnOneUnboundVariableInverse0.15
Success testQueryUsesContainsTwiceOnOneUnboundVariableMtoN0.07
Error testQueryUsesContainsTwiceOnFieldUsingWorkaround0.18
[JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.models.company.Manager' AS JPOXMETADATA,THIS.EMPLOYEE_ID,THIS_1.AGE,THIS_1.EMAIL_ADDRESS,THIS_1.FIRSTNAME,THIS_1.GLOBALNUM,THIS_1.LASTNAME,THIS_1.PERSONNUM,THIS_2.MANAGER_EMPLOYEE_ID_OID,THIS_2.SALARY,THIS_2.SALARY_CURRENCY,THIS_2.SERIAL_NO FROM MANAGER THIS INNER JOIN PERSON THIS_1 ON THIS_1.PERSON_ID = THIS.EMPLOYEE_ID INNER JOIN EMPLOYEE THIS_2 ON THIS_2.EMPLOYEE_ID = THIS.EMPLOYEE_ID WHERE EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP1 INNER JOIN PERSON UNBOUND_EMP1_1 ON UNBOUND_EMP1_1.PERSON_ID = UNBOUND_EMP1.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP1 WHERE THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP1.EMPLOYEE_ID = THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_EID) AND EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP2 INNER JOIN PERSON UNBOUND_EMP2_1 ON UNBOUND_EMP2_1.PERSON_ID = UNBOUND_EMP2.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP2 WHERE THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP2.EMPLOYEE_ID = THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_EID) AND UNBOUND_EMP1_1.LASTNAME = ? OR UNBOUND_EMP2_1.LASTNAME = ?" : Column not found: UNBOUND_EMP1_1.LASTNAME in statement [SELECT 'org.jpox.samples.models.company.Manager' AS JPOXMETADATA,THIS.EMPLOYEE_ID,THIS_1.AGE,THIS_1.EMAIL_ADDRESS,THIS_1.FIRSTNAME,THIS_1.GLOBALNUM,THIS_1.LASTNAME,THIS_1.PERSONNUM,THIS_2.MANAGER_EMPLOYEE_ID_OID,THIS_2.SALARY,THIS_2.SALARY_CURRENCY,THIS_2.SERIAL_NO FROM MANAGER THIS INNER JOIN PERSON THIS_1 ON THIS_1.PERSON_ID = THIS.EMPLOYEE_ID INNER JOIN EMPLOYEE THIS_2 ON THIS_2.EMPLOYEE_ID = THIS.EMPLOYEE_ID WHERE EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP1 INNER JOIN PERSON UNBOUND_EMP1_1 ON UNBOUND_EMP1_1.PERSON_ID = UNBOUND_EMP1.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP1 WHERE THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP1.EMPLOYEE_ID = THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_EID) AND EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP2 INNER JOIN PERSON UNBOUND_EMP2_1 ON UNBOUND_EMP2_1.PERSON_ID = UNBOUND_EMP2.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP2 WHERE THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP2.EMPLOYEE_ID = THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_EID) AND UNBOUND_EMP1_1.LASTNAME = ? OR UNBOUND_EMP2_1.LASTNAME = ?].
Error testQueryUsesContainsValueTwiceOnFieldUsingWorkaround0.18
[JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM GYM_WARDROBES THIS_WARDROBES_W1 , WARDROBE UNBOUND_W1 WHERE THIS_WARDROBES_W1.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES_W1.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W1.WARDROBE_ID = THIS_WARDROBES_W1.WARDROBE_ID_VID) AND EXISTS (SELECT 1 FROM GYM_WARDROBES THIS_WARDROBES_W2 , WARDROBE UNBOUND_W2 WHERE THIS_WARDROBES_W2.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES_W2.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W2.WARDROBE_ID = THIS_WARDROBES_W2.WARDROBE_ID_VID) AND UNBOUND_W1.MODEL = ? OR UNBOUND_W2.MODEL = ?" : Column not found: UNBOUND_W1.MODEL in statement [SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM GYM_WARDROBES THIS_WARDROBES_W1 , WARDROBE UNBOUND_W1 WHERE THIS_WARDROBES_W1.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES_W1.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W1.WARDROBE_ID = THIS_WARDROBES_W1.WARDROBE_ID_VID) AND EXISTS (SELECT 1 FROM GYM_WARDROBES THIS_WARDROBES_W2 , WARDROBE UNBOUND_W2 WHERE THIS_WARDROBES_W2.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES_W2.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W2.WARDROBE_ID = THIS_WARDROBES_W2.WARDROBE_ID_VID) AND UNBOUND_W1.MODEL = ? OR UNBOUND_W2.MODEL = ?].
Error testQueryUsesContainsValueTwiceOnFieldUsingWorkaroundInverse0.16
[JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE_W1 WHERE THIS_WARDROBESINVERSE_W1.GYM_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE_W1.GYM_GYM_ID_OID = THIS.GYM_ID) AND EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE_W2 WHERE THIS_WARDROBESINVERSE_W2.GYM_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE_W2.GYM_GYM_ID_OID = THIS.GYM_ID) AND THIS_WARDROBESINVERSE_W1.MODEL = ? OR THIS_WARDROBESINVERSE_W2.MODEL = ?" : Column not found: THIS_WARDROBESINVERSE_W1.MODEL in statement [SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE_W1 WHERE THIS_WARDROBESINVERSE_W1.GYM_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE_W1.GYM_GYM_ID_OID = THIS.GYM_ID) AND EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE_W2 WHERE THIS_WARDROBESINVERSE_W2.GYM_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE_W2.GYM_GYM_ID_OID = THIS.GYM_ID) AND THIS_WARDROBESINVERSE_W1.MODEL = ? OR THIS_WARDROBESINVERSE_W2.MODEL = ?].
Error testQueryUsesContainsKeyTwiceOnFieldUsingWorkaroundInverse0.25
[JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE2_W1 INNER JOIN WARDROBE UNBOUND_W1 ON THIS_WARDROBESINVERSE2_W1.WARDROBE_ID = UNBOUND_W1.WARDROBE_ID WHERE THIS_WARDROBESINVERSE2_W1.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE2_W1.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID) AND EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE2_W2 INNER JOIN WARDROBE UNBOUND_W2 ON THIS_WARDROBESINVERSE2_W2.WARDROBE_ID = UNBOUND_W2.WARDROBE_ID WHERE THIS_WARDROBESINVERSE2_W2.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE2_W2.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID) AND UNBOUND_W1.MODEL = ? OR UNBOUND_W2.MODEL = ?" : Column not found: UNBOUND_W1.MODEL in statement [SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE2_W1 INNER JOIN WARDROBE UNBOUND_W1 ON THIS_WARDROBESINVERSE2_W1.WARDROBE_ID = UNBOUND_W1.WARDROBE_ID WHERE THIS_WARDROBESINVERSE2_W1.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE2_W1.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID) AND EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE2_W2 INNER JOIN WARDROBE UNBOUND_W2 ON THIS_WARDROBESINVERSE2_W2.WARDROBE_ID = UNBOUND_W2.WARDROBE_ID WHERE THIS_WARDROBESINVERSE2_W2.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE2_W2.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID) AND UNBOUND_W1.MODEL = ? OR UNBOUND_W2.MODEL = ?].
Error testQueryUsesContainsKeyTwiceOnFieldUsingWorkaround0.14
[JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM GYM_WARDROBES2 THIS_WARDROBES2_W1 , WARDROBE UNBOUND_W1 WHERE THIS_WARDROBES2_W1.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES2_W1.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W1.WARDROBE_ID = THIS_WARDROBES2_W1.WARDROBE_ID_KID) AND EXISTS (SELECT 1 FROM GYM_WARDROBES2 THIS_WARDROBES2_W2 , WARDROBE UNBOUND_W2 WHERE THIS_WARDROBES2_W2.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES2_W2.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W2.WARDROBE_ID = THIS_WARDROBES2_W2.WARDROBE_ID_KID) AND UNBOUND_W1.MODEL = ? OR UNBOUND_W2.MODEL = ?" : Column not found: UNBOUND_W1.MODEL in statement [SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM GYM_WARDROBES2 THIS_WARDROBES2_W1 , WARDROBE UNBOUND_W1 WHERE THIS_WARDROBES2_W1.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES2_W1.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W1.WARDROBE_ID = THIS_WARDROBES2_W1.WARDROBE_ID_KID) AND EXISTS (SELECT 1 FROM GYM_WARDROBES2 THIS_WARDROBES2_W2 , WARDROBE UNBOUND_W2 WHERE THIS_WARDROBES2_W2.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES2_W2.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W2.WARDROBE_ID = THIS_WARDROBES2_W2.WARDROBE_ID_KID) AND UNBOUND_W1.MODEL = ? OR UNBOUND_W2.MODEL = ?].
Success testQueryUsesContainsTwiceOnFieldWithNamespace0.12
Success testQueryUsesContainsValueTwiceOnFieldWithNamespace0.16
Success testQueryUsesContainsValueTwiceOnFieldWithNamespaceInverse0.18
Success testQueryUsesContainsKeyTwiceOnFieldWithNamespaceInverse0.16
Success testQueryUsesContainsKeyTwiceOnFieldWithNamespace0.16
Success testQueryUsesContainsTwiceOnFieldWithNamespaceInverse0.18
Success testQueryUsesContainsTwiceOnFieldWithNamespaceMtoN0.08
Success testQueryUsesContainsTwiceOnFieldWithNamespace2MtoN0.06
Error testQueryUsesContainsTwiceOnFieldNoNamespace0.12
[JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.models.company.Manager' AS JPOXMETADATA,THIS.EMPLOYEE_ID,THIS_1.AGE,THIS_1.EMAIL_ADDRESS,THIS_1.FIRSTNAME,THIS_1.GLOBALNUM,THIS_1.LASTNAME,THIS_1.PERSONNUM,THIS_2.MANAGER_EMPLOYEE_ID_OID,THIS_2.SALARY,THIS_2.SALARY_CURRENCY,THIS_2.SERIAL_NO FROM MANAGER THIS INNER JOIN PERSON THIS_1 ON THIS_1.PERSON_ID = THIS.EMPLOYEE_ID INNER JOIN EMPLOYEE THIS_2 ON THIS_2.EMPLOYEE_ID = THIS.EMPLOYEE_ID WHERE EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP1 INNER JOIN PERSON UNBOUND_EMP1_1 ON UNBOUND_EMP1_1.PERSON_ID = UNBOUND_EMP1.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP1 WHERE THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP1.EMPLOYEE_ID = THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_EID AND UNBOUND_EMP1_1.LASTNAME = ?) AND EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP2 INNER JOIN PERSON UNBOUND_EMP2_1 ON UNBOUND_EMP2_1.PERSON_ID = UNBOUND_EMP2.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP2 WHERE THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP2.EMPLOYEE_ID = THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_EID) AND UNBOUND_EMP2_1.LASTNAME = ?" : Column not found: UNBOUND_EMP2_1.LASTNAME in statement [SELECT 'org.jpox.samples.models.company.Manager' AS JPOXMETADATA,THIS.EMPLOYEE_ID,THIS_1.AGE,THIS_1.EMAIL_ADDRESS,THIS_1.FIRSTNAME,THIS_1.GLOBALNUM,THIS_1.LASTNAME,THIS_1.PERSONNUM,THIS_2.MANAGER_EMPLOYEE_ID_OID,THIS_2.SALARY,THIS_2.SALARY_CURRENCY,THIS_2.SERIAL_NO FROM MANAGER THIS INNER JOIN PERSON THIS_1 ON THIS_1.PERSON_ID = THIS.EMPLOYEE_ID INNER JOIN EMPLOYEE THIS_2 ON THIS_2.EMPLOYEE_ID = THIS.EMPLOYEE_ID WHERE EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP1 INNER JOIN PERSON UNBOUND_EMP1_1 ON UNBOUND_EMP1_1.PERSON_ID = UNBOUND_EMP1.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP1 WHERE THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP1.EMPLOYEE_ID = THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_EID AND UNBOUND_EMP1_1.LASTNAME = ?) AND EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP2 INNER JOIN PERSON UNBOUND_EMP2_1 ON UNBOUND_EMP2_1.PERSON_ID = UNBOUND_EMP2.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP2 WHERE THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP2.EMPLOYEE_ID = THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_EID) AND UNBOUND_EMP2_1.LASTNAME = ?].
Success testIsEmptyOredWithContains0.03
Success testContainsResultVariableNestedContains20.10
MapTest
Success testNormalPutItems0.42
Success testNormalRemoveItem0.19
Success testNormalEntrySet0.10
Success testNormalKeySet0.09
Success testNormalValues0.11
Success testNormalNonPrimitiveKeyEntrySet0.13
Success testNormalNonPrimitiveSameKeyValueInstances0.94
Success testNormalNonPrimitiveKeyKeySet0.15
Success testNormalNonPrimitiveKeyQuery0.15
Success testNormalNonPrimitiveKeyValues0.10
Success testNormalClearIsEmpty0.07
Success testNormalInheritance0.08
Success testNormalQueries0.06
Success testNormalQueriesPrimitive0.07
Success testNormalAttachDetach0.18
Success testInversePutItems0.11
Success testInverseRemoveItem0.08
Success testInverseEntrySet0.08
Success testInverseKeySet0.09
Success testInverseValues0.09
Success testInverseNonPrimitiveKeyEntrySet0.11
Success testInverseNonPrimitiveKeyKeySet0.10
Success testInverseNonPrimitiveKeyValues0.14
Success testInverseClearIsEmpty0.08
Success testInverseInheritance0.09
Success testInverseQueries0.11
Success testInverseAttachDetach0.20
ValueGeneratorTest
Success testTablePoidMultiThreadedNewPM1.72
Success testTableGenerator0.03
Success testAUIDGenerator5.05
Success testUUIDStringGenerator0.04
Success testUUIDHexGenerator0.03
Success testMaxGenerator0.02
Success testSequenceGenerator0.05
Success testIdentityGenerator0.04
Success testAutoIncrementWithNoOtherFields0.01
Success testAutoIncrementWithInheritance0.10
Success testMixedGeneratorInherited0.04
OptimisticTest
Success testBasicVersionNumberStrategy0.30
Success testBasicDateTimeStrategy0.03
Success testBasicNoneStrategy0.05
Success testBasicVersionNumberStrategyVersionField0.03
Success testCreationUpdateVersionColumns0.07
Success testDeleteAfterUpdate0.02
Success testMultipleUpdates0.02
Success testConflictTransactionsVersionNumberFromQuery0.03
Success testOptimisticQuery0.02
Success testPCnewToPCdirty0.03
Success testDetachAttach0.03
Success testRefreshOfOptimisticObjects0.02
Success testOptimisticJoinTableRelation0.08
Success testSCOContainerClear0.03
Success testOptimisticRollingBack0.00
Success testRetrieveAfterPersistBeforeFlush0.01
Success testInheritance0.07
Success testInheritanceUsingQuery0.03
Success testDetachAllOnCommitVersionNumber0.02
Success testDetachCopyVersionNumber0.02
Success testOptimisticWithIdentityFieldObjects0.12
SQLQueryTest
Success testNullQuery0.04
Success testInvalidQuery0.00
Success testSelectStarQuery0.50
Success testWithCandidateClassWithoutResultClass0.12
Success testWithCandidateClassWithResultClass0.11
Success testWithoutCandidateClassWithoutResultClass0.02
Success testWithoutCandidateClassWithResultClass0.07
Success testWithoutCandidatesClassWithParameters0.02
Success testWithoutCandidatesWithParametersInMap0.02
Success testNamedQueries0.03
Success testNamedQueriesDescoped0.02
Success testQueryWithTimeout0.00
Success testQueryFromJdoqueryFile0.03
Success testInvalidQueryAllowedByConfiguration0.12
Success testWithoutCandidatesClassWithParametersMultipleExecution0.32
Success testNumberedParameters0.18
Success testNamedParameters0.04
Success testTimestampQueryOnOracle0.00
Success testSQLUpdateStatement0.33
PersistenceModelsTest
Success testClassWithoutFields0.51
Success testClassWithOnlyContainerFields0.89
Success testClassWithOnlyContainerFieldsInFetchPlan0.29
Success testPersistenceOfFKListFKListStructures0.33
Success testPersistenceOfFKSetFKListStructures0.20
Success test1toNInheritance0.08
CollectionSerialTest
Success testJoinAddCollection0.30
Success testJoinRemoveCollection0.04
Success testJoinRetainCollection0.04
Success testJoinClearIsEmpty0.04
Success testJoinAttachDetach0.09
Success testFKAddCollection0.08
Success testFKRemoveCollection0.06
Success testFKRetainCollection0.06
Success testFKClearIsEmpty0.06
Success testFKAttachDetach0.14
HashtableTest
Success testNormalPutItems0.39
Success testNormalRemoveItem0.12
Success testNormalEntrySet0.12
Success testNormalKeySet0.08
Success testNormalValues0.08
Success testNormalClearIsEmpty0.07
Success testNormalInheritance0.08
Success testNormalQueries0.10
Success testNormalQueriesPrimitive0.06
Success testNormalAttachDetach0.23
Success testInversePutItems0.10
Success testInverseRemoveItem0.09
Success testInverseEntrySet0.09
Success testInverseKeySet0.10
Success testInverseValues0.09
Success testInverseClearIsEmpty0.10
Success testInverseInheritance0.08
Success testInverseQueries0.09
Success testInverseAttachDetach0.19
SetTest
Success testNormalPersistByCollection0.35
Success testNormalChildAddCollection0.07
Success testNormalRemoveCollection0.10
Success testNormalRetainCollection0.07
Success testNormalChildRemoveCollection0.06
Success testNormalRemoveItem0.07
Success testNormalClearIsEmpty0.04
Success testNormalContains0.07
Success testNormalInheritance0.05
Success testNormalQuery0.13
Success testNormalAttachDetach0.14
Success testInverseAddCollection0.07
Success testInverseRemoveCollection0.06
Success testInverseRetainCollection0.06
Success testInverseAddElement0.06
Success testInverseClearIsEmpty0.06
Success testInverseInheritance0.07
Success testInverseQuery0.08
Success testInverseAttachDetach0.12
Success testInversePersistByCollectionDFG0.08
Success testInversePersistByElementDFG0.03
ReachabilityTest
Success testPersistCascadeFalse0.23
Success testOneToOneUniClassPessimistic0.11
Success testOneToOneUniClassOptimistic0.07
Success testOneToOneUniInterfacePessimistic0.34
Success testOneToOneUniInterfaceOptimistic0.03
Success testOneToOneUniClassTemporaryPessimistic0.04
Success testOneToOneUniClassTemporaryOptimistic0.03
Failure testOneToOneUniTemporaryStates0.03
Field value of former persistent-new-deleted (now transient) object has been changed expected:<JPOX Corporation> but was:<null>
Success testOneToOneUniClassNewDeleted2.83
Success testOneToOneBiClassNewDeleted2.48
Success testDeepReachabilityByClass0.37
Success testNewObjectUnreachableWithDirtyObjectOwner0.21
Success testBaseOnQuery0.06
Success testIncorrectAssignment0.03
MapForeignKeyTest
Success testMapWithKeyAsFieldInValue1.02
Success testMapWithValueAsFieldInKey0.16
DatastoreIdentityTest
Success testSimpleDatastoreID0.63
RelationshipTest
Success test1to1Unidir0.20
Success test1to1Bidir0.16
Success test1to1BidirQuery0.14
Success test1to1BidirInheritance0.29
Success test1toNBidirJoin0.32
Success test1toNUnidirJoinSubclassTable0.33
Success testMtoN0.17
Success testMtoNInheritance0.19
Success test1toNInheritance0.08
Success testQueryWithInheritanceAndOrdering0.06
Failure test1to1UnidirInheritanceSubclassTable0.12
Number of readers who read "Daily Mail" newspaper was incorrect expected:<0> but was:<1>
Success test1to1BidirInheritanceSuperclassTable0.08
Success test1toNBidir_1to1Unidir0.12
Success test1toNunidirFK0.06
Success test1toNUnidirFKToSelf0.09
Success test1toNUnidirFKList0.06
Success test1toNUnidirFKListToSelf0.10
Success test1toNUnidirFKMap0.12
Success test1toNUnidirFKMapToSelf0.14
Success test1toNBidirFK0.03
Success test1toNMap0.17
Success test1toNUnidirFKSetInheritanceTarget0.05
Success test1toNUnidirFKListInheritanceTarget0.06
Success test1toNUnidirSetSharedJoin0.05
Success test1toNUnidirSetSharedFK0.05
Success test1toNUnidirListSharedJoin0.06
Success test1toNUnidirListSharedFK0.07
Success test1toNUnidirOrderedList0.06
Success testDoublyLinkedList0.09
Success testSinglyLinkedList0.05
Success testParentChildLinkRelation0.04
Success test1toNListFKUsingOrderMappedBy0.07
LinkedListTest
Success testNormalAddCollection0.35
Success testNormalRemoveCollection0.10
Success testNormalRetainCollection0.11
Success testNormalRemoveItem0.08
Success testNormalRemoveAt0.06
Success testNormalGetItem0.05
Success testNormalClearIsEmpty0.04
Success testNormalInheritance0.05
Success testNormalQuery0.10
Success testNormalAttachDetach0.16
Success testInverseAddCollection0.06
Success testInverseRemoveCollection0.06
Success testInverseRetainCollection0.06
Success testInverseRemoveItem0.06
Success testInverseGetItem0.06
Success testInverseClearIsEmpty0.04
Success testInverseInheritance0.06
Success testInverseQuery0.08
Success testInverseAttachDetach0.11
VectorTest
Success testNormalAddCollection0.37
Success testNormalRemoveCollection0.10
Success testNormalRetainCollection0.11
Success testNormalRemoveItem0.08
Success testNormalRemoveAt0.06
Success testNormalGetItem0.06
Success testNormalClearIsEmpty0.05
Success testNormalInheritance0.06
Success testNormalQuery0.11
Success testNormalAttachDetach0.16
Success testInverseAddCollection0.06
Success testInverseRemoveCollection0.06
Success testInverseRetainCollection0.07
Success testInverseRemoveItem0.06
Success testInverseGetItem0.06
Success testInverseClearIsEmpty0.04
Success testInverseInheritance0.05
Success testInverseQuery0.08
Success testInverselAttachDetach0.11
PersistentInterfacesTest
Success testMakePersistent0.79
Success testQuery0.04
Success testFreshPMF0.37
Success testObjectWithReferenceToPersistentInterface0.13
Success testNewInstancePCClass0.00
Success testNewInstance0.00
Success testNewInstance30.00
StackTest
Success testNormalAddCollection0.36
Success testNormalRemoveCollection0.10
Success testNormalRetainCollection0.11
Success testNormalRemoveItem0.08
Success testNormalRemoveAt0.06
Success testNormalGetItem0.05
Success testNormalClearIsEmpty0.04
Success testNormalInheritance0.06
Success testNormalQuery0.10
Success testNormalAttachDetach0.16
Success testInverseAddCollection0.06
Success testInverseRemoveCollection0.06
Success testInverseRetainCollection0.06
Success testInverseRemoveItem0.06
Success testInverseGetItem0.06
Success testInverseClearIsEmpty0.04
Success testInverseInheritance0.05
Success testInverseQuery0.08
Success testInverseAttachDetach0.11
JDOQLResultTest
Success testRangeAndUnique0.36
Success testUniqueResultAggregates0.08
Success testSetResultCartesianProduct10.70
Success testSetResultCartesianProduct20.10
Success testSetResultCartesianProductCollection0.28
Error testSetResultCartesianProductMap0.01
implement this
Success testSetResultCartesianProductContains10.24
Success testSetResultCartesianProductContains20.21
Success testSetResultCartesianProduct1to10.23
Success testSetResultCartesianProductContainsVariableNoNavigation0.08
Success testOrdering0.11
Success testOrderingUsingCollectionExpression0.18
Success testSetResultDistinct0.04
Success testSetResult0.03
Success testCandidateCollection0.04
Success testCandidateCollectionWithResultNotSameTypeAsCandidates0.02
Success testSetIllegalAttributeInResult0.02
Success testSetResultParameter0.08
Success testResultSetMetaData0.06
Success testSetResultWithAggregationWithoutSubclasses0.04
Success testSetResultWithAggregationWithSubclasses0.02
Success testSetResultWithAggregation10.04
Success testSetResultWithAggregation20.03
Success testSetResultWithAggregationAndNonAggregateExpression0.04
Success testSetResultWithAggregationAndNonAggregateExpression20.01
Success testResultSetInsensitive0.05
Success testCountOnClassHierarchy0.03
Success testNewObjectInResult0.05
Success testSetResultClass0.04
LinkedHashMapTest
Success testNormalPutItems0.39
Success testNormalRemoveItem0.11
Success testNormalEntrySet0.12
Success testNormalKeySet0.08
Success testNormalValues0.08
Success testNormalClearIsEmpty0.08
Success testNormalInheritance0.08
Success testNormalQueries0.10
Success testNormalQueriesPrimitive0.06
Success testNormalAttachDetach0.24
Success testInversePutItems0.10
Success testInverseRemoveItem0.09
Success testInverseEntrySet0.09
Success testInverseKeySet0.10
Success testInverseValues0.09
Success testInverseClearIsEmpty0.10
Success testInverseInheritance0.09
Success testInverseQueries0.09
Success testInverseAttachDetach0.20
DependentFieldTest
Success testDependentFieldsDeletion0.83
Success testDependentFieldsInverseSetsDeletion0.27
Success testDependentFieldsInverseListsDeletion0.27
Success testDependentFieldsInverseMapsDeletion0.31
Success testDependentFieldsInverseMapsValuesDeletion0.27
Success testDependentFieldsInverseMapsKeysDeletion0.26
Success testDependentElementsRemovalUsingJoinTable0.28
Success testDependentElementsRemovalUsingForeignKey0.28
Success testDependentKeysRemovalUsingJoinTable0.23
Success testDependentKeysRemovalUsingForeignKey0.24
Success testBidirectionalDependentFields0.28
Success testInterfaceDependentFields0.35
Success testNullify1to1Relation0.16
Success testRemoveDependentFieldOnDetached0.16
AbstractClassesTest
Success testCreationSimple0.40
Success testRetrievalSimple0.14
Success testQuerySimple0.11
Success testDeletionSimple0.15
Success testJoinTableSetCreationSimple0.05
Success testJoinTableSetRetrievalSimple0.06
Success testJoinTableListCreationSimple0.04
Success testJoinTableListRetrievalSimple0.05
Success testAbstractWithCollection0.43
HashMapTest
Success testNormalPutItems0.42
Success testNormalRemoveItem0.12
Success testNormalEntrySet0.13
Success testNormalKeySet0.08
Success testNormalValues0.08
Success testNormalClearIsEmpty0.08
Success testNormalInheritance0.08
Success testNormalQueries0.10
Success testNormalQueriesPrimitive0.06
Success testNormalAttachDetach0.24
Success testInversePutItems0.10
Success testInverseRemoveItem0.09
Success testInverseEntrySet0.09
Success testInverseKeySet0.09
Success testInverseValues0.10
Success testInverseClearIsEmpty0.10
Success testInverseInheritance0.08
Success testInverseQueries0.09
Success testInverseAttachDetach0.20
InterfacesTest
Success testCreation0.89
Success testReadAllShapeHolders0.18
Success testChangeImplementation0.11
Success testNullValues0.02
Success testInsertThenDelete0.03
Success testSetJoin0.05
Success testListJoin0.09
Failure testSetFK0.07
Exception thrown during create of set of interface objects using FK : [JPOX-056041] Class "org.jpox.samples.interfaces.ShapeHolder3" has collection field "shapeList" and this has no mapping in the table for the index of the element class "org.jpox.samples.interfaces.SquareInverse". Maybe you declared the field as a java.util.Collection and instantiated it as a java.util.List yet omitted the <order> element in the MetaData ?
Error testListFK0.02
[JPOX-056041] Class "org.jpox.samples.interfaces.ShapeHolder3" has collection field "shapeList" and this has no mapping in the table for the index of the element class "org.jpox.samples.interfaces.SquareInverse". Maybe you declared the field as a java.util.Collection and instantiated it as a java.util.List yet omitted the <order> element in the MetaData ?
Success testMultipleImplementations0.05
Success testMultipleImplWithMissingColumns0.05
Success testQueryOnInterfaceFields0.45
Success testQueryOnInterfaceFieldsBooleanOps0.42
Success testCorrectCastOnInterfaceField0.36
Success testAccessToFieldsInInterfaces0.36
Success testQueryForNullShape0.34
Success testQueryForNonNullShape0.33
QueueTest
Success testQueue10.60
CollectionPrimitiveTest
Success testCollectionNonPCUsingJoinTable0.35
Success testCollectionNonPCWithoutJoinTable0.10
Success testCollectionNonPCSerialised0.05
LinkedHashSetTest
Success testNormalAddCollection0.35
Success testNormalChildAddCollection0.07
Success testNormalRemoveCollection0.10
Success testNormalRetainCollection0.07
Success testNormalChildRemoveCollection0.05
Success testNormalRemoveItem0.07
Success testNormalClearIsEmpty0.05
Success testNormalInheritance0.05
Success testNormalQuery0.10
Success testNormalAttachDetach0.13
Success testInverseAddCollection0.07
Success testInverseRemoveCollection0.06
Success testInverseRetainCollection0.06
Success testInverseAddElement0.07
Success testInverseClearIsEmpty0.05
Success testInverseInheritance0.07
Success testInverseQuery0.09
Success testInverseAttachDetach0.12
ObjectsTest
Success testOneToOneRelation0.80
Success testOneToManyRelationWithJoinTable0.04
InheritanceTest
Success testSubclassTable0.30
Success testSubclassTableNewTable0.07
Success testInheritanceWithNoTable0.01
Success testNewTableSuperclassTableValueMap0.09
Success testNewTableSuperclassTableClassName0.08
Success testNewTableNewTable0.08
Success testNewTableExtentResults0.07
Success testNewTableSubclassTableNewTable0.08
Success testSuperclassTable1toNJoinTableRelationship0.04
Success testSuperclassTable1toNFKRelationship0.05
Success testInverseCollectionWithElementUsingSuperclassTable0.19
Success testNewTableOverrideFields0.03
Success testSuperclassTableValueMapInteger0.02
CollectionTest
Success testNormalAddCollection0.34
Success testNormalChildAddCollection0.06
Success testNormalRemoveCollection0.10
Success testNormalRetainCollection0.07
Success testNormalChildRemoveCollection0.06
Success testNormalRemoveItem0.07
Success testNormalClearIsEmpty0.05
Success testNormalInheritance0.06
Success testNormalQuery0.11
Success testNormalAttachDetach0.14
Success testInverseAddCollection0.08
Success testInverseRemoveCollection0.06
Success testInverseRetainCollection0.07
Success testInverseAddElement0.06
Success testInverseClearIsEmpty0.05
Success testInverseInheritance0.08
Success testInverseQuery0.09
Success testInverseAttachDetach0.12
PropertiesTest
Success testNormalPutItems0.34
Success testNormalRemoveItem0.04
Success testNormalEntrySet0.04
Success testNormalKeySet0.03
Success testNormalValues0.04
Success testNormalClearIsEmpty0.04
Success testNormalAttachDetach0.08
Failure details
Failure testAvg
Exception thrown executing JDOQL query with AVG : [JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.types.basic.BasicTypeHolder' AS JPOXMETADATA,THIS.BASICTYPEHOLDER_ID,THIS.BOOLEAN_FIELD,THIS.BOOLEAN_OBJ_FIELD,THIS.BYTE_FIELD,THIS.BYTE_OBJ_FIELD,THIS.CHAR_FIELD,THIS.CHAR_OBJ_FIELD,THIS.INT_FIELD,THIS.INT_OBJ_FIELD,THIS.LONG_FIELD,THIS.LONG_OBJ_FIELD,THIS.SHORT_FIELD,THIS.SHORT_OBJ_FIELD FROM BASICTYPEHOLDER THIS , BASICTYPEHOLDER UNBOUND_P WHERE THIS.LONG_FIELD = AVG(UNBOUND_P.LONG_FIELD)" : Not a condition in statement [SELECT 'org.jpox.samples.types.basic.BasicTypeHolder' AS JPOXMETADATA,THIS.BASICTYPEHOLDER_ID,THIS.BOOLEAN_FIELD,THIS.BOOLEAN_OBJ_FIELD,THIS.BYTE_FIELD,THIS.BYTE_OBJ_FIELD,THIS.CHAR_FIELD,THIS.CHAR_OBJ_FIELD,THIS.INT_FIELD,THIS.INT_OBJ_FIELD,THIS.LONG_FIELD,THIS.LONG_OBJ_FIELD,THIS.SHORT_FIELD,THIS.SHORT_OBJ_FIELD FROM BASICTYPEHOLDER THIS , BASICTYPEHOLDER UNBOUND_P WHERE THIS.LONG_FIELD = AVG(UNBOUND_P.LONG_FIELD)].
junit.framework.AssertionFailedError: Exception thrown executing JDOQL query with AVG : [JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.types.basic.BasicTypeHolder' AS JPOXMETADATA,THIS.BASICTYPEHOLDER_ID,THIS.BOOLEAN_FIELD,THIS.BOOLEAN_OBJ_FIELD,THIS.BYTE_FIELD,THIS.BYTE_OBJ_FIELD,THIS.CHAR_FIELD,THIS.CHAR_OBJ_FIELD,THIS.INT_FIELD,THIS.INT_OBJ_FIELD,THIS.LONG_FIELD,THIS.LONG_OBJ_FIELD,THIS.SHORT_FIELD,THIS.SHORT_OBJ_FIELD FROM BASICTYPEHOLDER THIS , BASICTYPEHOLDER UNBOUND_P WHERE THIS.LONG_FIELD = AVG(UNBOUND_P.LONG_FIELD)" : Not a condition in statement [SELECT 'org.jpox.samples.types.basic.BasicTypeHolder' AS JPOXMETADATA,THIS.BASICTYPEHOLDER_ID,THIS.BOOLEAN_FIELD,THIS.BOOLEAN_OBJ_FIELD,THIS.BYTE_FIELD,THIS.BYTE_OBJ_FIELD,THIS.CHAR_FIELD,THIS.CHAR_OBJ_FIELD,THIS.INT_FIELD,THIS.INT_OBJ_FIELD,THIS.LONG_FIELD,THIS.LONG_OBJ_FIELD,THIS.SHORT_FIELD,THIS.SHORT_OBJ_FIELD FROM BASICTYPEHOLDER THIS , BASICTYPEHOLDER UNBOUND_P WHERE THIS.LONG_FIELD = AVG(UNBOUND_P.LONG_FIELD)]. at org.jpox.tests.JDOQLBasicTest.testAvg(JDOQLBasicTest.java:1542)
Failure testEq_Neq_UnboundVariables
expected:<2> but was:<0>
junit.framework.AssertionFailedError: expected:<2> but was:<0> at org.jpox.tests.JDOQLBasicTest.testEq_Neq_UnboundVariables(JDOQLBasicTest.java:2512)
Failure testInheritanceCastWithUnion
Exception thrown during test [JPOX-052500] Range variable THIS_INST already in use in query : SELECT 'org.jpox.samples.inheritance.ABase' AS JPOXMETADATA FROM ABASE THIS LEFT OUTER JOIN ASUB2 SUBELEMENT0 ON SUBELEMENT0.ASUB2_ID = THIS.ABASE_ID LEFT OUTER JOIN ASUB1 SUBELEMENT1 ON SUBELEMENT1.ASUB1_ID = THIS.ABASE_ID INNER JOIN ASUB1 THIS_INST ON THIS_INST.ASUB1_ID = THIS.ABASE_ID WHERE SUBELEMENT0.ASUB2_ID IS NULL AND SUBELEMENT1.ASUB1_ID IS NULL UNION SELECT 'org.jpox.samples.inheritance.ASub2' AS JPOXMETADATA FROM ABASE THIS INNER JOIN ASUB2 "ELEMENT" ON "ELEMENT".ASUB2_ID = THIS.ABASE_ID INNER JOIN ASUB1 THIS_INST ON THIS_INST.ASUB1_ID = THIS.ABASE_ID UNION SELECT 'org.jpox.samples.inheritance.ASub1' AS JPOXMETADATA FROM ABASE THIS INNER JOIN ASUB1 "ELEMENT" ON "ELEMENT".ASUB1_ID = THIS.ABASE_ID INNER JOIN ASUB1 THIS_INST ON THIS_INST.ASUB1_ID = THIS.ABASE_ID
junit.framework.AssertionFailedError: Exception thrown during test [JPOX-052500] Range variable THIS_INST already in use in query : SELECT 'org.jpox.samples.inheritance.ABase' AS JPOXMETADATA FROM ABASE THIS LEFT OUTER JOIN ASUB2 SUBELEMENT0 ON SUBELEMENT0.ASUB2_ID = THIS.ABASE_ID LEFT OUTER JOIN ASUB1 SUBELEMENT1 ON SUBELEMENT1.ASUB1_ID = THIS.ABASE_ID INNER JOIN ASUB1 THIS_INST ON THIS_INST.ASUB1_ID = THIS.ABASE_ID WHERE SUBELEMENT0.ASUB2_ID IS NULL AND SUBELEMENT1.ASUB1_ID IS NULL UNION SELECT 'org.jpox.samples.inheritance.ASub2' AS JPOXMETADATA FROM ABASE THIS INNER JOIN ASUB2 "ELEMENT" ON "ELEMENT".ASUB2_ID = THIS.ABASE_ID INNER JOIN ASUB1 THIS_INST ON THIS_INST.ASUB1_ID = THIS.ABASE_ID UNION SELECT 'org.jpox.samples.inheritance.ASub1' AS JPOXMETADATA FROM ABASE THIS INNER JOIN ASUB1 "ELEMENT" ON "ELEMENT".ASUB1_ID = THIS.ABASE_ID INNER JOIN ASUB1 THIS_INST ON THIS_INST.ASUB1_ID = THIS.ABASE_ID at org.jpox.tests.JDOQLBasicTest.testInheritanceCastWithUnion(JDOQLBasicTest.java:3554)
Failure testGetInOrderingInMapFields
expected:<2> but was:<3>
junit.framework.AssertionFailedError: expected:<2> but was:<3> at org.jpox.tests.JDOQLContainerTest.testGetInOrderingInMapFields(JDOQLContainerTest.java:735)
Error testContainsInParameterArray2
[JPOX-021060] Error binding "dept0" to "ObjectExpression "UNBOUND_DEPT0.DEPARTMENT_ID"" since it was previously bound to "ObjectExpression "UNBOUND_DEPT0.DEPARTMENT_ID"".
javax.jdo.JDOFatalInternalException: [JPOX-021060] Error binding "dept0" to "ObjectExpression "UNBOUND_DEPT0.DEPARTMENT_ID"" since it was previously bound to "ObjectExpression "UNBOUND_DEPT0.DEPARTMENT_ID"". at org.jpox.jdo.JPOXJDOHelper.getJDOExceptionForJPOXException(JPOXJDOHelper.java:393) at org.jpox.jdo.JDOQuery.execute(JDOQuery.java:227) at org.jpox.tests.JDOQLContainerTest.testContainsInParameterArray2(JDOQLContainerTest.java:1257) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) NestedThrowablesStackTrace: [JPOX-021060] Error binding "dept0" to "ObjectExpression "UNBOUND_DEPT0.DEPARTMENT_ID"" since it was previously bound to "ObjectExpression "UNBOUND_DEPT0.DEPARTMENT_ID"". org.jpox.exceptions.JPOXException: [JPOX-021060] Error binding "dept0" to "ObjectExpression "UNBOUND_DEPT0.DEPARTMENT_ID"" since it was previously bound to "ObjectExpression "UNBOUND_DEPT0.DEPARTMENT_ID"". at org.jpox.store.rdbms.query.JavaQueryCompiler.bindVariable(JavaQueryCompiler.java:594) at org.jpox.store.expression.UnboundVariable.bindTo(UnboundVariable.java:119) at org.jpox.store.expression.UnboundVariable.eq(UnboundVariable.java:180) at org.jpox.store.expression.ObjectExpression.eq(ObjectExpression.java:312) at org.jpox.store.expression.ObjectLiteral.eq(ObjectLiteral.java:124) at org.jpox.store.expression.ArrayExpression.containsMethod(ArrayExpression.java:163) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at org.jpox.store.expression.ScalarExpression.callMethod(ScalarExpression.java:836) at org.jpox.store.rdbms.query.JDOQLQueryCompiler.compilePrimary(JDOQLQueryCompiler.java:669) at org.jpox.store.rdbms.query.JavaQueryCompiler.compileUnaryExpressionNotPlusMinus(JavaQueryCompiler.java:765) at org.jpox.store.rdbms.query.JavaQueryCompiler.compileUnaryExpression(JavaQueryCompiler.java:746) at org.jpox.store.rdbms.query.JavaQueryCompiler.compileMultiplicativeExpression(JavaQueryCompiler.java:699) at org.jpox.store.rdbms.query.JavaQueryCompiler.compileAdditiveExpression(JavaQueryCompiler.java:676) at org.jpox.store.rdbms.query.JDOQLQueryCompiler.compileRelationalExpression(JDOQLQueryCompiler.java:506) at org.jpox.store.rdbms.query.JDOQLQueryCompiler.compileEqualityExpression(JDOQLQueryCompiler.java:478) at org.jpox.store.rdbms.query.JDOQLQueryCompiler.compileAndExpression(JDOQLQueryCompiler.java:466) at org.jpox.store.rdbms.query.JDOQLQueryCompiler.compileExclusiveOrExpression(JDOQLQueryCompiler.java:454) at org.jpox.store.rdbms.query.JDOQLQueryCompiler.compileInclusiveOrExpression(JDOQLQueryCompiler.java:442) at org.jpox.store.rdbms.query.JDOQLQueryCompiler.compileConditionalAndExpression(JDOQLQueryCompiler.java:430) at org.jpox.store.rdbms.query.JDOQLQueryCompiler.compileConditionalOrExpression(JDOQLQueryCompiler.java:412) at org.jpox.store.rdbms.query.JDOQLQueryCompiler.compileExpression(JDOQLQueryCompiler.java:389) at org.jpox.store.rdbms.query.JDOQLQueryCompiler.compileExpressionFromString(JDOQLQueryCompiler.java:369) at org.jpox.store.rdbms.query.JavaQueryCompiler.compileFilter(JavaQueryCompiler.java:280) at org.jpox.store.rdbms.query.JDOQLQueryCompiler.performCompile(JDOQLQueryCompiler.java:189) at org.jpox.store.rdbms.query.JavaQueryCompiler.executionCompile(JavaQueryCompiler.java:188) at org.jpox.store.rdbms.query.JDOQLQuery.compileInternal(JDOQLQuery.java:165) at org.jpox.store.rdbms.query.JDOQLQuery.performExecute(JDOQLQuery.java:246) at org.jpox.store.query.Query.executeWithMap(Query.java:1267) at org.jpox.store.query.Query.executeWithArray(Query.java:1233) at org.jpox.store.query.Query.execute(Query.java:1166) at org.jpox.jdo.JDOQuery.execute(JDOQuery.java:222) at org.jpox.tests.JDOQLContainerTest.testContainsInParameterArray2(JDOQLContainerTest.java:1257)
Error testMapGetAsLiteralWithKeyAsExpression
Cannot perform operation "getMethod" on MapKeyLiteral "('2 doors')" and StringExpression "THIS.MODEL"
javax.jdo.JDOUserException: Cannot perform operation "getMethod" on MapKeyLiteral "('2 doors')" and StringExpression "THIS.MODEL" at org.jpox.jdo.JPOXJDOHelper.getJDOExceptionForJPOXException(JPOXJDOHelper.java:354) at org.jpox.jdo.JDOQuery.execute(JDOQuery.java:227) at org.jpox.tests.JDOQLContainerTest.testMapGetAsLiteralWithKeyAsExpression(JDOQLContainerTest.java:1808) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) NestedThrowablesStackTrace: Cannot perform operation "getMethod" on MapKeyLiteral "('2 doors')" and StringExpression "THIS.MODEL" org.jpox.store.expression.ScalarExpression$IllegalOperationException: Cannot perform operation "getMethod" on MapKeyLiteral "('2 doors')" and StringExpression "THIS.MODEL" at org.jpox.store.expression.MapKeyLiteral.getMethod(MapKeyLiteral.java:152) at org.jpox.store.expression.MapLiteral.getMethod(MapLiteral.java:119) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at org.jpox.store.expression.ScalarExpression.callMethod(ScalarExpression.java:836) at org.jpox.store.rdbms.query.JDOQLQueryCompiler.compilePrimary(JDOQLQueryCompiler.java:669) at org.jpox.store.rdbms.query.JavaQueryCompiler.compileUnaryExpressionNotPlusMinus(JavaQueryCompiler.java:765) at org.jpox.store.rdbms.query.JavaQueryCompiler.compileUnaryExpression(JavaQueryCompiler.java:746) at org.jpox.store.rdbms.query.JavaQueryCompiler.compileMultiplicativeExpression(JavaQueryCompiler.java:699) at org.jpox.store.rdbms.query.JavaQueryCompiler.compileAdditiveExpression(JavaQueryCompiler.java:676) at org.jpox.store.rdbms.query.JDOQLQueryCompiler.compileRelationalExpression(JDOQLQueryCompiler.java:506) at org.jpox.store.rdbms.query.JDOQLQueryCompiler.compileEqualityExpression(JDOQLQueryCompiler.java:484) at org.jpox.store.rdbms.query.JDOQLQueryCompiler.compileAndExpression(JDOQLQueryCompiler.java:466) at org.jpox.store.rdbms.query.JDOQLQueryCompiler.compileExclusiveOrExpression(JDOQLQueryCompiler.java:454) at org.jpox.store.rdbms.query.JDOQLQueryCompiler.compileInclusiveOrExpression(JDOQLQueryCompiler.java:442) at org.jpox.store.rdbms.query.JDOQLQueryCompiler.compileConditionalAndExpression(JDOQLQueryCompiler.java:430) at org.jpox.store.rdbms.query.JDOQLQueryCompiler.compileConditionalOrExpression(JDOQLQueryCompiler.java:412) at org.jpox.store.rdbms.query.JDOQLQueryCompiler.compileExpression(JDOQLQueryCompiler.java:389) at org.jpox.store.rdbms.query.JDOQLQueryCompiler.compileExpressionFromString(JDOQLQueryCompiler.java:369) at org.jpox.store.rdbms.query.JavaQueryCompiler.compileFilter(JavaQueryCompiler.java:280) at org.jpox.store.rdbms.query.JDOQLQueryCompiler.performCompile(JDOQLQueryCompiler.java:189) at org.jpox.store.rdbms.query.JavaQueryCompiler.executionCompile(JavaQueryCompiler.java:188) at org.jpox.store.rdbms.query.JDOQLQuery.compileInternal(JDOQLQuery.java:165) at org.jpox.store.rdbms.query.JDOQLQuery.performExecute(JDOQLQuery.java:246) at org.jpox.store.query.Query.executeWithMap(Query.java:1267) at org.jpox.store.query.Query.executeWithArray(Query.java:1233) at org.jpox.store.query.Query.execute(Query.java:1166) at org.jpox.jdo.JDOQuery.execute(JDOQuery.java:222) at org.jpox.tests.JDOQLContainerTest.testMapGetAsLiteralWithKeyAsExpression(JDOQLContainerTest.java:1808)
Error testQueryUsesContainsTwiceOnFieldUsingWorkaround
[JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.models.company.Manager' AS JPOXMETADATA,THIS.EMPLOYEE_ID,THIS_1.AGE,THIS_1.EMAIL_ADDRESS,THIS_1.FIRSTNAME,THIS_1.GLOBALNUM,THIS_1.LASTNAME,THIS_1.PERSONNUM,THIS_2.MANAGER_EMPLOYEE_ID_OID,THIS_2.SALARY,THIS_2.SALARY_CURRENCY,THIS_2.SERIAL_NO FROM MANAGER THIS INNER JOIN PERSON THIS_1 ON THIS_1.PERSON_ID = THIS.EMPLOYEE_ID INNER JOIN EMPLOYEE THIS_2 ON THIS_2.EMPLOYEE_ID = THIS.EMPLOYEE_ID WHERE EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP1 INNER JOIN PERSON UNBOUND_EMP1_1 ON UNBOUND_EMP1_1.PERSON_ID = UNBOUND_EMP1.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP1 WHERE THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP1.EMPLOYEE_ID = THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_EID) AND EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP2 INNER JOIN PERSON UNBOUND_EMP2_1 ON UNBOUND_EMP2_1.PERSON_ID = UNBOUND_EMP2.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP2 WHERE THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP2.EMPLOYEE_ID = THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_EID) AND UNBOUND_EMP1_1.LASTNAME = ? OR UNBOUND_EMP2_1.LASTNAME = ?" : Column not found: UNBOUND_EMP1_1.LASTNAME in statement [SELECT 'org.jpox.samples.models.company.Manager' AS JPOXMETADATA,THIS.EMPLOYEE_ID,THIS_1.AGE,THIS_1.EMAIL_ADDRESS,THIS_1.FIRSTNAME,THIS_1.GLOBALNUM,THIS_1.LASTNAME,THIS_1.PERSONNUM,THIS_2.MANAGER_EMPLOYEE_ID_OID,THIS_2.SALARY,THIS_2.SALARY_CURRENCY,THIS_2.SERIAL_NO FROM MANAGER THIS INNER JOIN PERSON THIS_1 ON THIS_1.PERSON_ID = THIS.EMPLOYEE_ID INNER JOIN EMPLOYEE THIS_2 ON THIS_2.EMPLOYEE_ID = THIS.EMPLOYEE_ID WHERE EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP1 INNER JOIN PERSON UNBOUND_EMP1_1 ON UNBOUND_EMP1_1.PERSON_ID = UNBOUND_EMP1.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP1 WHERE THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP1.EMPLOYEE_ID = THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_EID) AND EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP2 INNER JOIN PERSON UNBOUND_EMP2_1 ON UNBOUND_EMP2_1.PERSON_ID = UNBOUND_EMP2.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP2 WHERE THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP2.EMPLOYEE_ID = THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_EID) AND UNBOUND_EMP1_1.LASTNAME = ? OR UNBOUND_EMP2_1.LASTNAME = ?].
javax.jdo.JDODataStoreException: [JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.models.company.Manager' AS JPOXMETADATA,THIS.EMPLOYEE_ID,THIS_1.AGE,THIS_1.EMAIL_ADDRESS,THIS_1.FIRSTNAME,THIS_1.GLOBALNUM,THIS_1.LASTNAME,THIS_1.PERSONNUM,THIS_2.MANAGER_EMPLOYEE_ID_OID,THIS_2.SALARY,THIS_2.SALARY_CURRENCY,THIS_2.SERIAL_NO FROM MANAGER THIS INNER JOIN PERSON THIS_1 ON THIS_1.PERSON_ID = THIS.EMPLOYEE_ID INNER JOIN EMPLOYEE THIS_2 ON THIS_2.EMPLOYEE_ID = THIS.EMPLOYEE_ID WHERE EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP1 INNER JOIN PERSON UNBOUND_EMP1_1 ON UNBOUND_EMP1_1.PERSON_ID = UNBOUND_EMP1.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP1 WHERE THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP1.EMPLOYEE_ID = THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_EID) AND EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP2 INNER JOIN PERSON UNBOUND_EMP2_1 ON UNBOUND_EMP2_1.PERSON_ID = UNBOUND_EMP2.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP2 WHERE THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP2.EMPLOYEE_ID = THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_EID) AND UNBOUND_EMP1_1.LASTNAME = ? OR UNBOUND_EMP2_1.LASTNAME = ?" : Column not found: UNBOUND_EMP1_1.LASTNAME in statement [SELECT 'org.jpox.samples.models.company.Manager' AS JPOXMETADATA,THIS.EMPLOYEE_ID,THIS_1.AGE,THIS_1.EMAIL_ADDRESS,THIS_1.FIRSTNAME,THIS_1.GLOBALNUM,THIS_1.LASTNAME,THIS_1.PERSONNUM,THIS_2.MANAGER_EMPLOYEE_ID_OID,THIS_2.SALARY,THIS_2.SALARY_CURRENCY,THIS_2.SERIAL_NO FROM MANAGER THIS INNER JOIN PERSON THIS_1 ON THIS_1.PERSON_ID = THIS.EMPLOYEE_ID INNER JOIN EMPLOYEE THIS_2 ON THIS_2.EMPLOYEE_ID = THIS.EMPLOYEE_ID WHERE EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP1 INNER JOIN PERSON UNBOUND_EMP1_1 ON UNBOUND_EMP1_1.PERSON_ID = UNBOUND_EMP1.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP1 WHERE THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP1.EMPLOYEE_ID = THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_EID) AND EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP2 INNER JOIN PERSON UNBOUND_EMP2_1 ON UNBOUND_EMP2_1.PERSON_ID = UNBOUND_EMP2.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP2 WHERE THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP2.EMPLOYEE_ID = THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_EID) AND UNBOUND_EMP1_1.LASTNAME = ? OR UNBOUND_EMP2_1.LASTNAME = ?]. at org.jpox.jdo.JPOXJDOHelper.getJDOExceptionForJPOXException(JPOXJDOHelper.java:289) at org.jpox.jdo.JDOQuery.execute(JDOQuery.java:209) at org.jpox.tests.JDOQLContainerTest.testQueryUsesContainsTwiceOnFieldUsingWorkaround(JDOQLContainerTest.java:4647) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) NestedThrowablesStackTrace: java.sql.SQLException: Column not found: UNBOUND_EMP1_1.LASTNAME in statement [SELECT 'org.jpox.samples.models.company.Manager' AS JPOXMETADATA,THIS.EMPLOYEE_ID,THIS_1.AGE,THIS_1.EMAIL_ADDRESS,THIS_1.FIRSTNAME,THIS_1.GLOBALNUM,THIS_1.LASTNAME,THIS_1.PERSONNUM,THIS_2.MANAGER_EMPLOYEE_ID_OID,THIS_2.SALARY,THIS_2.SALARY_CURRENCY,THIS_2.SERIAL_NO FROM MANAGER THIS INNER JOIN PERSON THIS_1 ON THIS_1.PERSON_ID = THIS.EMPLOYEE_ID INNER JOIN EMPLOYEE THIS_2 ON THIS_2.EMPLOYEE_ID = THIS.EMPLOYEE_ID WHERE EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP1 INNER JOIN PERSON UNBOUND_EMP1_1 ON UNBOUND_EMP1_1.PERSON_ID = UNBOUND_EMP1.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP1 WHERE THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP1.EMPLOYEE_ID = THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_EID) AND EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP2 INNER JOIN PERSON UNBOUND_EMP2_1 ON UNBOUND_EMP2_1.PERSON_ID = UNBOUND_EMP2.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP2 WHERE THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP2.EMPLOYEE_ID = THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_EID) AND UNBOUND_EMP1_1.LASTNAME = ? OR UNBOUND_EMP2_1.LASTNAME = ?] at org.hsqldb.jdbc.Util.throwError(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source) at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source) at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:181) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:283) at org.jpox.store.rdbms.SQLController.getStatementForQuery(SQLController.java:302) at org.jpox.store.rdbms.query.SQLEvaluator.getStatement(SQLEvaluator.java:270) at org.jpox.store.rdbms.query.SQLEvaluator.evaluate(SQLEvaluator.java:95) at org.jpox.store.rdbms.query.JDOQLQuery.performExecute(JDOQLQuery.java:319) at org.jpox.store.query.Query.executeWithMap(Query.java:1267) at org.jpox.store.query.Query.executeWithArray(Query.java:1233) at org.jpox.store.query.Query.execute(Query.java:1154) at org.jpox.jdo.JDOQuery.execute(JDOQuery.java:204) at org.jpox.tests.JDOQLContainerTest.testQueryUsesContainsTwiceOnFieldUsingWorkaround(JDOQLContainerTest.java:4647)
Error testQueryUsesContainsValueTwiceOnFieldUsingWorkaround
[JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM GYM_WARDROBES THIS_WARDROBES_W1 , WARDROBE UNBOUND_W1 WHERE THIS_WARDROBES_W1.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES_W1.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W1.WARDROBE_ID = THIS_WARDROBES_W1.WARDROBE_ID_VID) AND EXISTS (SELECT 1 FROM GYM_WARDROBES THIS_WARDROBES_W2 , WARDROBE UNBOUND_W2 WHERE THIS_WARDROBES_W2.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES_W2.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W2.WARDROBE_ID = THIS_WARDROBES_W2.WARDROBE_ID_VID) AND UNBOUND_W1.MODEL = ? OR UNBOUND_W2.MODEL = ?" : Column not found: UNBOUND_W1.MODEL in statement [SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM GYM_WARDROBES THIS_WARDROBES_W1 , WARDROBE UNBOUND_W1 WHERE THIS_WARDROBES_W1.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES_W1.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W1.WARDROBE_ID = THIS_WARDROBES_W1.WARDROBE_ID_VID) AND EXISTS (SELECT 1 FROM GYM_WARDROBES THIS_WARDROBES_W2 , WARDROBE UNBOUND_W2 WHERE THIS_WARDROBES_W2.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES_W2.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W2.WARDROBE_ID = THIS_WARDROBES_W2.WARDROBE_ID_VID) AND UNBOUND_W1.MODEL = ? OR UNBOUND_W2.MODEL = ?].
javax.jdo.JDODataStoreException: [JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM GYM_WARDROBES THIS_WARDROBES_W1 , WARDROBE UNBOUND_W1 WHERE THIS_WARDROBES_W1.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES_W1.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W1.WARDROBE_ID = THIS_WARDROBES_W1.WARDROBE_ID_VID) AND EXISTS (SELECT 1 FROM GYM_WARDROBES THIS_WARDROBES_W2 , WARDROBE UNBOUND_W2 WHERE THIS_WARDROBES_W2.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES_W2.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W2.WARDROBE_ID = THIS_WARDROBES_W2.WARDROBE_ID_VID) AND UNBOUND_W1.MODEL = ? OR UNBOUND_W2.MODEL = ?" : Column not found: UNBOUND_W1.MODEL in statement [SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM GYM_WARDROBES THIS_WARDROBES_W1 , WARDROBE UNBOUND_W1 WHERE THIS_WARDROBES_W1.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES_W1.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W1.WARDROBE_ID = THIS_WARDROBES_W1.WARDROBE_ID_VID) AND EXISTS (SELECT 1 FROM GYM_WARDROBES THIS_WARDROBES_W2 , WARDROBE UNBOUND_W2 WHERE THIS_WARDROBES_W2.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES_W2.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W2.WARDROBE_ID = THIS_WARDROBES_W2.WARDROBE_ID_VID) AND UNBOUND_W1.MODEL = ? OR UNBOUND_W2.MODEL = ?]. at org.jpox.jdo.JPOXJDOHelper.getJDOExceptionForJPOXException(JPOXJDOHelper.java:289) at org.jpox.jdo.JDOQuery.execute(JDOQuery.java:209) at org.jpox.tests.JDOQLContainerTest.testQueryUsesContainsValueTwiceOnFieldUsingWorkaround(JDOQLContainerTest.java:4733) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) NestedThrowablesStackTrace: java.sql.SQLException: Column not found: UNBOUND_W1.MODEL in statement [SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM GYM_WARDROBES THIS_WARDROBES_W1 , WARDROBE UNBOUND_W1 WHERE THIS_WARDROBES_W1.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES_W1.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W1.WARDROBE_ID = THIS_WARDROBES_W1.WARDROBE_ID_VID) AND EXISTS (SELECT 1 FROM GYM_WARDROBES THIS_WARDROBES_W2 , WARDROBE UNBOUND_W2 WHERE THIS_WARDROBES_W2.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES_W2.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W2.WARDROBE_ID = THIS_WARDROBES_W2.WARDROBE_ID_VID) AND UNBOUND_W1.MODEL = ? OR UNBOUND_W2.MODEL = ?] at org.hsqldb.jdbc.Util.throwError(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source) at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source) at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:181) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:283) at org.jpox.store.rdbms.SQLController.getStatementForQuery(SQLController.java:302) at org.jpox.store.rdbms.query.SQLEvaluator.getStatement(SQLEvaluator.java:270) at org.jpox.store.rdbms.query.SQLEvaluator.evaluate(SQLEvaluator.java:95) at org.jpox.store.rdbms.query.JDOQLQuery.performExecute(JDOQLQuery.java:319) at org.jpox.store.query.Query.executeWithMap(Query.java:1267) at org.jpox.store.query.Query.executeWithArray(Query.java:1233) at org.jpox.store.query.Query.execute(Query.java:1154) at org.jpox.jdo.JDOQuery.execute(JDOQuery.java:204) at org.jpox.tests.JDOQLContainerTest.testQueryUsesContainsValueTwiceOnFieldUsingWorkaround(JDOQLContainerTest.java:4733)
Error testQueryUsesContainsValueTwiceOnFieldUsingWorkaroundInverse
[JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE_W1 WHERE THIS_WARDROBESINVERSE_W1.GYM_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE_W1.GYM_GYM_ID_OID = THIS.GYM_ID) AND EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE_W2 WHERE THIS_WARDROBESINVERSE_W2.GYM_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE_W2.GYM_GYM_ID_OID = THIS.GYM_ID) AND THIS_WARDROBESINVERSE_W1.MODEL = ? OR THIS_WARDROBESINVERSE_W2.MODEL = ?" : Column not found: THIS_WARDROBESINVERSE_W1.MODEL in statement [SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE_W1 WHERE THIS_WARDROBESINVERSE_W1.GYM_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE_W1.GYM_GYM_ID_OID = THIS.GYM_ID) AND EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE_W2 WHERE THIS_WARDROBESINVERSE_W2.GYM_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE_W2.GYM_GYM_ID_OID = THIS.GYM_ID) AND THIS_WARDROBESINVERSE_W1.MODEL = ? OR THIS_WARDROBESINVERSE_W2.MODEL = ?].
javax.jdo.JDODataStoreException: [JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE_W1 WHERE THIS_WARDROBESINVERSE_W1.GYM_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE_W1.GYM_GYM_ID_OID = THIS.GYM_ID) AND EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE_W2 WHERE THIS_WARDROBESINVERSE_W2.GYM_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE_W2.GYM_GYM_ID_OID = THIS.GYM_ID) AND THIS_WARDROBESINVERSE_W1.MODEL = ? OR THIS_WARDROBESINVERSE_W2.MODEL = ?" : Column not found: THIS_WARDROBESINVERSE_W1.MODEL in statement [SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE_W1 WHERE THIS_WARDROBESINVERSE_W1.GYM_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE_W1.GYM_GYM_ID_OID = THIS.GYM_ID) AND EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE_W2 WHERE THIS_WARDROBESINVERSE_W2.GYM_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE_W2.GYM_GYM_ID_OID = THIS.GYM_ID) AND THIS_WARDROBESINVERSE_W1.MODEL = ? OR THIS_WARDROBESINVERSE_W2.MODEL = ?]. at org.jpox.jdo.JPOXJDOHelper.getJDOExceptionForJPOXException(JPOXJDOHelper.java:289) at org.jpox.jdo.JDOQuery.execute(JDOQuery.java:209) at org.jpox.tests.JDOQLContainerTest.testQueryUsesContainsValueTwiceOnFieldUsingWorkaroundInverse(JDOQLContainerTest.java:4829) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) NestedThrowablesStackTrace: java.sql.SQLException: Column not found: THIS_WARDROBESINVERSE_W1.MODEL in statement [SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE_W1 WHERE THIS_WARDROBESINVERSE_W1.GYM_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE_W1.GYM_GYM_ID_OID = THIS.GYM_ID) AND EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE_W2 WHERE THIS_WARDROBESINVERSE_W2.GYM_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE_W2.GYM_GYM_ID_OID = THIS.GYM_ID) AND THIS_WARDROBESINVERSE_W1.MODEL = ? OR THIS_WARDROBESINVERSE_W2.MODEL = ?] at org.hsqldb.jdbc.Util.throwError(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source) at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source) at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:181) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:283) at org.jpox.store.rdbms.SQLController.getStatementForQuery(SQLController.java:302) at org.jpox.store.rdbms.query.SQLEvaluator.getStatement(SQLEvaluator.java:270) at org.jpox.store.rdbms.query.SQLEvaluator.evaluate(SQLEvaluator.java:95) at org.jpox.store.rdbms.query.JDOQLQuery.performExecute(JDOQLQuery.java:319) at org.jpox.store.query.Query.executeWithMap(Query.java:1267) at org.jpox.store.query.Query.executeWithArray(Query.java:1233) at org.jpox.store.query.Query.execute(Query.java:1154) at org.jpox.jdo.JDOQuery.execute(JDOQuery.java:204) at org.jpox.tests.JDOQLContainerTest.testQueryUsesContainsValueTwiceOnFieldUsingWorkaroundInverse(JDOQLContainerTest.java:4829)
Error testQueryUsesContainsKeyTwiceOnFieldUsingWorkaroundInverse
[JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE2_W1 INNER JOIN WARDROBE UNBOUND_W1 ON THIS_WARDROBESINVERSE2_W1.WARDROBE_ID = UNBOUND_W1.WARDROBE_ID WHERE THIS_WARDROBESINVERSE2_W1.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE2_W1.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID) AND EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE2_W2 INNER JOIN WARDROBE UNBOUND_W2 ON THIS_WARDROBESINVERSE2_W2.WARDROBE_ID = UNBOUND_W2.WARDROBE_ID WHERE THIS_WARDROBESINVERSE2_W2.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE2_W2.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID) AND UNBOUND_W1.MODEL = ? OR UNBOUND_W2.MODEL = ?" : Column not found: UNBOUND_W1.MODEL in statement [SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE2_W1 INNER JOIN WARDROBE UNBOUND_W1 ON THIS_WARDROBESINVERSE2_W1.WARDROBE_ID = UNBOUND_W1.WARDROBE_ID WHERE THIS_WARDROBESINVERSE2_W1.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE2_W1.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID) AND EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE2_W2 INNER JOIN WARDROBE UNBOUND_W2 ON THIS_WARDROBESINVERSE2_W2.WARDROBE_ID = UNBOUND_W2.WARDROBE_ID WHERE THIS_WARDROBESINVERSE2_W2.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE2_W2.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID) AND UNBOUND_W1.MODEL = ? OR UNBOUND_W2.MODEL = ?].
javax.jdo.JDODataStoreException: [JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE2_W1 INNER JOIN WARDROBE UNBOUND_W1 ON THIS_WARDROBESINVERSE2_W1.WARDROBE_ID = UNBOUND_W1.WARDROBE_ID WHERE THIS_WARDROBESINVERSE2_W1.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE2_W1.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID) AND EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE2_W2 INNER JOIN WARDROBE UNBOUND_W2 ON THIS_WARDROBESINVERSE2_W2.WARDROBE_ID = UNBOUND_W2.WARDROBE_ID WHERE THIS_WARDROBESINVERSE2_W2.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE2_W2.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID) AND UNBOUND_W1.MODEL = ? OR UNBOUND_W2.MODEL = ?" : Column not found: UNBOUND_W1.MODEL in statement [SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE2_W1 INNER JOIN WARDROBE UNBOUND_W1 ON THIS_WARDROBESINVERSE2_W1.WARDROBE_ID = UNBOUND_W1.WARDROBE_ID WHERE THIS_WARDROBESINVERSE2_W1.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE2_W1.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID) AND EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE2_W2 INNER JOIN WARDROBE UNBOUND_W2 ON THIS_WARDROBESINVERSE2_W2.WARDROBE_ID = UNBOUND_W2.WARDROBE_ID WHERE THIS_WARDROBESINVERSE2_W2.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE2_W2.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID) AND UNBOUND_W1.MODEL = ? OR UNBOUND_W2.MODEL = ?]. at org.jpox.jdo.JPOXJDOHelper.getJDOExceptionForJPOXException(JPOXJDOHelper.java:289) at org.jpox.jdo.JDOQuery.execute(JDOQuery.java:209) at org.jpox.tests.JDOQLContainerTest.testQueryUsesContainsKeyTwiceOnFieldUsingWorkaroundInverse(JDOQLContainerTest.java:4923) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) NestedThrowablesStackTrace: java.sql.SQLException: Column not found: UNBOUND_W1.MODEL in statement [SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE2_W1 INNER JOIN WARDROBE UNBOUND_W1 ON THIS_WARDROBESINVERSE2_W1.WARDROBE_ID = UNBOUND_W1.WARDROBE_ID WHERE THIS_WARDROBESINVERSE2_W1.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE2_W1.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID) AND EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE2_W2 INNER JOIN WARDROBE UNBOUND_W2 ON THIS_WARDROBESINVERSE2_W2.WARDROBE_ID = UNBOUND_W2.WARDROBE_ID WHERE THIS_WARDROBESINVERSE2_W2.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE2_W2.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID) AND UNBOUND_W1.MODEL = ? OR UNBOUND_W2.MODEL = ?] at org.hsqldb.jdbc.Util.throwError(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source) at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source) at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:181) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:283) at org.jpox.store.rdbms.SQLController.getStatementForQuery(SQLController.java:302) at org.jpox.store.rdbms.query.SQLEvaluator.getStatement(SQLEvaluator.java:270) at org.jpox.store.rdbms.query.SQLEvaluator.evaluate(SQLEvaluator.java:95) at org.jpox.store.rdbms.query.JDOQLQuery.performExecute(JDOQLQuery.java:319) at org.jpox.store.query.Query.executeWithMap(Query.java:1267) at org.jpox.store.query.Query.executeWithArray(Query.java:1233) at org.jpox.store.query.Query.execute(Query.java:1154) at org.jpox.jdo.JDOQuery.execute(JDOQuery.java:204) at org.jpox.tests.JDOQLContainerTest.testQueryUsesContainsKeyTwiceOnFieldUsingWorkaroundInverse(JDOQLContainerTest.java:4923)
Error testQueryUsesContainsKeyTwiceOnFieldUsingWorkaround
[JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM GYM_WARDROBES2 THIS_WARDROBES2_W1 , WARDROBE UNBOUND_W1 WHERE THIS_WARDROBES2_W1.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES2_W1.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W1.WARDROBE_ID = THIS_WARDROBES2_W1.WARDROBE_ID_KID) AND EXISTS (SELECT 1 FROM GYM_WARDROBES2 THIS_WARDROBES2_W2 , WARDROBE UNBOUND_W2 WHERE THIS_WARDROBES2_W2.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES2_W2.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W2.WARDROBE_ID = THIS_WARDROBES2_W2.WARDROBE_ID_KID) AND UNBOUND_W1.MODEL = ? OR UNBOUND_W2.MODEL = ?" : Column not found: UNBOUND_W1.MODEL in statement [SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM GYM_WARDROBES2 THIS_WARDROBES2_W1 , WARDROBE UNBOUND_W1 WHERE THIS_WARDROBES2_W1.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES2_W1.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W1.WARDROBE_ID = THIS_WARDROBES2_W1.WARDROBE_ID_KID) AND EXISTS (SELECT 1 FROM GYM_WARDROBES2 THIS_WARDROBES2_W2 , WARDROBE UNBOUND_W2 WHERE THIS_WARDROBES2_W2.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES2_W2.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W2.WARDROBE_ID = THIS_WARDROBES2_W2.WARDROBE_ID_KID) AND UNBOUND_W1.MODEL = ? OR UNBOUND_W2.MODEL = ?].
javax.jdo.JDODataStoreException: [JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM GYM_WARDROBES2 THIS_WARDROBES2_W1 , WARDROBE UNBOUND_W1 WHERE THIS_WARDROBES2_W1.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES2_W1.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W1.WARDROBE_ID = THIS_WARDROBES2_W1.WARDROBE_ID_KID) AND EXISTS (SELECT 1 FROM GYM_WARDROBES2 THIS_WARDROBES2_W2 , WARDROBE UNBOUND_W2 WHERE THIS_WARDROBES2_W2.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES2_W2.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W2.WARDROBE_ID = THIS_WARDROBES2_W2.WARDROBE_ID_KID) AND UNBOUND_W1.MODEL = ? OR UNBOUND_W2.MODEL = ?" : Column not found: UNBOUND_W1.MODEL in statement [SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM GYM_WARDROBES2 THIS_WARDROBES2_W1 , WARDROBE UNBOUND_W1 WHERE THIS_WARDROBES2_W1.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES2_W1.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W1.WARDROBE_ID = THIS_WARDROBES2_W1.WARDROBE_ID_KID) AND EXISTS (SELECT 1 FROM GYM_WARDROBES2 THIS_WARDROBES2_W2 , WARDROBE UNBOUND_W2 WHERE THIS_WARDROBES2_W2.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES2_W2.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W2.WARDROBE_ID = THIS_WARDROBES2_W2.WARDROBE_ID_KID) AND UNBOUND_W1.MODEL = ? OR UNBOUND_W2.MODEL = ?]. at org.jpox.jdo.JPOXJDOHelper.getJDOExceptionForJPOXException(JPOXJDOHelper.java:289) at org.jpox.jdo.JDOQuery.execute(JDOQuery.java:209) at org.jpox.tests.JDOQLContainerTest.testQueryUsesContainsKeyTwiceOnFieldUsingWorkaround(JDOQLContainerTest.java:5019) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) NestedThrowablesStackTrace: java.sql.SQLException: Column not found: UNBOUND_W1.MODEL in statement [SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM GYM_WARDROBES2 THIS_WARDROBES2_W1 , WARDROBE UNBOUND_W1 WHERE THIS_WARDROBES2_W1.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES2_W1.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W1.WARDROBE_ID = THIS_WARDROBES2_W1.WARDROBE_ID_KID) AND EXISTS (SELECT 1 FROM GYM_WARDROBES2 THIS_WARDROBES2_W2 , WARDROBE UNBOUND_W2 WHERE THIS_WARDROBES2_W2.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES2_W2.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W2.WARDROBE_ID = THIS_WARDROBES2_W2.WARDROBE_ID_KID) AND UNBOUND_W1.MODEL = ? OR UNBOUND_W2.MODEL = ?] at org.hsqldb.jdbc.Util.throwError(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source) at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source) at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:181) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:283) at org.jpox.store.rdbms.SQLController.getStatementForQuery(SQLController.java:302) at org.jpox.store.rdbms.query.SQLEvaluator.getStatement(SQLEvaluator.java:270) at org.jpox.store.rdbms.query.SQLEvaluator.evaluate(SQLEvaluator.java:95) at org.jpox.store.rdbms.query.JDOQLQuery.performExecute(JDOQLQuery.java:319) at org.jpox.store.query.Query.executeWithMap(Query.java:1267) at org.jpox.store.query.Query.executeWithArray(Query.java:1233) at org.jpox.store.query.Query.execute(Query.java:1154) at org.jpox.jdo.JDOQuery.execute(JDOQuery.java:204) at org.jpox.tests.JDOQLContainerTest.testQueryUsesContainsKeyTwiceOnFieldUsingWorkaround(JDOQLContainerTest.java:5019)
Error testQueryUsesContainsTwiceOnFieldNoNamespace
[JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.models.company.Manager' AS JPOXMETADATA,THIS.EMPLOYEE_ID,THIS_1.AGE,THIS_1.EMAIL_ADDRESS,THIS_1.FIRSTNAME,THIS_1.GLOBALNUM,THIS_1.LASTNAME,THIS_1.PERSONNUM,THIS_2.MANAGER_EMPLOYEE_ID_OID,THIS_2.SALARY,THIS_2.SALARY_CURRENCY,THIS_2.SERIAL_NO FROM MANAGER THIS INNER JOIN PERSON THIS_1 ON THIS_1.PERSON_ID = THIS.EMPLOYEE_ID INNER JOIN EMPLOYEE THIS_2 ON THIS_2.EMPLOYEE_ID = THIS.EMPLOYEE_ID WHERE EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP1 INNER JOIN PERSON UNBOUND_EMP1_1 ON UNBOUND_EMP1_1.PERSON_ID = UNBOUND_EMP1.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP1 WHERE THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP1.EMPLOYEE_ID = THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_EID AND UNBOUND_EMP1_1.LASTNAME = ?) AND EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP2 INNER JOIN PERSON UNBOUND_EMP2_1 ON UNBOUND_EMP2_1.PERSON_ID = UNBOUND_EMP2.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP2 WHERE THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP2.EMPLOYEE_ID = THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_EID) AND UNBOUND_EMP2_1.LASTNAME = ?" : Column not found: UNBOUND_EMP2_1.LASTNAME in statement [SELECT 'org.jpox.samples.models.company.Manager' AS JPOXMETADATA,THIS.EMPLOYEE_ID,THIS_1.AGE,THIS_1.EMAIL_ADDRESS,THIS_1.FIRSTNAME,THIS_1.GLOBALNUM,THIS_1.LASTNAME,THIS_1.PERSONNUM,THIS_2.MANAGER_EMPLOYEE_ID_OID,THIS_2.SALARY,THIS_2.SALARY_CURRENCY,THIS_2.SERIAL_NO FROM MANAGER THIS INNER JOIN PERSON THIS_1 ON THIS_1.PERSON_ID = THIS.EMPLOYEE_ID INNER JOIN EMPLOYEE THIS_2 ON THIS_2.EMPLOYEE_ID = THIS.EMPLOYEE_ID WHERE EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP1 INNER JOIN PERSON UNBOUND_EMP1_1 ON UNBOUND_EMP1_1.PERSON_ID = UNBOUND_EMP1.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP1 WHERE THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP1.EMPLOYEE_ID = THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_EID AND UNBOUND_EMP1_1.LASTNAME = ?) AND EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP2 INNER JOIN PERSON UNBOUND_EMP2_1 ON UNBOUND_EMP2_1.PERSON_ID = UNBOUND_EMP2.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP2 WHERE THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP2.EMPLOYEE_ID = THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_EID) AND UNBOUND_EMP2_1.LASTNAME = ?].
javax.jdo.JDODataStoreException: [JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.models.company.Manager' AS JPOXMETADATA,THIS.EMPLOYEE_ID,THIS_1.AGE,THIS_1.EMAIL_ADDRESS,THIS_1.FIRSTNAME,THIS_1.GLOBALNUM,THIS_1.LASTNAME,THIS_1.PERSONNUM,THIS_2.MANAGER_EMPLOYEE_ID_OID,THIS_2.SALARY,THIS_2.SALARY_CURRENCY,THIS_2.SERIAL_NO FROM MANAGER THIS INNER JOIN PERSON THIS_1 ON THIS_1.PERSON_ID = THIS.EMPLOYEE_ID INNER JOIN EMPLOYEE THIS_2 ON THIS_2.EMPLOYEE_ID = THIS.EMPLOYEE_ID WHERE EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP1 INNER JOIN PERSON UNBOUND_EMP1_1 ON UNBOUND_EMP1_1.PERSON_ID = UNBOUND_EMP1.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP1 WHERE THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP1.EMPLOYEE_ID = THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_EID AND UNBOUND_EMP1_1.LASTNAME = ?) AND EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP2 INNER JOIN PERSON UNBOUND_EMP2_1 ON UNBOUND_EMP2_1.PERSON_ID = UNBOUND_EMP2.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP2 WHERE THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP2.EMPLOYEE_ID = THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_EID) AND UNBOUND_EMP2_1.LASTNAME = ?" : Column not found: UNBOUND_EMP2_1.LASTNAME in statement [SELECT 'org.jpox.samples.models.company.Manager' AS JPOXMETADATA,THIS.EMPLOYEE_ID,THIS_1.AGE,THIS_1.EMAIL_ADDRESS,THIS_1.FIRSTNAME,THIS_1.GLOBALNUM,THIS_1.LASTNAME,THIS_1.PERSONNUM,THIS_2.MANAGER_EMPLOYEE_ID_OID,THIS_2.SALARY,THIS_2.SALARY_CURRENCY,THIS_2.SERIAL_NO FROM MANAGER THIS INNER JOIN PERSON THIS_1 ON THIS_1.PERSON_ID = THIS.EMPLOYEE_ID INNER JOIN EMPLOYEE THIS_2 ON THIS_2.EMPLOYEE_ID = THIS.EMPLOYEE_ID WHERE EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP1 INNER JOIN PERSON UNBOUND_EMP1_1 ON UNBOUND_EMP1_1.PERSON_ID = UNBOUND_EMP1.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP1 WHERE THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP1.EMPLOYEE_ID = THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_EID AND UNBOUND_EMP1_1.LASTNAME = ?) AND EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP2 INNER JOIN PERSON UNBOUND_EMP2_1 ON UNBOUND_EMP2_1.PERSON_ID = UNBOUND_EMP2.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP2 WHERE THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP2.EMPLOYEE_ID = THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_EID) AND UNBOUND_EMP2_1.LASTNAME = ?]. at org.jpox.jdo.JPOXJDOHelper.getJDOExceptionForJPOXException(JPOXJDOHelper.java:289) at org.jpox.jdo.JDOQuery.execute(JDOQuery.java:209) at org.jpox.tests.JDOQLContainerTest.testQueryUsesContainsTwiceOnFieldNoNamespace(JDOQLContainerTest.java:5766) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) NestedThrowablesStackTrace: java.sql.SQLException: Column not found: UNBOUND_EMP2_1.LASTNAME in statement [SELECT 'org.jpox.samples.models.company.Manager' AS JPOXMETADATA,THIS.EMPLOYEE_ID,THIS_1.AGE,THIS_1.EMAIL_ADDRESS,THIS_1.FIRSTNAME,THIS_1.GLOBALNUM,THIS_1.LASTNAME,THIS_1.PERSONNUM,THIS_2.MANAGER_EMPLOYEE_ID_OID,THIS_2.SALARY,THIS_2.SALARY_CURRENCY,THIS_2.SERIAL_NO FROM MANAGER THIS INNER JOIN PERSON THIS_1 ON THIS_1.PERSON_ID = THIS.EMPLOYEE_ID INNER JOIN EMPLOYEE THIS_2 ON THIS_2.EMPLOYEE_ID = THIS.EMPLOYEE_ID WHERE EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP1 INNER JOIN PERSON UNBOUND_EMP1_1 ON UNBOUND_EMP1_1.PERSON_ID = UNBOUND_EMP1.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP1 WHERE THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP1.EMPLOYEE_ID = THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_EID AND UNBOUND_EMP1_1.LASTNAME = ?) AND EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP2 INNER JOIN PERSON UNBOUND_EMP2_1 ON UNBOUND_EMP2_1.PERSON_ID = UNBOUND_EMP2.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP2 WHERE THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP2.EMPLOYEE_ID = THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_EID) AND UNBOUND_EMP2_1.LASTNAME = ?] at org.hsqldb.jdbc.Util.throwError(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source) at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source) at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:181) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:283) at org.jpox.store.rdbms.SQLController.getStatementForQuery(SQLController.java:302) at org.jpox.store.rdbms.query.SQLEvaluator.getStatement(SQLEvaluator.java:270) at org.jpox.store.rdbms.query.SQLEvaluator.evaluate(SQLEvaluator.java:95) at org.jpox.store.rdbms.query.JDOQLQuery.performExecute(JDOQLQuery.java:319) at org.jpox.store.query.Query.executeWithMap(Query.java:1267) at org.jpox.store.query.Query.executeWithArray(Query.java:1233) at org.jpox.store.query.Query.execute(Query.java:1154) at org.jpox.jdo.JDOQuery.execute(JDOQuery.java:204) at org.jpox.tests.JDOQLContainerTest.testQueryUsesContainsTwiceOnFieldNoNamespace(JDOQLContainerTest.java:5766)
Failure testOneToOneUniTemporaryStates
Field value of former persistent-new-deleted (now transient) object has been changed expected:<JPOX Corporation> but was:<null>
junit.framework.ComparisonFailure: Field value of former persistent-new-deleted (now transient) object has been changed expected:<JPOX Corporation> but was:<null> at org.jpox.tests.ReachabilityTest.testOneToOneUniTemporaryStates(ReachabilityTest.java:541)
Failure test1to1UnidirInheritanceSubclassTable
Number of readers who read "Daily Mail" newspaper was incorrect expected:<0> but was:<1>
junit.framework.AssertionFailedError: Number of readers who read "Daily Mail" newspaper was incorrect expected:<0> but was:<1> at org.jpox.tests.RelationshipTest.test1to1UnidirInheritanceSubclassTable(RelationshipTest.java:2232)
Error testSetResultCartesianProductMap
implement this
java.lang.RuntimeException: implement this at org.jpox.tests.JDOQLResultTest.testSetResultCartesianProductMap(JDOQLResultTest.java:606)
Failure testSetFK
Exception thrown during create of set of interface objects using FK : [JPOX-056041] Class "org.jpox.samples.interfaces.ShapeHolder3" has collection field "shapeList" and this has no mapping in the table for the index of the element class "org.jpox.samples.interfaces.SquareInverse". Maybe you declared the field as a java.util.Collection and instantiated it as a java.util.List yet omitted the <order> element in the MetaData ?
junit.framework.AssertionFailedError: Exception thrown during create of set of interface objects using FK : [JPOX-056041] Class "org.jpox.samples.interfaces.ShapeHolder3" has collection field "shapeList" and this has no mapping in the table for the index of the element class "org.jpox.samples.interfaces.SquareInverse". Maybe you declared the field as a java.util.Collection and instantiated it as a java.util.List yet omitted the <order> element in the MetaData ? at org.jpox.tests.InterfacesTest.testSetFK(InterfacesTest.java:571)
Error testListFK
[JPOX-056041] Class "org.jpox.samples.interfaces.ShapeHolder3" has collection field "shapeList" and this has no mapping in the table for the index of the element class "org.jpox.samples.interfaces.SquareInverse". Maybe you declared the field as a java.util.Collection and instantiated it as a java.util.List yet omitted the <order> element in the MetaData ?
javax.jdo.JDOUserException: [JPOX-056041] Class "org.jpox.samples.interfaces.ShapeHolder3" has collection field "shapeList" and this has no mapping in the table for the index of the element class "org.jpox.samples.interfaces.SquareInverse". Maybe you declared the field as a java.util.Collection and instantiated it as a java.util.List yet omitted the <order> element in the MetaData ? at org.jpox.jdo.JPOXJDOHelper.getJDOExceptionForJPOXException(JPOXJDOHelper.java:354) at org.jpox.jdo.AbstractPersistenceManager.jdoMakePersistent(AbstractPersistenceManager.java:646) at org.jpox.jdo.AbstractPersistenceManager.makePersistent(AbstractPersistenceManager.java:666) at org.jpox.tests.InterfacesTest.testListFK(InterfacesTest.java:617) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) NestedThrowablesStackTrace: [JPOX-056041] Class "org.jpox.samples.interfaces.ShapeHolder3" has collection field "shapeList" and this has no mapping in the table for the index of the element class "org.jpox.samples.interfaces.SquareInverse". Maybe you declared the field as a java.util.Collection and instantiated it as a java.util.List yet omitted the <order> element in the MetaData ? org.jpox.exceptions.JPOXUserException: [JPOX-056041] Class "org.jpox.samples.interfaces.ShapeHolder3" has collection field "shapeList" and this has no mapping in the table for the index of the element class "org.jpox.samples.interfaces.SquareInverse". Maybe you declared the field as a java.util.Collection and instantiated it as a java.util.List yet omitted the <order> element in the MetaData ? at org.jpox.store.rdbms.scostore.FKListStore.<init>(FKListStore.java:205) at org.jpox.store.rdbms.RDBMSManager.getBackingStoreForCollection(RDBMSManager.java:1117) at org.jpox.store.mapping.CollectionMapping.getBackingStore(CollectionMapping.java:97) at org.jpox.store.mapping.CollectionMapping.postInsert(CollectionMapping.java:236) at org.jpox.store.rdbms.request.InsertRequest.execute(InsertRequest.java:450) at org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2888) at org.jpox.store.MappedStoreManager.insertObject(MappedStoreManager.java:180) at org.jpox.state.JDOStateManagerImpl.internalMakePersistent(JDOStateManagerImpl.java:3108) at org.jpox.state.JDOStateManagerImpl.makePersistent(JDOStateManagerImpl.java:3088) at org.jpox.ObjectManagerImpl.persistObjectInternal(ObjectManagerImpl.java:1166) at org.jpox.ObjectManagerImpl.persistObject(ObjectManagerImpl.java:1017) at org.jpox.jdo.AbstractPersistenceManager.jdoMakePersistent(AbstractPersistenceManager.java:641) at org.jpox.jdo.AbstractPersistenceManager.makePersistent(AbstractPersistenceManager.java:666) at org.jpox.tests.InterfacesTest.testListFK(InterfacesTest.java:617)