Development
Documentation
Testing
Summary

[ summary] [ package list] [ test cases]

Tests Errors Failures Success rate Time(s)
713 9 9 97.48% 113.23

Note: failures are anticipated and checked for with assertions while errors are unanticipated.

Package List

[ summary] [ package list] [ test cases]

Package Tests Errors Failures Success Rate Time
org.jpox.tests 713 9 9 97.48% 113.23

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

org.jpox.tests
Class Tests Errors Failures Success Rate Time
Success HashSetTest 18 0 0 100.00% 1.700
Success SecondaryTableTest 2 0 0 100.00% 0.398
Success SchemaTest 27 0 0 100.00% 4.347
Success PersistentAbstractClassesTest 5 0 0 100.00% 0.949
Success ArrayListTest 23 0 0 100.00% 2.047
Success ListTest 22 0 0 100.00% 2.004
Failure JDOQLBasicTest 58 0 3 94.83% 9.750
Success TreeSetTest 18 0 0 100.00% 1.837
Error JDOQLContainerTest 75 7 1 89.33% 14.780
Success MapTest 27 0 0 100.00% 4.097
Success ApplicationIdentityTest 23 0 0 100.00% 6.561
Success ValueGeneratorTest 11 0 0 100.00% 6.812
Success OptimisticTest 21 0 0 100.00% 1.107
Success SQLQueryTest 19 0 0 100.00% 1.895
Success PersistenceModelsTest 6 0 0 100.00% 2.302
Success CollectionSerialTest 10 0 0 100.00% 0.996
Success HashtableTest 19 0 0 100.00% 2.422
Success SetTest 21 0 0 100.00% 1.948
Failure CompoundIdentityTest 17 0 1 94.12% 2.470
Failure ReachabilityTest 14 0 1 92.86% 7.054
Success MapForeignKeyTest 2 0 0 100.00% 1.169
Failure RelationshipTest 36 0 2 94.44% 4.693
Success LinkedListTest 19 0 0 100.00% 1.753
Success VectorTest 19 0 0 100.00% 1.746
Success PersistentInterfacesTest 7 0 0 100.00% 1.365
Success StackTest 19 0 0 100.00% 1.751
Success LinkedHashMapTest 19 0 0 100.00% 2.440
Error JDOQLResultTest 29 1 0 96.55% 3.385
Success DependentFieldTest 14 0 0 100.00% 4.517
Success AbstractClassesTest 16 0 0 100.00% 1.451
Success HashMapTest 19 0 0 100.00% 2.438
Error InterfacesTest 16 1 1 87.50% 3.674
Success QueueTest 1 0 0 100.00% 0.634
Success CollectionPrimitiveTest 3 0 0 100.00% 0.609
Success LinkedHashSetTest 18 0 0 100.00% 1.748
Success ObjectsTest 2 0 0 100.00% 0.840
Success InheritanceTest 13 0 0 100.00% 1.187
Success CollectionTest 18 0 0 100.00% 1.727
Success PropertiesTest 7 0 0 100.00% 0.627
Test Cases

[ summary] [ package list] [ test cases]

HashSetTest
Success testNormalAddCollection 0.32
Success testNormalChildAddCollection 0.06
Success testNormalRemoveCollection 0.12
Success testNormalRetainCollection 0.09
Success testNormalChildRemoveCollection 0.07
Success testNormalRemoveItem 0.06
Success testNormalClearIsEmpty 0.05
Success testNormalInheritance 0.06
Success testNormalQuery 0.18
Success testNormalAttachDetach 0.13
Success testInverseAddCollection 0.06
Success testInverseRemoveCollection 0.06
Success testInverseRetainCollection 0.06
Success testInverseAddElement 0.06
Success testInverseClearIsEmpty 0.06
Success testInverseInheritance 0.05
Success testInverseQuery 0.07
Success testInverseAttachDetach 0.12
SecondaryTableTest
Success testSecondaryTable 0.34
Success testQuerySecondaryTable 0.04
SchemaTest
Success testTableColumnNames 0.59
Success testColumnSpecifications 0.02
Success testUnique 0.25
Success testColumnWidth 0.54
Success testReadOnlyDatastore 0.37
Success testFixedDatastore 0.47
Success testDuplicateColumnNamesInSimpleAssociations 0.13
Success test1To1Bidir 0.07
Success testSecondaryTableSchema 0.03
Success testInterfaces 0.23
Success testObjectFields 0.06
Success test1To1UnidirectionalSchema 0.04
Success testOverridingColumnsBaseNewTableSubNewTable 0.31
Success testOverridingColumnsBaseSubclassTableSubNewTable 0.02
Success testOverridingColumnsBaseNewTableSubSuperclassTable 0.01
Success testEmbeddedPCSchema 0.15
Success testEmbeddedPCCollectionSchema 0.02
Success testEmbeddedPCListSchema 0.01
Success testEmbeddedPCMapSchema 0.03
Success testMtoN 0.09
Success testArrayNonPC 0.23
Success testArrayPC 0.11
Success testSet 0.25
Success testList 0.11
Success testMap 0.11
Success testDefaultedFields 0.04
Success testNullsAllowed 0.03
PersistentAbstractClassesTest
Success testMakePersistent 0.72
Success testQuery 0.04
Success testObjectWithReferenceToPersistentInterface 0.18
Success testNewInstance 0.00
Success testNewInstance3 0.00
ArrayListTest
Success testNormalAddCollection 0.34
Success testNormalAddItem 0.09
Success testNormalChildAddCollection 0.09
Success testNormalRemoveCollection 0.09
Success testNormalRetainCollection 0.07
Success testNormalChildRemoveCollection 0.07
Success testNormalRemoveItem 0.06
Success testNormalRemoveAt 0.08
Success testNormalGetItem 0.06
Success testNormalClearIsEmpty 0.04
Success testNormalInheritance 0.12
Success testNormalQuery 0.10
Success testNormalAttachDetach 0.14
Success testInverseAddCollection 0.06
Success testInverseRemoveCollection 0.07
Success testInverseRetainCollection 0.07
Success testInverseRemoveItem 0.05
Success testInverseRemoveAt 0.06
Success testInverseGetItem 0.04
Success testInverseClearIsEmpty 0.05
Success testInverseInheritance 0.05
Success testInverseQuery 0.07
Success testInverseAttachDetach 0.15
ListTest
Success testNormalAddCollection 0.34
Success testNormalChildAddCollection 0.06
Success testNormalRemoveCollection 0.11
Success testNormalRetainCollection 0.11
Success testNormalChildRemovalCollection 0.07
Success testNormalRemoveItem 0.07
Success testNormalRemoveAt 0.08
Success testNormalGetItem 0.06
Success testNormalContains 0.08
Success testNormalClearIsEmpty 0.04
Success testNormalInheritance 0.12
Success testNormalQuery 0.11
Success testNormalAttachDetach 0.13
Success testInverseAddCollection 0.05
Success testInverseRemoveCollection 0.06
Success testInverseRetainCollection 0.06
Success testInverseRemoveItem 0.06
Success testInverseGetItem 0.05
Success testInverseClearIsEmpty 0.04
Success testInverseInheritance 0.05
Success testInverseQuery 0.06
Success testInverseAttachDetach 0.19
JDOQLBasicTest
Success testInvalidOperator 0.10
Success testDeclareImports 0.07
Success testCandidateCollection 0.36
Success testQueryUsesInnerJoin 0.46
Success testQueryReturnSameObject 0.08
Success testStringIndexOf 0.12
Success testStaticFields 0.14
Success testStringStartsWith 0.10
Success testStringEndsWith 0.04
Success testStringSubstring 0.04
Success testStringTranslate 0.00
Success testStringToLowerCase 0.07
Success testStringToUpperCase 0.05
Success testStringMatches 0.12
Success testArrayContains 0.18
Success testArrayLength 0.05
Success testArrayParameter 0.06
Success testMathAbs 0.07
Success testMathSqrt 0.09
Failure testAvg 0.04
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 testDateTimeMethods 0.05
Success testPCLiteralOnQueryCompile 0.12
Success testJDOHelperGetObjectID1 0.48
Success testJDOHelperGetObjectID2 0.09
Success testAnalysisRollup 0.00
Success testSingleString 0.05
Success testSingleStringKeywordAsFieldName 0.00
Success testSingleStringParameters 0.18
Success testNamedQueries 0.11
Success testNonstandardCharacters 0.08
Success testInstanceof 0.19
Success testSingleQuotes 0.07
Success testCharLiteralInvalidComparison 0.08
Success testEscapeSingleQuoteInString 0.05
Failure testEq_Neq_UnboundVariables 0.10
expected:<2> but was:<0>
Success testQueryUnboundVariables 0.09
Success testQueryUnboundVariablesInheritance1 0.14
Success testQueryUnboundVariablesInheritance2 0.16
Success testQueryUnboundVariablesInheritanceRightHandDeclared1 0.13
Success testQueryUnboundVariablesInheritanceRightHandDeclared2 0.04
Success testConcatStringAndNumbers 0.10
Success testNullEqualsNull 0.04
Success testUseOfParentheses 0.04
Success testQueryCheckValueDiffFields 0.06
Success testCast 0.19
Success testKeepResultsQueryAfterQueryClose 0.01
Success testKeepResultsQueryAfterTxClose 0.01
Success testKeepResultsQueryAfterPMClose 0.01
Success testQueryWithNonNullFieldCondition 0.22
Success testBoolean 0.08
Success testQueryWithDetachedObjects 0.11
Success testModuloOperator 0.04
Success testInheritanceCastWithDiscriminator 0.61
Failure testInheritanceCastWithUnion 0.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.ID = THIS.ID LEFT OUTER JOIN ASUB1 SUBELEMENT1 ON SUBELEMENT1.ID = THIS.ID INNER JOIN ASUB1 THIS_INST ON THIS_INST.ID = THIS.ID WHERE SUBELEMENT0.ID IS NULL AND SUBELEMENT1.ID IS NULL UNION SELECT 'org.jpox.samples.inheritance.ASub2' AS JPOXMETADATA FROM ABASE THIS INNER JOIN ASUB2 "ELEMENT" ON "ELEMENT".ID = THIS.ID INNER JOIN ASUB1 THIS_INST ON THIS_INST.ID = THIS.ID UNION SELECT 'org.jpox.samples.inheritance.ASub1' AS JPOXMETADATA FROM ABASE THIS INNER JOIN ASUB1 "ELEMENT" ON "ELEMENT".ID = THIS.ID INNER JOIN ASUB1 THIS_INST ON THIS_INST.ID = THIS.ID
Success testDeleteByQuery 0.02
Success testClose 0.06
Success testMultipleActiveQueryCandidateCollection 2.24
Success testMultipleActiveQueryMapGet 1.42
TreeSetTest
Success testNormalAddCollection 0.33
Success testNormalChildAddCollection 0.07
Success testNormalRemoveCollection 0.11
Success testNormalRetainCollection 0.09
Success testNormalChildRemoveCollection 0.08
Success testNormalRemoveItem 0.07
Success testNormalClearIsEmpty 0.05
Success testNormalInheritance 0.07
Success testNormalQuery 0.19
Success testNormalAttachDetach 0.14
Success testInverseAddCollection 0.07
Success testInverseRemoveCollection 0.07
Success testInverseRetainCollection 0.07
Success testInverseAddElement 0.07
Success testInverseClearIsEmpty 0.06
Success testInverseInheritance 0.06
Success testInverseQuery 0.07
Success testInverseAttachDetach 0.14
JDOQLContainerTest
Success testNotContainsValuesInMapFields 0.66
Success testNotContainsValuesInMapFieldsInverse 0.10
Success testNotContainsKeysInMapFields 0.33
Success testNotContainsKeysInMapFieldsInverse 0.26
Success testNotContainsEntryInMapFields 0.24
Success testNotContainsEntryInMapFieldsInverse 0.26
Success testGetInMapFields 0.22
Failure testGetInOrderingInMapFields 0.21
expected:<2> but was:<3>
Success testNegateContains 0.38
Success testContainsInListFields 0.04
Success testContainsInSetFields 0.08
Success testContainsInMapFields 0.23
Success testContainsInParameterCollection 0.35
Success testContainsInParameterArray 0.24
Success testContainsResultVariable 0.22
Success testContainsResultVariableNestedContains 0.21
Success testContainsInParameterCollectionOfPCleanInstances 0.20
Success testContainsInImplicitParameterCollection 0.17
Success testContainsInImplicitParameterCollectionOfPCleanInstances 0.19
Success testMapGetMethod 0.28
Error testMapGetAsLiteralWithKeyAsExpression 0.54
Cannot perform operation "getMethod" on MapKeyLiteral "('2 doors')" and StringExpression "THIS.MODEL"
Success testCollectionSize 0.14
Success testCollectionIsEmpty 0.11
Success testMapSize 0.15
Success testMapIsEmpty 0.16
Success testQueryUsesContainsOnceOnOneUnboundVariable 0.18
Success testQueryUsesContainsOnceAndEqualsOnOneUnboundVariable 0.15
Success testQueryUsesContainsValueOnceOnOneUnboundVariable 0.23
Success testQueryUsesContainsValueAndEqualsOnceOnOneUnboundVariable 0.18
Success testQueryUsesContainsValueOnceOnOneUnboundVariableInverse 0.27
Success testQueryContainsKeyOnCharacter 0.06
Success testQueryUsesContainsKeyOnceOnOneUnboundVariableInverse 0.23
Success testQueryUsesContainsKeyOnceOnOneUnboundVariable 0.21
Success testQueryUsesContainsOnceOnOneUnboundVariableUsingParameters 0.17
Success testQueryUsesContainsValueOnceOnOneUnboundVariableUsingParameters 0.16
Success testQueryUsesContainsValueOnceOnOneUnboundVariableUsingParametersInverse 0.19
Success testQueryUsesContainsKeyOnceOnOneUnboundVariableUsingParametersInverse 0.19
Success testQueryUsesContainsKeyOnceOnOneUnboundVariableUsingParameters 0.20
Success testQueryUsesContainsOnceOnOneUnboundVariableImplicitVariables 0.18
Success testQueryUsesContainsValueOnceOnOneUnboundVariableImplicitVariables 0.17
Success testQueryUsesContainsValueOnceOnOneUnboundVariableImplicitVariablesInverse 0.19
Success testQueryUsesContainsKeyOnceOnOneUnboundVariableImplicitVariablesInverse 0.25
Success testQueryUsesContainsKeyOnceOnOneUnboundVariableImplicitVariables 0.16
Success testQueryUsesContainsOnceOnOneUnboundVariableInverse 0.16
Success testQueryUsesContainsOnceOnOneUnboundVariableInverseImplicitVariables 0.18
Success testQueryUsesContainsOnceOnOneUnboundVariableInverseUsingParameter 0.19
Success testQueryUsesContainsOnceOnOneUnboundVariableMtoN 0.08
Success testQueryUsesContainsTwiceOnOneUnboundVariable 0.13
Success testQueryUsesContainsValueTwiceOnOneUnboundVariable 0.16
Success testQueryUsesContainsValueTwiceOnOneUnboundVariableInverse 0.18
Success testQueryUsesContainsKeyTwiceOnOneUnboundVariableInverse 0.16
Success testQueryUsesContainsKeyTwiceOnOneUnboundVariable 0.15
Success testQueryUsesContainsTwiceOnOneUnboundVariableInverse 0.16
Success testQueryUsesContainsTwiceOnOneUnboundVariableMtoN 0.06
Error testQueryUsesContainsTwiceOnFieldUsingWorkaround 0.12
[JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.models.company.Manager' AS JPOXMETADATA,THIS_1.AGE,THIS_1.EMAIL_ADDRESS,THIS_1.FIRSTNAME,THIS_1.GLOBALNUM,THIS_1.LASTNAME,THIS_1.PERSONNUM,THIS_2.MANAGER_GLOBALNUM_OID,THIS_2.MANAGER_PERSONNUM_OID,THIS_2.SALARY,THIS_2.SALARY_CURRENCY,THIS_2.SERIAL_NO FROM MANAGER THIS INNER JOIN PERSON THIS_1 ON THIS_1.GLOBALNUM = THIS.GLOBALNUM AND THIS_1.PERSONNUM = THIS.PERSONNUM INNER JOIN EMPLOYEE THIS_2 ON THIS_2.GLOBALNUM = THIS.GLOBALNUM AND THIS_2.PERSONNUM = THIS.PERSONNUM WHERE EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP1 INNER JOIN PERSON UNBOUND_EMP1_1 ON UNBOUND_EMP1_1.GLOBALNUM = UNBOUND_EMP1.GLOBALNUM AND UNBOUND_EMP1_1.PERSONNUM = UNBOUND_EMP1.PERSONNUM , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP1 WHERE THIS_SUBORDINATES_EMP1.GLOBALNUM_OID = THIS.GLOBALNUM AND THIS_SUBORDINATES_EMP1.PERSONNUM_OID = THIS.PERSONNUM AND UNBOUND_EMP1.GLOBALNUM = THIS_SUBORDINATES_EMP1.GLOBALNUM_EID AND UNBOUND_EMP1.PERSONNUM = THIS_SUBORDINATES_EMP1.PERSONNUM_EID) AND EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP2 INNER JOIN PERSON UNBOUND_EMP2_1 ON UNBOUND_EMP2_1.GLOBALNUM = UNBOUND_EMP2.GLOBALNUM AND UNBOUND_EMP2_1.PERSONNUM = UNBOUND_EMP2.PERSONNUM , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP2 WHERE THIS_SUBORDINATES_EMP2.GLOBALNUM_OID = THIS.GLOBALNUM AND THIS_SUBORDINATES_EMP2.PERSONNUM_OID = THIS.PERSONNUM AND UNBOUND_EMP2.GLOBALNUM = THIS_SUBORDINATES_EMP2.GLOBALNUM_EID AND UNBOUND_EMP2.PERSONNUM = THIS_SUBORDINATES_EMP2.PERSONNUM_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_1.AGE,THIS_1.EMAIL_ADDRESS,THIS_1.FIRSTNAME,THIS_1.GLOBALNUM,THIS_1.LASTNAME,THIS_1.PERSONNUM,THIS_2.MANAGER_GLOBALNUM_OID,THIS_2.MANAGER_PERSONNUM_OID,THIS_2.SALARY,THIS_2.SALARY_CURRENCY,THIS_2.SERIAL_NO FROM MANAGER THIS INNER JOIN PERSON THIS_1 ON THIS_1.GLOBALNUM = THIS.GLOBALNUM AND THIS_1.PERSONNUM = THIS.PERSONNUM INNER JOIN EMPLOYEE THIS_2 ON THIS_2.GLOBALNUM = THIS.GLOBALNUM AND THIS_2.PERSONNUM = THIS.PERSONNUM WHERE EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP1 INNER JOIN PERSON UNBOUND_EMP1_1 ON UNBOUND_EMP1_1.GLOBALNUM = UNBOUND_EMP1.GLOBALNUM AND UNBOUND_EMP1_1.PERSONNUM = UNBOUND_EMP1.PERSONNUM , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP1 WHERE THIS_SUBORDINATES_EMP1.GLOBALNUM_OID = THIS.GLOBALNUM AND THIS_SUBORDINATES_EMP1.PERSONNUM_OID = THIS.PERSONNUM AND UNBOUND_EMP1.GLOBALNUM = THIS_SUBORDINATES_EMP1.GLOBALNUM_EID AND UNBOUND_EMP1.PERSONNUM = THIS_SUBORDINATES_EMP1.PERSONNUM_EID) AND EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP2 INNER JOIN PERSON UNBOUND_EMP2_1 ON UNBOUND_EMP2_1.GLOBALNUM = UNBOUND_EMP2.GLOBALNUM AND UNBOUND_EMP2_1.PERSONNUM = UNBOUND_EMP2.PERSONNUM , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP2 WHERE THIS_SUBORDINATES_EMP2.GLOBALNUM_OID = THIS.GLOBALNUM AND THIS_SUBORDINATES_EMP2.PERSONNUM_OID = THIS.PERSONNUM AND UNBOUND_EMP2.GLOBALNUM = THIS_SUBORDINATES_EMP2.GLOBALNUM_EID AND UNBOUND_EMP2.PERSONNUM = THIS_SUBORDINATES_EMP2.PERSONNUM_EID) AND UNBOUND_EMP1_1.LASTNAME = ? OR UNBOUND_EMP2_1.LASTNAME = ?].
Error testQueryUsesContainsValueTwiceOnFieldUsingWorkaround 0.15
[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 testQueryUsesContainsValueTwiceOnFieldUsingWorkaroundInverse 0.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 testQueryUsesContainsKeyTwiceOnFieldUsingWorkaroundInverse 0.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 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 testQueryUsesContainsKeyTwiceOnFieldUsingWorkaround 0.13
[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 testQueryUsesContainsTwiceOnFieldWithNamespace 0.22
Success testQueryUsesContainsValueTwiceOnFieldWithNamespace 0.16
Success testQueryUsesContainsValueTwiceOnFieldWithNamespaceInverse 0.18
Success testQueryUsesContainsKeyTwiceOnFieldWithNamespaceInverse 0.17
Success testQueryUsesContainsKeyTwiceOnFieldWithNamespace 0.16
Success testQueryUsesContainsTwiceOnFieldWithNamespaceInverse 0.19
Success testQueryUsesContainsTwiceOnFieldWithNamespaceMtoN 0.09
Success testQueryUsesContainsTwiceOnFieldWithNamespace2MtoN 0.06
Error testQueryUsesContainsTwiceOnFieldNoNamespace 0.12
[JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.models.company.Manager' AS JPOXMETADATA,THIS_1.AGE,THIS_1.EMAIL_ADDRESS,THIS_1.FIRSTNAME,THIS_1.GLOBALNUM,THIS_1.LASTNAME,THIS_1.PERSONNUM,THIS_2.MANAGER_GLOBALNUM_OID,THIS_2.MANAGER_PERSONNUM_OID,THIS_2.SALARY,THIS_2.SALARY_CURRENCY,THIS_2.SERIAL_NO FROM MANAGER THIS INNER JOIN PERSON THIS_1 ON THIS_1.GLOBALNUM = THIS.GLOBALNUM AND THIS_1.PERSONNUM = THIS.PERSONNUM INNER JOIN EMPLOYEE THIS_2 ON THIS_2.GLOBALNUM = THIS.GLOBALNUM AND THIS_2.PERSONNUM = THIS.PERSONNUM WHERE EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP1 INNER JOIN PERSON UNBOUND_EMP1_1 ON UNBOUND_EMP1_1.GLOBALNUM = UNBOUND_EMP1.GLOBALNUM AND UNBOUND_EMP1_1.PERSONNUM = UNBOUND_EMP1.PERSONNUM , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP1 WHERE THIS_SUBORDINATES_EMP1.GLOBALNUM_OID = THIS.GLOBALNUM AND THIS_SUBORDINATES_EMP1.PERSONNUM_OID = THIS.PERSONNUM AND UNBOUND_EMP1.GLOBALNUM = THIS_SUBORDINATES_EMP1.GLOBALNUM_EID AND UNBOUND_EMP1.PERSONNUM = THIS_SUBORDINATES_EMP1.PERSONNUM_EID AND UNBOUND_EMP1_1.LASTNAME = ?) AND EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP2 INNER JOIN PERSON UNBOUND_EMP2_1 ON UNBOUND_EMP2_1.GLOBALNUM = UNBOUND_EMP2.GLOBALNUM AND UNBOUND_EMP2_1.PERSONNUM = UNBOUND_EMP2.PERSONNUM , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP2 WHERE THIS_SUBORDINATES_EMP2.GLOBALNUM_OID = THIS.GLOBALNUM AND THIS_SUBORDINATES_EMP2.PERSONNUM_OID = THIS.PERSONNUM AND UNBOUND_EMP2.GLOBALNUM = THIS_SUBORDINATES_EMP2.GLOBALNUM_EID AND UNBOUND_EMP2.PERSONNUM = THIS_SUBORDINATES_EMP2.PERSONNUM_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_1.AGE,THIS_1.EMAIL_ADDRESS,THIS_1.FIRSTNAME,THIS_1.GLOBALNUM,THIS_1.LASTNAME,THIS_1.PERSONNUM,THIS_2.MANAGER_GLOBALNUM_OID,THIS_2.MANAGER_PERSONNUM_OID,THIS_2.SALARY,THIS_2.SALARY_CURRENCY,THIS_2.SERIAL_NO FROM MANAGER THIS INNER JOIN PERSON THIS_1 ON THIS_1.GLOBALNUM = THIS.GLOBALNUM AND THIS_1.PERSONNUM = THIS.PERSONNUM INNER JOIN EMPLOYEE THIS_2 ON THIS_2.GLOBALNUM = THIS.GLOBALNUM AND THIS_2.PERSONNUM = THIS.PERSONNUM WHERE EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP1 INNER JOIN PERSON UNBOUND_EMP1_1 ON UNBOUND_EMP1_1.GLOBALNUM = UNBOUND_EMP1.GLOBALNUM AND UNBOUND_EMP1_1.PERSONNUM = UNBOUND_EMP1.PERSONNUM , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP1 WHERE THIS_SUBORDINATES_EMP1.GLOBALNUM_OID = THIS.GLOBALNUM AND THIS_SUBORDINATES_EMP1.PERSONNUM_OID = THIS.PERSONNUM AND UNBOUND_EMP1.GLOBALNUM = THIS_SUBORDINATES_EMP1.GLOBALNUM_EID AND UNBOUND_EMP1.PERSONNUM = THIS_SUBORDINATES_EMP1.PERSONNUM_EID AND UNBOUND_EMP1_1.LASTNAME = ?) AND EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP2 INNER JOIN PERSON UNBOUND_EMP2_1 ON UNBOUND_EMP2_1.GLOBALNUM = UNBOUND_EMP2.GLOBALNUM AND UNBOUND_EMP2_1.PERSONNUM = UNBOUND_EMP2.PERSONNUM , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP2 WHERE THIS_SUBORDINATES_EMP2.GLOBALNUM_OID = THIS.GLOBALNUM AND THIS_SUBORDINATES_EMP2.PERSONNUM_OID = THIS.PERSONNUM AND UNBOUND_EMP2.GLOBALNUM = THIS_SUBORDINATES_EMP2.GLOBALNUM_EID AND UNBOUND_EMP2.PERSONNUM = THIS_SUBORDINATES_EMP2.PERSONNUM_EID) AND UNBOUND_EMP2_1.LASTNAME = ?].
Success testIsEmptyOredWithContains 0.03
Success testContainsResultVariableNestedContains2 0.10
Success testQueryUsesContainsValueRangeVariableAlreadyInQuery 0.43
Success testQueryUsesContainsKeyRangeVariableAlreadyInQuery 0.28
Success testQueryUsesContainsEntryRangeVariableAlreadyInQuery 0.38
Success testQueryUsesContainsSetRangeVariableAlreadyInQuery 0.26
Success testQueryUsesContainsListRangeVariableAlreadyInQuery 0.28
MapTest
Success testNormalPutItems 0.39
Success testNormalRemoveItem 0.14
Success testNormalEntrySet 0.10
Success testNormalKeySet 0.16
Success testNormalValues 0.10
Success testNormalNonPrimitiveKeyEntrySet 0.10
Success testNormalNonPrimitiveSameKeyValueInstances 1.00
Success testNormalNonPrimitiveKeyKeySet 0.12
Success testNormalNonPrimitiveKeyQuery 0.16
Success testNormalNonPrimitiveKeyValues 0.10
Success testNormalClearIsEmpty 0.08
Success testNormalInheritance 0.07
Success testNormalQueries 0.07
Success testNormalQueriesPrimitive 0.06
Success testNormalAttachDetach 0.19
Success testInversePutItems 0.12
Success testInverseRemoveItem 0.08
Success testInverseEntrySet 0.08
Success testInverseKeySet 0.09
Success testInverseValues 0.08
Success testInverseNonPrimitiveKeyEntrySet 0.14
Success testInverseNonPrimitiveKeyKeySet 0.11
Success testInverseNonPrimitiveKeyValues 0.09
Success testInverseClearIsEmpty 0.08
Success testInverseInheritance 0.09
Success testInverseQueries 0.09
Success testInverseAttachDetach 0.19
ApplicationIdentityTest
Success testStringSingleFieldIdentity 0.44
Success testCharSingleFieldIdentity 0.24
Success testCharObjSingleFieldIdentity 0.22
Success testLongSingleFieldIdentity 0.21
Success testLongObjSingleFieldIdentity 0.20
Success testIntegerSingleFieldIdentity 0.21
Success testIntegerObjSingleFieldIdentity 0.20
Success testShortSingleFieldIdentity 0.18
Success testShortObjSingleFieldIdentity 0.18
Success testObjectSingleFieldIdentity 0.26
Success testSimpleIntID 0.32
Success testSimpleStringID 0.29
Success testComposedIntID 0.35
Success testComposedStringID 0.38
Success testComposedMixedID 0.43
Success testChildSimpleIntID 0.35
Success testChildSimpleStringID 0.28
Success testChildComposedIntID 0.37
Success testChildComposedStringID 0.29
Success testChildComposedMixedID 0.32
Success testQueryUsingContains 0.07
Success testQueryUsingPrimaryKeyFields 0.10
Success testNonNullPrimaryKeyFieldsAfterQuery 0.67
ValueGeneratorTest
Success testTablePoidMultiThreadedNewPM 1.44
Success testTableGenerator 0.03
Success testAUIDGenerator 5.03
Success testUUIDStringGenerator 0.03
Success testUUIDHexGenerator 0.02
Success testMaxGenerator 0.03
Success testSequenceGenerator 0.05
Success testIdentityGenerator 0.04
Success testAutoIncrementWithNoOtherFields 0.02
Success testAutoIncrementWithInheritance 0.08
Success testMixedGeneratorInherited 0.03
OptimisticTest
Success testBasicVersionNumberStrategy 0.28
Success testBasicDateTimeStrategy 0.03
Success testBasicNoneStrategy 0.05
Success testBasicVersionNumberStrategyVersionField 0.03
Success testCreationUpdateVersionColumns 0.07
Success testDeleteAfterUpdate 0.02
Success testMultipleUpdates 0.02
Success testConflictTransactionsVersionNumberFromQuery 0.04
Success testOptimisticQuery 0.03
Success testPCnewToPCdirty 0.05
Success testDetachAttach 0.04
Success testRefreshOfOptimisticObjects 0.02
Success testOptimisticJoinTableRelation 0.10
Success testSCOContainerClear 0.03
Success testOptimisticRollingBack 0.00
Success testRetrieveAfterPersistBeforeFlush 0.02
Success testInheritance 0.08
Success testInheritanceUsingQuery 0.03
Success testDetachAllOnCommitVersionNumber 0.03
Success testDetachCopyVersionNumber 0.02
Success testOptimisticWithIdentityFieldObjects 0.13
SQLQueryTest
Success testNullQuery 0.08
Success testInvalidQuery 0.00
Success testSelectStarQuery 0.46
Success testWithCandidateClassWithoutResultClass 0.09
Success testWithCandidateClassWithResultClass 0.11
Success testWithoutCandidateClassWithoutResultClass 0.03
Success testWithoutCandidateClassWithResultClass 0.07
Success testWithoutCandidatesClassWithParameters 0.02
Success testWithoutCandidatesWithParametersInMap 0.02
Success testNamedQueries 0.03
Success testNamedQueriesDescoped 0.02
Success testQueryWithTimeout 0.00
Success testQueryFromJdoqueryFile 0.03
Success testInvalidQueryAllowedByConfiguration 0.12
Success testWithoutCandidatesClassWithParametersMultipleExecution 0.31
Success testNumberedParameters 0.04
Success testNamedParameters 0.03
Success testTimestampQueryOnOracle 0.00
Success testSQLUpdateStatement 0.41
PersistenceModelsTest
Success testClassWithoutFields 0.51
Success testClassWithOnlyContainerFields 0.90
Success testClassWithOnlyContainerFieldsInFetchPlan 0.29
Success testPersistenceOfFKListFKListStructures 0.32
Success testPersistenceOfFKSetFKListStructures 0.19
Success test1toNInheritance 0.06
CollectionSerialTest
Success testJoinAddCollection 0.28
Success testJoinRemoveCollection 0.04
Success testJoinRetainCollection 0.04
Success testJoinClearIsEmpty 0.03
Success testJoinAttachDetach 0.10
Success testFKAddCollection 0.09
Success testFKRemoveCollection 0.07
Success testFKRetainCollection 0.07
Success testFKClearIsEmpty 0.06
Success testFKAttachDetach 0.20
HashtableTest
Success testNormalPutItems 0.38
Success testNormalRemoveItem 0.12
Success testNormalEntrySet 0.12
Success testNormalKeySet 0.09
Success testNormalValues 0.10
Success testNormalClearIsEmpty 0.14
Success testNormalInheritance 0.07
Success testNormalQueries 0.09
Success testNormalQueriesPrimitive 0.06
Success testNormalAttachDetach 0.26
Success testInversePutItems 0.10
Success testInverseRemoveItem 0.08
Success testInverseEntrySet 0.09
Success testInverseKeySet 0.10
Success testInverseValues 0.11
Success testInverseClearIsEmpty 0.09
Success testInverseInheritance 0.08
Success testInverseQueries 0.09
Success testInverseAttachDetach 0.21
SetTest
Success testNormalPersistByCollection 0.36
Success testNormalChildAddCollection 0.07
Success testNormalRemoveCollection 0.11
Success testNormalRetainCollection 0.10
Success testNormalChildRemoveCollection 0.06
Success testNormalRemoveItem 0.06
Success testNormalClearIsEmpty 0.05
Success testNormalContains 0.08
Success testNormalInheritance 0.04
Success testNormalQuery 0.18
Success testNormalAttachDetach 0.12
Success testInverseAddCollection 0.06
Success testInverseRemoveCollection 0.07
Success testInverseRetainCollection 0.06
Success testInverseAddElement 0.06
Success testInverseClearIsEmpty 0.05
Success testInverseInheritance 0.06
Success testInverseQuery 0.07
Success testInverseAttachDetach 0.12
Success testInversePersistByCollectionDFG 0.11
Success testInversePersistByElementDFG 0.04
CompoundIdentityTest
Success testOneToOneUniSingle 0.58
Success testOneToOneUniDouble 0.25
Success testOneToOneUniDoubleQuery 0.20
Success testOneToManyUniJoinTableSingle 0.08
Success testOneToManyUniJoinTableDouble 0.12
Success testOneToManyUniJoinTableDetachAttach 0.27
Success testOneToManyBiFKDouble 0.10
Success testOneToManyBiFKDoubleDetachAttach 0.24
Success testOneToManyMapBiKeyInValue 0.10
Success testOneToManyMapBiValueInKey 0.08
Success testOneToOneUniInheritance 0.08
Success testOneToOneBiSingleFKPK 0.04
Success test4LevelsDepthPersistence 0.07
Failure test4LevelsDepthQuery 0.07
expected:<1> but was:<0>
Success testOneToOneBiStoredAsFKUpdate 0.02
Success testOneToOneBiStoredAsFKChangeCompound 0.02
Success testOneToManyChain 0.12
ReachabilityTest
Success testPersistCascadeFalse 0.24
Success testOneToOneUniClassPessimistic 0.14
Success testOneToOneUniClassOptimistic 0.05
Success testOneToOneUniInterfacePessimistic 0.44
Success testOneToOneUniInterfaceOptimistic 0.03
Success testOneToOneUniClassTemporaryPessimistic 0.04
Success testOneToOneUniClassTemporaryOptimistic 0.03
Failure testOneToOneUniTemporaryStates 0.04
Field value of former persistent-new-deleted (now transient) object has been changed expected:<JPOX Corporation> but was:<null>
Success testOneToOneUniClassNewDeleted 2.84
Success testOneToOneBiClassNewDeleted 2.41
Success testDeepReachabilityByClass 0.46
Success testNewObjectUnreachableWithDirtyObjectOwner 0.24
Success testBaseOnQuery 0.06
Success testIncorrectAssignment 0.03
MapForeignKeyTest
Success testMapWithKeyAsFieldInValue 1.00
Success testMapWithValueAsFieldInKey 0.15
RelationshipTest
Success test1to1Unidir 0.22
Success test1to1BidirNullOut 0.26
Success test1to1Bidir 0.22
Success test1to1BidirQuery 0.15
Success test1to1BidirInheritance 0.30
Success test1toNBidirJoin 0.39
Failure test1toNUnidirJoinSubclassTable 0.11
Exception thrown while creating 1-N unidirectional Join Table "subclass-table" relationship data : [JPOX-052208] Insert of object "org.jpox.samples.one_many.unidir.DesktopComputer@1198ff2" using statement "INSERT INTO RELATIONS_DESKTOPS (IP_ADDRESS,NUMBER_OF_PROCESSORS,OPERATING_SYSTEM,ID) VALUES (?,?,?,?)" failed : Unique constraint violation: SYS_IDX_366 in statement [INSERT INTO RELATIONS_DESKTOPS (IP_ADDRESS,NUMBER_OF_PROCESSORS,OPERATING_SYSTEM,ID) VALUES (?,?,?,?)]
Success testDeletionWithInherited1toN 0.25
Success testMtoN 0.17
Success testMtoNInheritance 0.18
Success test1toNInheritance 0.07
Success testQueryWithInheritanceAndOrdering 0.06
Failure test1to1UnidirInheritanceSubclassTable 0.10
Number of readers who read "Hello" magazine was incorrect expected:<0> but was:<1>
Success test1to1BidirInheritanceSuperclassTable 0.08
Success test1toNBidir_1to1Unidir 0.13
Success test1toNunidirFK 0.06
Success test1toNUnidirFKToSelf 0.10
Success test1toNUnidirFKList 0.05
Success test1toNUnidirFKListToSelf 0.10
Success test1toNUnidirFKMap 0.12
Success test1toNUnidirFKMapToSelf 0.14
Success test1toNBidirFK 0.15
Success test1toNMap 0.18
Success test1toNInheritanceSource 0.20
Success test1toNUnidirFKSetInheritanceTarget 0.06
Success test1toNUnidirFKListInheritanceTarget 0.06
Success test1toNUnidirSetSharedJoin 0.05
Success test1toNUnidirSetSharedFK 0.06
Success test1toNUnidirListSharedJoin 0.05
Success test1toNUnidirListSharedFK 0.06
Success test1toNUnidirOrderedList 0.06
Success testDoublyLinkedList 0.09
Success testSinglyLinkedList 0.06
Success testParentChildLinkRelation 0.04
Success test1toNListFKUsingOrderMappedBy 0.09
Success test1toNBidirCyclicNonNullable 0.20
LinkedListTest
Success testNormalAddCollection 0.33
Success testNormalRemoveCollection 0.10
Success testNormalRetainCollection 0.12
Success testNormalRemoveItem 0.08
Success testNormalRemoveAt 0.07
Success testNormalGetItem 0.05
Success testNormalClearIsEmpty 0.05
Success testNormalInheritance 0.06
Success testNormalQuery 0.17
Success testNormalAttachDetach 0.15
Success testInverseAddCollection 0.06
Success testInverseRemoveCollection 0.06
Success testInverseRetainCollection 0.06
Success testInverseRemoveItem 0.05
Success testInverseGetItem 0.05
Success testInverseClearIsEmpty 0.04
Success testInverseInheritance 0.05
Success testInverseQuery 0.07
Success testInverseAttachDetach 0.11
VectorTest
Success testNormalAddCollection 0.32
Success testNormalRemoveCollection 0.10
Success testNormalRetainCollection 0.12
Success testNormalRemoveItem 0.08
Success testNormalRemoveAt 0.07
Success testNormalGetItem 0.05
Success testNormalClearIsEmpty 0.05
Success testNormalInheritance 0.06
Success testNormalQuery 0.17
Success testNormalAttachDetach 0.15
Success testInverseAddCollection 0.05
Success testInverseRemoveCollection 0.06
Success testInverseRetainCollection 0.06
Success testInverseRemoveItem 0.06
Success testInverseGetItem 0.05
Success testInverseClearIsEmpty 0.04
Success testInverseInheritance 0.05
Success testInverseQuery 0.07
Success testInverselAttachDetach 0.11
PersistentInterfacesTest
Success testMakePersistent 0.74
Success testQuery 0.04
Success testFreshPMF 0.44
Success testObjectWithReferenceToPersistentInterface 0.12
Success testNewInstancePCClass 0.00
Success testNewInstance 0.00
Success testNewInstance3 0.00
StackTest
Success testNormalAddCollection 0.32
Success testNormalRemoveCollection 0.10
Success testNormalRetainCollection 0.12
Success testNormalRemoveItem 0.08
Success testNormalRemoveAt 0.07
Success testNormalGetItem 0.05
Success testNormalClearIsEmpty 0.05
Success testNormalInheritance 0.06
Success testNormalQuery 0.17
Success testNormalAttachDetach 0.15
Success testInverseAddCollection 0.06
Success testInverseRemoveCollection 0.06
Success testInverseRetainCollection 0.05
Success testInverseRemoveItem 0.06
Success testInverseGetItem 0.06
Success testInverseClearIsEmpty 0.04
Success testInverseInheritance 0.05
Success testInverseQuery 0.07
Success testInverseAttachDetach 0.11
LinkedHashMapTest
Success testNormalPutItems 0.38
Success testNormalRemoveItem 0.12
Success testNormalEntrySet 0.20
Success testNormalKeySet 0.09
Success testNormalValues 0.10
Success testNormalClearIsEmpty 0.08
Success testNormalInheritance 0.08
Success testNormalQueries 0.09
Success testNormalQueriesPrimitive 0.06
Success testNormalAttachDetach 0.26
Success testInversePutItems 0.10
Success testInverseRemoveItem 0.09
Success testInverseEntrySet 0.09
Success testInverseKeySet 0.11
Success testInverseValues 0.11
Success testInverseClearIsEmpty 0.09
Success testInverseInheritance 0.08
Success testInverseQueries 0.09
Success testInverseAttachDetach 0.21
JDOQLResultTest
Success testRangeAndUnique 0.31
Success testUniqueResultAggregates 0.08
Success testSetResultCartesianProduct1 0.60
Success testSetResultCartesianProduct2 0.14
Success testSetResultCartesianProductCollection 0.29
Error testSetResultCartesianProductMap 0.01
implement this
Success testSetResultCartesianProductContains1 0.26
Success testSetResultCartesianProductContains2 0.24
Success testSetResultCartesianProduct1to1 0.24
Success testSetResultCartesianProductContainsVariableNoNavigation 0.09
Success testOrdering 0.11
Success testOrderingUsingCollectionExpression 0.21
Success testSetResultDistinct 0.05
Success testSetResult 0.04
Success testCandidateCollection 0.04
Success testCandidateCollectionWithResultNotSameTypeAsCandidates 0.04
Success testSetIllegalAttributeInResult 0.02
Success testSetResultParameter 0.08
Success testResultSetMetaData 0.07
Success testSetResultWithAggregationWithoutSubclasses 0.03
Success testSetResultWithAggregationWithSubclasses 0.03
Success testSetResultWithAggregation1 0.05
Success testSetResultWithAggregation2 0.02
Success testSetResultWithAggregationAndNonAggregateExpression 0.04
Success testSetResultWithAggregationAndNonAggregateExpression2 0.01
Success testResultSetInsensitive 0.04
Success testCountOnClassHierarchy 0.04
Success testNewObjectInResult 0.14
Success testSetResultClass 0.05
DependentFieldTest
Success testDependentFieldsDeletion 0.87
Success testDependentFieldsInverseSetsDeletion 0.29
Success testDependentFieldsInverseListsDeletion 0.29
Success testDependentFieldsInverseMapsDeletion 0.34
Success testDependentFieldsInverseMapsValuesDeletion 0.28
Success testDependentFieldsInverseMapsKeysDeletion 0.26
Success testDependentElementsRemovalUsingJoinTable 0.27
Success testDependentElementsRemovalUsingForeignKey 0.32
Success testDependentKeysRemovalUsingJoinTable 0.24
Success testDependentKeysRemovalUsingForeignKey 0.26
Success testBidirectionalDependentFields 0.29
Success testInterfaceDependentFields 0.45
Success testNullify1to1Relation 0.17
Success testRemoveDependentFieldOnDetached 0.18
AbstractClassesTest
Success testCreationSimple 0.37
Success testRetrievalSimple 0.13
Success testQuerySimple 0.11
Success testDeletionSimple 0.07
Success testJoinTableSetCreationSimple 0.05
Success testJoinTableSetRetrievalSimple 0.06
Success testJoinTableListCreationSimple 0.04
Success testJoinTableListRetrievalSimple 0.05
Success testCreationComposite 0.08
Success testRetrievalComposite 0.12
Success testQueryComposite 0.08
Success testDeletionComposite 0.07
Success testJoinTableSetCreationComposite 0.04
Success testJoinTableSetRetrievalComposite 0.05
Success testJoinTableListCreationComposite 0.04
Success testJoinTableListRetrievalComposite 0.07
HashMapTest
Success testNormalPutItems 0.39
Success testNormalRemoveItem 0.13
Success testNormalEntrySet 0.13
Success testNormalKeySet 0.09
Success testNormalValues 0.10
Success testNormalClearIsEmpty 0.07
Success testNormalInheritance 0.07
Success testNormalQueries 0.16
Success testNormalQueriesPrimitive 0.06
Success testNormalAttachDetach 0.27
Success testInversePutItems 0.11
Success testInverseRemoveItem 0.08
Success testInverseEntrySet 0.09
Success testInverseKeySet 0.09
Success testInverseValues 0.12
Success testInverseClearIsEmpty 0.09
Success testInverseInheritance 0.08
Success testInverseQueries 0.09
Success testInverseAttachDetach 0.20
InterfacesTest
Success testCreation 0.92
Success testReadAllShapeHolders 0.16
Success testChangeImplementation 0.11
Success testNullValues 0.03
Success testInsertThenDelete 0.02
Success testSetJoin 0.04
Success testListJoin 0.09
Failure testSetFK 0.07
Exception thrown during create of set of interface objects using FK : [JPOX-056029] Class "org.jpox.samples.interfaces.ShapeHolder3" has collection field "shapeSet" and this has no mapping in the table for the element class "org.jpox.samples.interfaces.ShapeInverse" owner field "containerSet"
Error testListFK 0.02
[JPOX-056029] Class "org.jpox.samples.interfaces.ShapeHolder3" has collection field "shapeSet" and this has no mapping in the table for the element class "org.jpox.samples.interfaces.ShapeInverse" owner field "containerSet"
Success testMultipleImplementations 0.05
Success testQueryOnInterfaceFields 0.41
Success testQueryOnInterfaceFieldsBooleanOps 0.40
Success testCorrectCastOnInterfaceField 0.36
Success testAccessToFieldsInInterfaces 0.32
Success testQueryForNullShape 0.32
Success testQueryForNonNullShape 0.34
QueueTest
Success testQueue1 0.62
CollectionPrimitiveTest
Success testCollectionNonPCUsingJoinTable 0.40
Success testCollectionNonPCWithoutJoinTable 0.11
Success testCollectionNonPCSerialised 0.08
LinkedHashSetTest
Success testNormalAddCollection 0.32
Success testNormalChildAddCollection 0.06
Success testNormalRemoveCollection 0.10
Success testNormalRetainCollection 0.08
Success testNormalChildRemoveCollection 0.07
Success testNormalRemoveItem 0.06
Success testNormalClearIsEmpty 0.04
Success testNormalInheritance 0.05
Success testNormalQuery 0.18
Success testNormalAttachDetach 0.15
Success testInverseAddCollection 0.06
Success testInverseRemoveCollection 0.07
Success testInverseRetainCollection 0.06
Success testInverseAddElement 0.08
Success testInverseClearIsEmpty 0.07
Success testInverseInheritance 0.06
Success testInverseQuery 0.08
Success testInverseAttachDetach 0.13
ObjectsTest
Success testOneToOneRelation 0.78
Success testOneToManyRelationWithJoinTable 0.04
InheritanceTest
Success testSubclassTable 0.30
Success testSubclassTableNewTable 0.07
Success testInheritanceWithNoTable 0.01
Success testNewTableSuperclassTableValueMap 0.09
Success testNewTableSuperclassTableClassName 0.08
Success testNewTableNewTable 0.08
Success testNewTableExtentResults 0.07
Success testNewTableSubclassTableNewTable 0.08
Success testSuperclassTable1toNJoinTableRelationship 0.04
Success testSuperclassTable1toNFKRelationship 0.05
Success testInverseCollectionWithElementUsingSuperclassTable 0.24
Success testNewTableOverrideFields 0.04
Success testSuperclassTableValueMapInteger 0.02
CollectionTest
Success testNormalAddCollection 0.34
Success testNormalChildAddCollection 0.06
Success testNormalRemoveCollection 0.11
Success testNormalRetainCollection 0.08
Success testNormalChildRemoveCollection 0.07
Success testNormalRemoveItem 0.06
Success testNormalClearIsEmpty 0.05
Success testNormalInheritance 0.07
Success testNormalQuery 0.18
Success testNormalAttachDetach 0.14
Success testInverseAddCollection 0.05
Success testInverseRemoveCollection 0.07
Success testInverseRetainCollection 0.06
Success testInverseAddElement 0.06
Success testInverseClearIsEmpty 0.06
Success testInverseInheritance 0.06
Success testInverseQuery 0.08
Success testInverseAttachDetach 0.13
PropertiesTest
Success testNormalPutItems 0.33
Success testNormalRemoveItem 0.05
Success testNormalEntrySet 0.04
Success testNormalKeySet 0.04
Success testNormalValues 0.03
Success testNormalClearIsEmpty 0.04
Success testNormalAttachDetach 0.09
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.ID = THIS.ID LEFT OUTER JOIN ASUB1 SUBELEMENT1 ON SUBELEMENT1.ID = THIS.ID INNER JOIN ASUB1 THIS_INST ON THIS_INST.ID = THIS.ID WHERE SUBELEMENT0.ID IS NULL AND SUBELEMENT1.ID IS NULL UNION SELECT 'org.jpox.samples.inheritance.ASub2' AS JPOXMETADATA FROM ABASE THIS INNER JOIN ASUB2 "ELEMENT" ON "ELEMENT".ID = THIS.ID INNER JOIN ASUB1 THIS_INST ON THIS_INST.ID = THIS.ID UNION SELECT 'org.jpox.samples.inheritance.ASub1' AS JPOXMETADATA FROM ABASE THIS INNER JOIN ASUB1 "ELEMENT" ON "ELEMENT".ID = THIS.ID INNER JOIN ASUB1 THIS_INST ON THIS_INST.ID = THIS.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.ID = THIS.ID LEFT OUTER JOIN ASUB1 SUBELEMENT1 ON SUBELEMENT1.ID = THIS.ID INNER JOIN ASUB1 THIS_INST ON THIS_INST.ID = THIS.ID WHERE SUBELEMENT0.ID IS NULL AND SUBELEMENT1.ID IS NULL UNION SELECT 'org.jpox.samples.inheritance.ASub2' AS JPOXMETADATA FROM ABASE THIS INNER JOIN ASUB2 "ELEMENT" ON "ELEMENT".ID = THIS.ID INNER JOIN ASUB1 THIS_INST ON THIS_INST.ID = THIS.ID UNION SELECT 'org.jpox.samples.inheritance.ASub1' AS JPOXMETADATA FROM ABASE THIS INNER JOIN ASUB1 "ELEMENT" ON "ELEMENT".ID = THIS.ID INNER JOIN ASUB1 THIS_INST ON THIS_INST.ID = THIS.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:739)
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:1742) 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:1742)
Error testQueryUsesContainsTwiceOnFieldUsingWorkaround
[JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.models.company.Manager' AS JPOXMETADATA,THIS_1.AGE,THIS_1.EMAIL_ADDRESS,THIS_1.FIRSTNAME,THIS_1.GLOBALNUM,THIS_1.LASTNAME,THIS_1.PERSONNUM,THIS_2.MANAGER_GLOBALNUM_OID,THIS_2.MANAGER_PERSONNUM_OID,THIS_2.SALARY,THIS_2.SALARY_CURRENCY,THIS_2.SERIAL_NO FROM MANAGER THIS INNER JOIN PERSON THIS_1 ON THIS_1.GLOBALNUM = THIS.GLOBALNUM AND THIS_1.PERSONNUM = THIS.PERSONNUM INNER JOIN EMPLOYEE THIS_2 ON THIS_2.GLOBALNUM = THIS.GLOBALNUM AND THIS_2.PERSONNUM = THIS.PERSONNUM WHERE EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP1 INNER JOIN PERSON UNBOUND_EMP1_1 ON UNBOUND_EMP1_1.GLOBALNUM = UNBOUND_EMP1.GLOBALNUM AND UNBOUND_EMP1_1.PERSONNUM = UNBOUND_EMP1.PERSONNUM , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP1 WHERE THIS_SUBORDINATES_EMP1.GLOBALNUM_OID = THIS.GLOBALNUM AND THIS_SUBORDINATES_EMP1.PERSONNUM_OID = THIS.PERSONNUM AND UNBOUND_EMP1.GLOBALNUM = THIS_SUBORDINATES_EMP1.GLOBALNUM_EID AND UNBOUND_EMP1.PERSONNUM = THIS_SUBORDINATES_EMP1.PERSONNUM_EID) AND EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP2 INNER JOIN PERSON UNBOUND_EMP2_1 ON UNBOUND_EMP2_1.GLOBALNUM = UNBOUND_EMP2.GLOBALNUM AND UNBOUND_EMP2_1.PERSONNUM = UNBOUND_EMP2.PERSONNUM , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP2 WHERE THIS_SUBORDINATES_EMP2.GLOBALNUM_OID = THIS.GLOBALNUM AND THIS_SUBORDINATES_EMP2.PERSONNUM_OID = THIS.PERSONNUM AND UNBOUND_EMP2.GLOBALNUM = THIS_SUBORDINATES_EMP2.GLOBALNUM_EID AND UNBOUND_EMP2.PERSONNUM = THIS_SUBORDINATES_EMP2.PERSONNUM_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_1.AGE,THIS_1.EMAIL_ADDRESS,THIS_1.FIRSTNAME,THIS_1.GLOBALNUM,THIS_1.LASTNAME,THIS_1.PERSONNUM,THIS_2.MANAGER_GLOBALNUM_OID,THIS_2.MANAGER_PERSONNUM_OID,THIS_2.SALARY,THIS_2.SALARY_CURRENCY,THIS_2.SERIAL_NO FROM MANAGER THIS INNER JOIN PERSON THIS_1 ON THIS_1.GLOBALNUM = THIS.GLOBALNUM AND THIS_1.PERSONNUM = THIS.PERSONNUM INNER JOIN EMPLOYEE THIS_2 ON THIS_2.GLOBALNUM = THIS.GLOBALNUM AND THIS_2.PERSONNUM = THIS.PERSONNUM WHERE EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP1 INNER JOIN PERSON UNBOUND_EMP1_1 ON UNBOUND_EMP1_1.GLOBALNUM = UNBOUND_EMP1.GLOBALNUM AND UNBOUND_EMP1_1.PERSONNUM = UNBOUND_EMP1.PERSONNUM , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP1 WHERE THIS_SUBORDINATES_EMP1.GLOBALNUM_OID = THIS.GLOBALNUM AND THIS_SUBORDINATES_EMP1.PERSONNUM_OID = THIS.PERSONNUM AND UNBOUND_EMP1.GLOBALNUM = THIS_SUBORDINATES_EMP1.GLOBALNUM_EID AND UNBOUND_EMP1.PERSONNUM = THIS_SUBORDINATES_EMP1.PERSONNUM_EID) AND EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP2 INNER JOIN PERSON UNBOUND_EMP2_1 ON UNBOUND_EMP2_1.GLOBALNUM = UNBOUND_EMP2.GLOBALNUM AND UNBOUND_EMP2_1.PERSONNUM = UNBOUND_EMP2.PERSONNUM , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP2 WHERE THIS_SUBORDINATES_EMP2.GLOBALNUM_OID = THIS.GLOBALNUM AND THIS_SUBORDINATES_EMP2.PERSONNUM_OID = THIS.PERSONNUM AND UNBOUND_EMP2.GLOBALNUM = THIS_SUBORDINATES_EMP2.GLOBALNUM_EID AND UNBOUND_EMP2.PERSONNUM = THIS_SUBORDINATES_EMP2.PERSONNUM_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_1.AGE,THIS_1.EMAIL_ADDRESS,THIS_1.FIRSTNAME,THIS_1.GLOBALNUM,THIS_1.LASTNAME,THIS_1.PERSONNUM,THIS_2.MANAGER_GLOBALNUM_OID,THIS_2.MANAGER_PERSONNUM_OID,THIS_2.SALARY,THIS_2.SALARY_CURRENCY,THIS_2.SERIAL_NO FROM MANAGER THIS INNER JOIN PERSON THIS_1 ON THIS_1.GLOBALNUM = THIS.GLOBALNUM AND THIS_1.PERSONNUM = THIS.PERSONNUM INNER JOIN EMPLOYEE THIS_2 ON THIS_2.GLOBALNUM = THIS.GLOBALNUM AND THIS_2.PERSONNUM = THIS.PERSONNUM WHERE EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP1 INNER JOIN PERSON UNBOUND_EMP1_1 ON UNBOUND_EMP1_1.GLOBALNUM = UNBOUND_EMP1.GLOBALNUM AND UNBOUND_EMP1_1.PERSONNUM = UNBOUND_EMP1.PERSONNUM , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP1 WHERE THIS_SUBORDINATES_EMP1.GLOBALNUM_OID = THIS.GLOBALNUM AND THIS_SUBORDINATES_EMP1.PERSONNUM_OID = THIS.PERSONNUM AND UNBOUND_EMP1.GLOBALNUM = THIS_SUBORDINATES_EMP1.GLOBALNUM_EID AND UNBOUND_EMP1.PERSONNUM = THIS_SUBORDINATES_EMP1.PERSONNUM_EID) AND EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP2 INNER JOIN PERSON UNBOUND_EMP2_1 ON UNBOUND_EMP2_1.GLOBALNUM = UNBOUND_EMP2.GLOBALNUM AND UNBOUND_EMP2_1.PERSONNUM = UNBOUND_EMP2.PERSONNUM , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP2 WHERE THIS_SUBORDINATES_EMP2.GLOBALNUM_OID = THIS.GLOBALNUM AND THIS_SUBORDINATES_EMP2.PERSONNUM_OID = THIS.PERSONNUM AND UNBOUND_EMP2.GLOBALNUM = THIS_SUBORDINATES_EMP2.GLOBALNUM_EID AND UNBOUND_EMP2.PERSONNUM = THIS_SUBORDINATES_EMP2.PERSONNUM_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_1.AGE,THIS_1.EMAIL_ADDRESS,THIS_1.FIRSTNAME,THIS_1.GLOBALNUM,THIS_1.LASTNAME,THIS_1.PERSONNUM,THIS_2.MANAGER_GLOBALNUM_OID,THIS_2.MANAGER_PERSONNUM_OID,THIS_2.SALARY,THIS_2.SALARY_CURRENCY,THIS_2.SERIAL_NO FROM MANAGER THIS INNER JOIN PERSON THIS_1 ON THIS_1.GLOBALNUM = THIS.GLOBALNUM AND THIS_1.PERSONNUM = THIS.PERSONNUM INNER JOIN EMPLOYEE THIS_2 ON THIS_2.GLOBALNUM = THIS.GLOBALNUM AND THIS_2.PERSONNUM = THIS.PERSONNUM WHERE EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP1 INNER JOIN PERSON UNBOUND_EMP1_1 ON UNBOUND_EMP1_1.GLOBALNUM = UNBOUND_EMP1.GLOBALNUM AND UNBOUND_EMP1_1.PERSONNUM = UNBOUND_EMP1.PERSONNUM , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP1 WHERE THIS_SUBORDINATES_EMP1.GLOBALNUM_OID = THIS.GLOBALNUM AND THIS_SUBORDINATES_EMP1.PERSONNUM_OID = THIS.PERSONNUM AND UNBOUND_EMP1.GLOBALNUM = THIS_SUBORDINATES_EMP1.GLOBALNUM_EID AND UNBOUND_EMP1.PERSONNUM = THIS_SUBORDINATES_EMP1.PERSONNUM_EID) AND EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP2 INNER JOIN PERSON UNBOUND_EMP2_1 ON UNBOUND_EMP2_1.GLOBALNUM = UNBOUND_EMP2.GLOBALNUM AND UNBOUND_EMP2_1.PERSONNUM = UNBOUND_EMP2.PERSONNUM , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP2 WHERE THIS_SUBORDINATES_EMP2.GLOBALNUM_OID = THIS.GLOBALNUM AND THIS_SUBORDINATES_EMP2.PERSONNUM_OID = THIS.PERSONNUM AND UNBOUND_EMP2.GLOBALNUM = THIS_SUBORDINATES_EMP2.GLOBALNUM_EID AND UNBOUND_EMP2.PERSONNUM = THIS_SUBORDINATES_EMP2.PERSONNUM_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:4581) 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_1.AGE,THIS_1.EMAIL_ADDRESS,THIS_1.FIRSTNAME,THIS_1.GLOBALNUM,THIS_1.LASTNAME,THIS_1.PERSONNUM,THIS_2.MANAGER_GLOBALNUM_OID,THIS_2.MANAGER_PERSONNUM_OID,THIS_2.SALARY,THIS_2.SALARY_CURRENCY,THIS_2.SERIAL_NO FROM MANAGER THIS INNER JOIN PERSON THIS_1 ON THIS_1.GLOBALNUM = THIS.GLOBALNUM AND THIS_1.PERSONNUM = THIS.PERSONNUM INNER JOIN EMPLOYEE THIS_2 ON THIS_2.GLOBALNUM = THIS.GLOBALNUM AND THIS_2.PERSONNUM = THIS.PERSONNUM WHERE EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP1 INNER JOIN PERSON UNBOUND_EMP1_1 ON UNBOUND_EMP1_1.GLOBALNUM = UNBOUND_EMP1.GLOBALNUM AND UNBOUND_EMP1_1.PERSONNUM = UNBOUND_EMP1.PERSONNUM , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP1 WHERE THIS_SUBORDINATES_EMP1.GLOBALNUM_OID = THIS.GLOBALNUM AND THIS_SUBORDINATES_EMP1.PERSONNUM_OID = THIS.PERSONNUM AND UNBOUND_EMP1.GLOBALNUM = THIS_SUBORDINATES_EMP1.GLOBALNUM_EID AND UNBOUND_EMP1.PERSONNUM = THIS_SUBORDINATES_EMP1.PERSONNUM_EID) AND EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP2 INNER JOIN PERSON UNBOUND_EMP2_1 ON UNBOUND_EMP2_1.GLOBALNUM = UNBOUND_EMP2.GLOBALNUM AND UNBOUND_EMP2_1.PERSONNUM = UNBOUND_EMP2.PERSONNUM , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP2 WHERE THIS_SUBORDINATES_EMP2.GLOBALNUM_OID = THIS.GLOBALNUM AND THIS_SUBORDINATES_EMP2.PERSONNUM_OID = THIS.PERSONNUM AND UNBOUND_EMP2.GLOBALNUM = THIS_SUBORDINATES_EMP2.GLOBALNUM_EID AND UNBOUND_EMP2.PERSONNUM = THIS_SUBORDINATES_EMP2.PERSONNUM_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:4581)
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:4667) 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:4667)
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:4763) 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:4763)
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:4857) 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:4857)
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:4953) 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:4953)
Error testQueryUsesContainsTwiceOnFieldNoNamespace
[JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.models.company.Manager' AS JPOXMETADATA,THIS_1.AGE,THIS_1.EMAIL_ADDRESS,THIS_1.FIRSTNAME,THIS_1.GLOBALNUM,THIS_1.LASTNAME,THIS_1.PERSONNUM,THIS_2.MANAGER_GLOBALNUM_OID,THIS_2.MANAGER_PERSONNUM_OID,THIS_2.SALARY,THIS_2.SALARY_CURRENCY,THIS_2.SERIAL_NO FROM MANAGER THIS INNER JOIN PERSON THIS_1 ON THIS_1.GLOBALNUM = THIS.GLOBALNUM AND THIS_1.PERSONNUM = THIS.PERSONNUM INNER JOIN EMPLOYEE THIS_2 ON THIS_2.GLOBALNUM = THIS.GLOBALNUM AND THIS_2.PERSONNUM = THIS.PERSONNUM WHERE EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP1 INNER JOIN PERSON UNBOUND_EMP1_1 ON UNBOUND_EMP1_1.GLOBALNUM = UNBOUND_EMP1.GLOBALNUM AND UNBOUND_EMP1_1.PERSONNUM = UNBOUND_EMP1.PERSONNUM , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP1 WHERE THIS_SUBORDINATES_EMP1.GLOBALNUM_OID = THIS.GLOBALNUM AND THIS_SUBORDINATES_EMP1.PERSONNUM_OID = THIS.PERSONNUM AND UNBOUND_EMP1.GLOBALNUM = THIS_SUBORDINATES_EMP1.GLOBALNUM_EID AND UNBOUND_EMP1.PERSONNUM = THIS_SUBORDINATES_EMP1.PERSONNUM_EID AND UNBOUND_EMP1_1.LASTNAME = ?) AND EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP2 INNER JOIN PERSON UNBOUND_EMP2_1 ON UNBOUND_EMP2_1.GLOBALNUM = UNBOUND_EMP2.GLOBALNUM AND UNBOUND_EMP2_1.PERSONNUM = UNBOUND_EMP2.PERSONNUM , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP2 WHERE THIS_SUBORDINATES_EMP2.GLOBALNUM_OID = THIS.GLOBALNUM AND THIS_SUBORDINATES_EMP2.PERSONNUM_OID = THIS.PERSONNUM AND UNBOUND_EMP2.GLOBALNUM = THIS_SUBORDINATES_EMP2.GLOBALNUM_EID AND UNBOUND_EMP2.PERSONNUM = THIS_SUBORDINATES_EMP2.PERSONNUM_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_1.AGE,THIS_1.EMAIL_ADDRESS,THIS_1.FIRSTNAME,THIS_1.GLOBALNUM,THIS_1.LASTNAME,THIS_1.PERSONNUM,THIS_2.MANAGER_GLOBALNUM_OID,THIS_2.MANAGER_PERSONNUM_OID,THIS_2.SALARY,THIS_2.SALARY_CURRENCY,THIS_2.SERIAL_NO FROM MANAGER THIS INNER JOIN PERSON THIS_1 ON THIS_1.GLOBALNUM = THIS.GLOBALNUM AND THIS_1.PERSONNUM = THIS.PERSONNUM INNER JOIN EMPLOYEE THIS_2 ON THIS_2.GLOBALNUM = THIS.GLOBALNUM AND THIS_2.PERSONNUM = THIS.PERSONNUM WHERE EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP1 INNER JOIN PERSON UNBOUND_EMP1_1 ON UNBOUND_EMP1_1.GLOBALNUM = UNBOUND_EMP1.GLOBALNUM AND UNBOUND_EMP1_1.PERSONNUM = UNBOUND_EMP1.PERSONNUM , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP1 WHERE THIS_SUBORDINATES_EMP1.GLOBALNUM_OID = THIS.GLOBALNUM AND THIS_SUBORDINATES_EMP1.PERSONNUM_OID = THIS.PERSONNUM AND UNBOUND_EMP1.GLOBALNUM = THIS_SUBORDINATES_EMP1.GLOBALNUM_EID AND UNBOUND_EMP1.PERSONNUM = THIS_SUBORDINATES_EMP1.PERSONNUM_EID AND UNBOUND_EMP1_1.LASTNAME = ?) AND EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP2 INNER JOIN PERSON UNBOUND_EMP2_1 ON UNBOUND_EMP2_1.GLOBALNUM = UNBOUND_EMP2.GLOBALNUM AND UNBOUND_EMP2_1.PERSONNUM = UNBOUND_EMP2.PERSONNUM , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP2 WHERE THIS_SUBORDINATES_EMP2.GLOBALNUM_OID = THIS.GLOBALNUM AND THIS_SUBORDINATES_EMP2.PERSONNUM_OID = THIS.PERSONNUM AND UNBOUND_EMP2.GLOBALNUM = THIS_SUBORDINATES_EMP2.GLOBALNUM_EID AND UNBOUND_EMP2.PERSONNUM = THIS_SUBORDINATES_EMP2.PERSONNUM_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_1.AGE,THIS_1.EMAIL_ADDRESS,THIS_1.FIRSTNAME,THIS_1.GLOBALNUM,THIS_1.LASTNAME,THIS_1.PERSONNUM,THIS_2.MANAGER_GLOBALNUM_OID,THIS_2.MANAGER_PERSONNUM_OID,THIS_2.SALARY,THIS_2.SALARY_CURRENCY,THIS_2.SERIAL_NO FROM MANAGER THIS INNER JOIN PERSON THIS_1 ON THIS_1.GLOBALNUM = THIS.GLOBALNUM AND THIS_1.PERSONNUM = THIS.PERSONNUM INNER JOIN EMPLOYEE THIS_2 ON THIS_2.GLOBALNUM = THIS.GLOBALNUM AND THIS_2.PERSONNUM = THIS.PERSONNUM WHERE EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP1 INNER JOIN PERSON UNBOUND_EMP1_1 ON UNBOUND_EMP1_1.GLOBALNUM = UNBOUND_EMP1.GLOBALNUM AND UNBOUND_EMP1_1.PERSONNUM = UNBOUND_EMP1.PERSONNUM , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP1 WHERE THIS_SUBORDINATES_EMP1.GLOBALNUM_OID = THIS.GLOBALNUM AND THIS_SUBORDINATES_EMP1.PERSONNUM_OID = THIS.PERSONNUM AND UNBOUND_EMP1.GLOBALNUM = THIS_SUBORDINATES_EMP1.GLOBALNUM_EID AND UNBOUND_EMP1.PERSONNUM = THIS_SUBORDINATES_EMP1.PERSONNUM_EID AND UNBOUND_EMP1_1.LASTNAME = ?) AND EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP2 INNER JOIN PERSON UNBOUND_EMP2_1 ON UNBOUND_EMP2_1.GLOBALNUM = UNBOUND_EMP2.GLOBALNUM AND UNBOUND_EMP2_1.PERSONNUM = UNBOUND_EMP2.PERSONNUM , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP2 WHERE THIS_SUBORDINATES_EMP2.GLOBALNUM_OID = THIS.GLOBALNUM AND THIS_SUBORDINATES_EMP2.PERSONNUM_OID = THIS.PERSONNUM AND UNBOUND_EMP2.GLOBALNUM = THIS_SUBORDINATES_EMP2.GLOBALNUM_EID AND UNBOUND_EMP2.PERSONNUM = THIS_SUBORDINATES_EMP2.PERSONNUM_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_1.AGE,THIS_1.EMAIL_ADDRESS,THIS_1.FIRSTNAME,THIS_1.GLOBALNUM,THIS_1.LASTNAME,THIS_1.PERSONNUM,THIS_2.MANAGER_GLOBALNUM_OID,THIS_2.MANAGER_PERSONNUM_OID,THIS_2.SALARY,THIS_2.SALARY_CURRENCY,THIS_2.SERIAL_NO FROM MANAGER THIS INNER JOIN PERSON THIS_1 ON THIS_1.GLOBALNUM = THIS.GLOBALNUM AND THIS_1.PERSONNUM = THIS.PERSONNUM INNER JOIN EMPLOYEE THIS_2 ON THIS_2.GLOBALNUM = THIS.GLOBALNUM AND THIS_2.PERSONNUM = THIS.PERSONNUM WHERE EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP1 INNER JOIN PERSON UNBOUND_EMP1_1 ON UNBOUND_EMP1_1.GLOBALNUM = UNBOUND_EMP1.GLOBALNUM AND UNBOUND_EMP1_1.PERSONNUM = UNBOUND_EMP1.PERSONNUM , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP1 WHERE THIS_SUBORDINATES_EMP1.GLOBALNUM_OID = THIS.GLOBALNUM AND THIS_SUBORDINATES_EMP1.PERSONNUM_OID = THIS.PERSONNUM AND UNBOUND_EMP1.GLOBALNUM = THIS_SUBORDINATES_EMP1.GLOBALNUM_EID AND UNBOUND_EMP1.PERSONNUM = THIS_SUBORDINATES_EMP1.PERSONNUM_EID AND UNBOUND_EMP1_1.LASTNAME = ?) AND EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP2 INNER JOIN PERSON UNBOUND_EMP2_1 ON UNBOUND_EMP2_1.GLOBALNUM = UNBOUND_EMP2.GLOBALNUM AND UNBOUND_EMP2_1.PERSONNUM = UNBOUND_EMP2.PERSONNUM , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP2 WHERE THIS_SUBORDINATES_EMP2.GLOBALNUM_OID = THIS.GLOBALNUM AND THIS_SUBORDINATES_EMP2.PERSONNUM_OID = THIS.PERSONNUM AND UNBOUND_EMP2.GLOBALNUM = THIS_SUBORDINATES_EMP2.GLOBALNUM_EID AND UNBOUND_EMP2.PERSONNUM = THIS_SUBORDINATES_EMP2.PERSONNUM_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:5700) 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_1.AGE,THIS_1.EMAIL_ADDRESS,THIS_1.FIRSTNAME,THIS_1.GLOBALNUM,THIS_1.LASTNAME,THIS_1.PERSONNUM,THIS_2.MANAGER_GLOBALNUM_OID,THIS_2.MANAGER_PERSONNUM_OID,THIS_2.SALARY,THIS_2.SALARY_CURRENCY,THIS_2.SERIAL_NO FROM MANAGER THIS INNER JOIN PERSON THIS_1 ON THIS_1.GLOBALNUM = THIS.GLOBALNUM AND THIS_1.PERSONNUM = THIS.PERSONNUM INNER JOIN EMPLOYEE THIS_2 ON THIS_2.GLOBALNUM = THIS.GLOBALNUM AND THIS_2.PERSONNUM = THIS.PERSONNUM WHERE EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP1 INNER JOIN PERSON UNBOUND_EMP1_1 ON UNBOUND_EMP1_1.GLOBALNUM = UNBOUND_EMP1.GLOBALNUM AND UNBOUND_EMP1_1.PERSONNUM = UNBOUND_EMP1.PERSONNUM , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP1 WHERE THIS_SUBORDINATES_EMP1.GLOBALNUM_OID = THIS.GLOBALNUM AND THIS_SUBORDINATES_EMP1.PERSONNUM_OID = THIS.PERSONNUM AND UNBOUND_EMP1.GLOBALNUM = THIS_SUBORDINATES_EMP1.GLOBALNUM_EID AND UNBOUND_EMP1.PERSONNUM = THIS_SUBORDINATES_EMP1.PERSONNUM_EID AND UNBOUND_EMP1_1.LASTNAME = ?) AND EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP2 INNER JOIN PERSON UNBOUND_EMP2_1 ON UNBOUND_EMP2_1.GLOBALNUM = UNBOUND_EMP2.GLOBALNUM AND UNBOUND_EMP2_1.PERSONNUM = UNBOUND_EMP2.PERSONNUM , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP2 WHERE THIS_SUBORDINATES_EMP2.GLOBALNUM_OID = THIS.GLOBALNUM AND THIS_SUBORDINATES_EMP2.PERSONNUM_OID = THIS.PERSONNUM AND UNBOUND_EMP2.GLOBALNUM = THIS_SUBORDINATES_EMP2.GLOBALNUM_EID AND UNBOUND_EMP2.PERSONNUM = THIS_SUBORDINATES_EMP2.PERSONNUM_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:5700)
Failure test4LevelsDepthQuery
expected:<1> but was:<0>
junit.framework.AssertionFailedError: expected:<1> but was:<0> at org.jpox.tests.CompoundIdentityTest.test4LevelsDepthQuery(CompoundIdentityTest.java:1392)
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 test1toNUnidirJoinSubclassTable
Exception thrown while creating 1-N unidirectional Join Table "subclass-table" relationship data : [JPOX-052208] Insert of object "org.jpox.samples.one_many.unidir.DesktopComputer@1198ff2" using statement "INSERT INTO RELATIONS_DESKTOPS (IP_ADDRESS,NUMBER_OF_PROCESSORS,OPERATING_SYSTEM,ID) VALUES (?,?,?,?)" failed : Unique constraint violation: SYS_IDX_366 in statement [INSERT INTO RELATIONS_DESKTOPS (IP_ADDRESS,NUMBER_OF_PROCESSORS,OPERATING_SYSTEM,ID) VALUES (?,?,?,?)]
junit.framework.AssertionFailedError: Exception thrown while creating 1-N unidirectional Join Table "subclass-table" relationship data : [JPOX-052208] Insert of object "org.jpox.samples.one_many.unidir.DesktopComputer@1198ff2" using statement "INSERT INTO RELATIONS_DESKTOPS (IP_ADDRESS,NUMBER_OF_PROCESSORS,OPERATING_SYSTEM,ID) VALUES (?,?,?,?)" failed : Unique constraint violation: SYS_IDX_366 in statement [INSERT INTO RELATIONS_DESKTOPS (IP_ADDRESS,NUMBER_OF_PROCESSORS,OPERATING_SYSTEM,ID) VALUES (?,?,?,?)] at org.jpox.tests.RelationshipTest.test1toNUnidirJoinSubclassTable(RelationshipTest.java:1319)
Failure test1to1UnidirInheritanceSubclassTable
Number of readers who read "Hello" magazine was incorrect expected:<0> but was:<1>
junit.framework.AssertionFailedError: Number of readers who read "Hello" magazine was incorrect expected:<0> but was:<1> at org.jpox.tests.RelationshipTest.test1to1UnidirInheritanceSubclassTable(RelationshipTest.java:2386)
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-056029] Class "org.jpox.samples.interfaces.ShapeHolder3" has collection field "shapeSet" and this has no mapping in the table for the element class "org.jpox.samples.interfaces.ShapeInverse" owner field "containerSet"
junit.framework.AssertionFailedError: Exception thrown during create of set of interface objects using FK : [JPOX-056029] Class "org.jpox.samples.interfaces.ShapeHolder3" has collection field "shapeSet" and this has no mapping in the table for the element class "org.jpox.samples.interfaces.ShapeInverse" owner field "containerSet" at org.jpox.tests.InterfacesTest.testSetFK(InterfacesTest.java:568)
Error testListFK
[JPOX-056029] Class "org.jpox.samples.interfaces.ShapeHolder3" has collection field "shapeSet" and this has no mapping in the table for the element class "org.jpox.samples.interfaces.ShapeInverse" owner field "containerSet"
javax.jdo.JDOUserException: [JPOX-056029] Class "org.jpox.samples.interfaces.ShapeHolder3" has collection field "shapeSet" and this has no mapping in the table for the element class "org.jpox.samples.interfaces.ShapeInverse" owner field "containerSet" 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:613) 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-056029] Class "org.jpox.samples.interfaces.ShapeHolder3" has collection field "shapeSet" and this has no mapping in the table for the element class "org.jpox.samples.interfaces.ShapeInverse" owner field "containerSet" org.jpox.exceptions.JPOXUserException: [JPOX-056029] Class "org.jpox.samples.interfaces.ShapeHolder3" has collection field "shapeSet" and this has no mapping in the table for the element class "org.jpox.samples.interfaces.ShapeInverse" owner field "containerSet" at org.jpox.store.rdbms.scostore.FKSetStore.<init>(FKSetStore.java:187) at org.jpox.store.rdbms.RDBMSManager.getBackingStoreForCollection(RDBMSManager.java:1122) at org.jpox.store.mapping.CollectionMapping.getBackingStore(CollectionMapping.java:97) at org.jpox.sco.HashSet.<init>(HashSet.java:147) at sun.reflect.GeneratedConstructorAccessor9.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:494) at org.jpox.util.ClassUtils.newInstance(ClassUtils.java:93) at org.jpox.sco.SCOUtils.newSCOInstance(SCOUtils.java:166) at org.jpox.store.mapping.AbstractContainerMapping.replaceFieldWithWrapper(AbstractContainerMapping.java:399) at org.jpox.store.mapping.CollectionMapping.postInsert(CollectionMapping.java:244) 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:613)