Development
Documentation
Testing
Summary

[ summary] [ package list] [ test cases]

Tests Errors Failures Success rate Time(s)
665 10 7 97.44% 100.44

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 665 10 7 97.44% 100.44

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.619
Success SecondaryTableTest 2 0 0 100.00% 0.463
Success SchemaTest 32 0 0 100.00% 4.979
Success PersistentAbstractClassesTest 5 0 0 100.00% 1.010
Success ArrayListTest 23 0 0 100.00% 2.005
Success ListTest 22 0 0 100.00% 2.036
Failure JDOQLBasicTest 58 0 3 94.83% 9.084
Success TreeSetTest 18 0 0 100.00% 1.904
Error JDOQLContainerTest 71 8 1 87.32% 12.307
Success MapTest 27 0 0 100.00% 4.141
Success ValueGeneratorTest 11 0 0 100.00% 7.139
Success OptimisticTest 21 0 0 100.00% 1.041
Success SQLQueryTest 19 0 0 100.00% 1.992
Success PersistenceModelsTest 6 0 0 100.00% 2.325
Success CollectionSerialTest 10 0 0 100.00% 0.936
Success HashtableTest 19 0 0 100.00% 2.279
Success SetTest 21 0 0 100.00% 1.848
Failure ReachabilityTest 14 0 1 92.86% 6.861
Success MapForeignKeyTest 2 0 0 100.00% 1.192
Success DatastoreIdentityTest 1 0 0 100.00% 0.640
Failure RelationshipTest 32 0 1 96.88% 3.687
Success LinkedListTest 19 0 0 100.00% 1.694
Success VectorTest 19 0 0 100.00% 1.760
Success PersistentInterfacesTest 7 0 0 100.00% 1.346
Success StackTest 19 0 0 100.00% 1.704
Error JDOQLResultTest 29 1 0 96.55% 3.236
Success LinkedHashMapTest 19 0 0 100.00% 2.299
Success DependentFieldTest 14 0 0 100.00% 4.206
Success AbstractClassesTest 9 0 0 100.00% 1.450
Success HashMapTest 19 0 0 100.00% 2.353
Error InterfacesTest 17 1 1 88.24% 3.836
Success QueueTest 1 0 0 100.00% 0.611
Success CollectionPrimitiveTest 3 0 0 100.00% 0.518
Success LinkedHashSetTest 18 0 0 100.00% 1.644
Success ObjectsTest 2 0 0 100.00% 0.863
Success InheritanceTest 13 0 0 100.00% 1.124
Success CollectionTest 18 0 0 100.00% 1.677
Success PropertiesTest 7 0 0 100.00% 0.631
Test Cases

[ summary] [ package list] [ test cases]

HashSetTest
Success testNormalAddCollection 0.33
Success testNormalChildAddCollection 0.06
Success testNormalRemoveCollection 0.10
Success testNormalRetainCollection 0.07
Success testNormalChildRemoveCollection 0.06
Success testNormalRemoveItem 0.07
Success testNormalClearIsEmpty 0.05
Success testNormalInheritance 0.06
Success testNormalQuery 0.10
Success testNormalAttachDetach 0.13
Success testInverseAddCollection 0.07
Success testInverseRemoveCollection 0.06
Success testInverseRetainCollection 0.06
Success testInverseAddElement 0.06
Success testInverseClearIsEmpty 0.05
Success testInverseInheritance 0.08
Success testInverseQuery 0.09
Success testInverseAttachDetach 0.12
SecondaryTableTest
Success testSecondaryTable 0.41
Success testQuerySecondaryTable 0.04
SchemaTest
Success testTableColumnNames 0.58
Success testColumnSpecifications 0.02
Success testUnique 0.27
Success testColumnWidth 0.46
Success testReadOnlyDatastore 0.43
Success testFixedDatastore 0.43
Success testClassUsingSQLKeywords 0.47
Success testClassWithLongName 0.33
Success testClassAsSQLKeyword 0.00
Success testTableReuseForDifferentClasses 0.13
Success test1To1Bidir 0.06
Success testSecondaryTableSchema 0.03
Success testInterfaces 0.18
Success testObjectFields 0.05
Success test1To1UnidirectionalSchema 0.04
Success testOverridingColumnsBaseNewTableSubNewTable 0.29
Success testOverridingColumnsBaseSubclassTableSubNewTable 0.02
Success testOverridingColumnsBaseNewTableSubSuperclassTable 0.01
Success testEmbeddedPCSchema 0.13
Success testEmbeddedPCCollectionSchema 0.02
Success testEmbeddedPCListSchema 0.01
Success testEmbeddedPCMapSchema 0.02
Success testMtoN 0.08
Success testArrayNonPC 0.29
Success testArrayPC 0.02
Success testSet 0.23
Success testList 0.09
Success testMap 0.13
Success testDefaultedFields 0.02
Success testUnmappedColumns 0.01
Success testIsNullable 0.07
Success testNullsAllowed 0.03
PersistentAbstractClassesTest
Success testMakePersistent 0.78
Success testQuery 0.04
Success testObjectWithReferenceToPersistentInterface 0.17
Success testNewInstance 0.00
Success testNewInstance3 0.00
ArrayListTest
Success testNormalAddCollection 0.36
Success testNormalAddItem 0.10
Success testNormalChildAddCollection 0.07
Success testNormalRemoveCollection 0.08
Success testNormalRetainCollection 0.08
Success testNormalChildRemoveCollection 0.06
Success testNormalRemoveItem 0.07
Success testNormalRemoveAt 0.06
Success testNormalGetItem 0.06
Success testNormalClearIsEmpty 0.05
Success testNormalInheritance 0.07
Success testNormalQuery 0.10
Success testNormalAttachDetach 0.15
Success testInverseAddCollection 0.06
Success testInverseRemoveCollection 0.06
Success testInverseRetainCollection 0.06
Success testInverseRemoveItem 0.06
Success testInverseRemoveAt 0.06
Success testInverseGetItem 0.05
Success testInverseClearIsEmpty 0.04
Success testInverseInheritance 0.06
Success testInverseQuery 0.08
Success testInverseAttachDetach 0.15
ListTest
Success testNormalAddCollection 0.36
Success testNormalChildAddCollection 0.07
Success testNormalRemoveCollection 0.10
Success testNormalRetainCollection 0.11
Success testNormalChildRemovalCollection 0.06
Success testNormalRemoveItem 0.06
Success testNormalRemoveAt 0.06
Success testNormalGetItem 0.05
Success testNormalContains 0.08
Success testNormalClearIsEmpty 0.05
Success testNormalInheritance 0.06
Success testNormalQuery 0.13
Success testNormalAttachDetach 0.14
Success testInverseAddCollection 0.07
Success testInverseRemoveCollection 0.07
Success testInverseRetainCollection 0.06
Success testInverseRemoveItem 0.06
Success testInverseGetItem 0.06
Success testInverseClearIsEmpty 0.05
Success testInverseInheritance 0.06
Success testInverseQuery 0.08
Success testInverseAttachDetach 0.18
JDOQLBasicTest
Success testInvalidOperator 0.11
Success testDeclareImports 0.08
Success testCandidateCollection 0.37
Success testQueryUsesInnerJoin 0.34
Success testQueryReturnSameObject 0.10
Success testStringIndexOf 0.10
Success testStaticFields 0.12
Success testStringStartsWith 0.10
Success testStringEndsWith 0.08
Success testStringSubstring 0.03
Success testStringTranslate 0.00
Success testStringToLowerCase 0.16
Success testStringToUpperCase 0.05
Success testStringMatches 0.12
Success testArrayContains 0.17
Success testArrayLength 0.05
Success testArrayParameter 0.06
Success testMathAbs 0.07
Success testMathSqrt 0.09
Failure testAvg 0.05
Exception thrown executing JDOQL query with AVG : [JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.types.basic.BasicTypeHolder' AS JPOXMETADATA,THIS.BASICTYPEHOLDER_ID,THIS.BOOLEAN_FIELD,THIS.BOOLEAN_OBJ_FIELD,THIS.BYTE_FIELD,THIS.BYTE_OBJ_FIELD,THIS.CHAR_FIELD,THIS.CHAR_OBJ_FIELD,THIS.INT_FIELD,THIS.INT_OBJ_FIELD,THIS.LONG_FIELD,THIS.LONG_OBJ_FIELD,THIS.SHORT_FIELD,THIS.SHORT_OBJ_FIELD FROM BASICTYPEHOLDER THIS , BASICTYPEHOLDER UNBOUND_P WHERE THIS.LONG_FIELD = AVG(UNBOUND_P.LONG_FIELD)" : Not a condition in statement [SELECT 'org.jpox.samples.types.basic.BasicTypeHolder' AS JPOXMETADATA,THIS.BASICTYPEHOLDER_ID,THIS.BOOLEAN_FIELD,THIS.BOOLEAN_OBJ_FIELD,THIS.BYTE_FIELD,THIS.BYTE_OBJ_FIELD,THIS.CHAR_FIELD,THIS.CHAR_OBJ_FIELD,THIS.INT_FIELD,THIS.INT_OBJ_FIELD,THIS.LONG_FIELD,THIS.LONG_OBJ_FIELD,THIS.SHORT_FIELD,THIS.SHORT_OBJ_FIELD FROM BASICTYPEHOLDER THIS , BASICTYPEHOLDER UNBOUND_P WHERE THIS.LONG_FIELD = AVG(UNBOUND_P.LONG_FIELD)].
Success testDateTimeMethods 0.05
Success testPCLiteralOnQueryCompile 0.10
Success testJDOHelperGetObjectID1 0.45
Success testJDOHelperGetObjectID2 0.10
Success testAnalysisRollup 0.00
Success testSingleString 0.05
Success testSingleStringKeywordAsFieldName 0.00
Success testSingleStringParameters 0.11
Success testNamedQueries 0.10
Success testNonstandardCharacters 0.07
Success testInstanceof 0.23
Success testSingleQuotes 0.09
Success testCharLiteralInvalidComparison 0.09
Success testEscapeSingleQuoteInString 0.05
Failure testEq_Neq_UnboundVariables 0.08
expected:<2> but was:<0>
Success testQueryUnboundVariables 0.10
Success testQueryUnboundVariablesInheritance1 0.20
Success testQueryUnboundVariablesInheritance2 0.14
Success testQueryUnboundVariablesInheritanceRightHandDeclared1 0.15
Success testQueryUnboundVariablesInheritanceRightHandDeclared2 0.04
Success testConcatStringAndNumbers 0.09
Success testNullEqualsNull 0.04
Success testUseOfParentheses 0.04
Success testQueryCheckValueDiffFields 0.07
Success testCast 0.15
Success testKeepResultsQueryAfterQueryClose 0.01
Success testKeepResultsQueryAfterTxClose 0.01
Success testKeepResultsQueryAfterPMClose 0.00
Success testQueryWithNonNullFieldCondition 0.12
Success testBoolean 0.07
Success testQueryWithDetachedObjects 0.11
Success testModuloOperator 0.03
Success testInheritanceCastWithDiscriminator 0.57
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.ASUB2_ID = THIS.ABASE_ID LEFT OUTER JOIN ASUB1 SUBELEMENT1 ON SUBELEMENT1.ASUB1_ID = THIS.ABASE_ID INNER JOIN ASUB1 THIS_INST ON THIS_INST.ASUB1_ID = THIS.ABASE_ID WHERE SUBELEMENT0.ASUB2_ID IS NULL AND SUBELEMENT1.ASUB1_ID IS NULL UNION SELECT 'org.jpox.samples.inheritance.ASub2' AS JPOXMETADATA FROM ABASE THIS INNER JOIN ASUB2 "ELEMENT" ON "ELEMENT".ASUB2_ID = THIS.ABASE_ID INNER JOIN ASUB1 THIS_INST ON THIS_INST.ASUB1_ID = THIS.ABASE_ID UNION SELECT 'org.jpox.samples.inheritance.ASub1' AS JPOXMETADATA FROM ABASE THIS INNER JOIN ASUB1 "ELEMENT" ON "ELEMENT".ASUB1_ID = THIS.ABASE_ID INNER JOIN ASUB1 THIS_INST ON THIS_INST.ASUB1_ID = THIS.ABASE_ID
Success testDeleteByQuery 0.02
Success testClose 0.05
Success testMultipleActiveQueryCandidateCollection 1.80
Success testMultipleActiveQueryMapGet 1.39
TreeSetTest
Success testNormalAddCollection 0.40
Success testNormalChildAddCollection 0.08
Success testNormalRemoveCollection 0.11
Success testNormalRetainCollection 0.09
Success testNormalChildRemoveCollection 0.06
Success testNormalRemoveItem 0.08
Success testNormalClearIsEmpty 0.06
Success testNormalInheritance 0.06
Success testNormalQuery 0.11
Success testNormalAttachDetach 0.15
Success testInverseAddCollection 0.08
Success testInverseRemoveCollection 0.07
Success testInverseRetainCollection 0.07
Success testInverseAddElement 0.06
Success testInverseClearIsEmpty 0.05
Success testInverseInheritance 0.09
Success testInverseQuery 0.09
Success testInverseAttachDetach 0.14
JDOQLContainerTest
Success testNotContainsValuesInMapFields 0.72
Success testNotContainsValuesInMapFieldsInverse 0.10
Success testNotContainsKeysInMapFields 0.32
Success testNotContainsKeysInMapFieldsInverse 0.25
Success testNotContainsEntryInMapFields 0.23
Success testNotContainsEntryInMapFieldsInverse 0.26
Success testGetInMapFields 0.20
Failure testGetInOrderingInMapFields 0.18
expected:<2> but was:<3>
Success testNegateContains 0.34
Success testContainsInListFields 0.04
Success testContainsInSetFields 0.08
Success testContainsInMapFields 0.26
Success testContainsInParameterCollection 0.24
Success testContainsInParameterArray 0.32
Error testContainsInParameterArray2 0.20
[JPOX-021060] Error binding "dept0" to "ObjectExpression "UNBOUND_DEPT0.DEPARTMENT_ID"" since it was previously bound to "ObjectExpression "UNBOUND_DEPT0.DEPARTMENT_ID"".
Success testContainsResultVariable 0.18
Success testContainsResultVariableNestedContains 0.20
Success testContainsInParameterCollectionOfPCleanInstances 0.15
Success testContainsInImplicitParameterCollection 0.15
Success testContainsInImplicitParameterCollectionOfPCleanInstances 0.14
Success testMapGetMethod 0.16
Error testMapGetAsLiteralWithKeyAsExpression 0.14
Cannot perform operation "getMethod" on MapKeyLiteral "('2 doors')" and StringExpression "THIS.MODEL"
Success testCollectionSize 0.09
Success testCollectionIsEmpty 0.10
Success testMapSize 0.15
Success testMapIsEmpty 0.12
Success testQueryUsesContainsOnceOnOneUnboundVariable 0.17
Success testQueryUsesContainsOnceAndEqualsOnOneUnboundVariable 0.13
Success testQueryUsesContainsValueOnceOnOneUnboundVariable 0.24
Success testQueryUsesContainsValueAndEqualsOnceOnOneUnboundVariable 0.16
Success testQueryUsesContainsValueOnceOnOneUnboundVariableInverse 0.24
Success testQueryContainsKeyOnCharacter 0.05
Success testQueryUsesContainsKeyOnceOnOneUnboundVariableInverse 0.22
Success testQueryUsesContainsKeyOnceOnOneUnboundVariable 0.28
Success testQueryUsesContainsOnceOnOneUnboundVariableUsingParameters 0.15
Success testQueryUsesContainsValueOnceOnOneUnboundVariableUsingParameters 0.17
Success testQueryUsesContainsValueOnceOnOneUnboundVariableUsingParametersInverse 0.17
Success testQueryUsesContainsKeyOnceOnOneUnboundVariableUsingParametersInverse 0.16
Success testQueryUsesContainsKeyOnceOnOneUnboundVariableUsingParameters 0.15
Success testQueryUsesContainsOnceOnOneUnboundVariableImplicitVariables 0.17
Success testQueryUsesContainsValueOnceOnOneUnboundVariableImplicitVariables 0.17
Success testQueryUsesContainsValueOnceOnOneUnboundVariableImplicitVariablesInverse 0.19
Success testQueryUsesContainsKeyOnceOnOneUnboundVariableImplicitVariablesInverse 0.16
Success testQueryUsesContainsKeyOnceOnOneUnboundVariableImplicitVariables 0.16
Success testQueryUsesContainsOnceOnOneUnboundVariableInverse 0.15
Success testQueryUsesContainsOnceOnOneUnboundVariableInverseImplicitVariables 0.15
Success testQueryUsesContainsOnceOnOneUnboundVariableInverseUsingParameter 0.17
Success testQueryUsesContainsOnceOnOneUnboundVariableMtoN 0.07
Success testQueryUsesContainsTwiceOnOneUnboundVariable 0.13
Success testQueryUsesContainsValueTwiceOnOneUnboundVariable 0.17
Success testQueryUsesContainsValueTwiceOnOneUnboundVariableInverse 0.19
Success testQueryUsesContainsKeyTwiceOnOneUnboundVariableInverse 0.17
Success testQueryUsesContainsKeyTwiceOnOneUnboundVariable 0.15
Success testQueryUsesContainsTwiceOnOneUnboundVariableInverse 0.15
Success testQueryUsesContainsTwiceOnOneUnboundVariableMtoN 0.07
Error testQueryUsesContainsTwiceOnFieldUsingWorkaround 0.18
[JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.models.company.Manager' AS JPOXMETADATA,THIS.EMPLOYEE_ID,THIS_1.AGE,THIS_1.EMAIL_ADDRESS,THIS_1.FIRSTNAME,THIS_1.GLOBALNUM,THIS_1.LASTNAME,THIS_1.PERSONNUM,THIS_2.MANAGER_EMPLOYEE_ID_OID,THIS_2.SALARY,THIS_2.SALARY_CURRENCY,THIS_2.SERIAL_NO FROM MANAGER THIS INNER JOIN PERSON THIS_1 ON THIS_1.PERSON_ID = THIS.EMPLOYEE_ID INNER JOIN EMPLOYEE THIS_2 ON THIS_2.EMPLOYEE_ID = THIS.EMPLOYEE_ID WHERE EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP1 INNER JOIN PERSON UNBOUND_EMP1_1 ON UNBOUND_EMP1_1.PERSON_ID = UNBOUND_EMP1.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP1 WHERE THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP1.EMPLOYEE_ID = THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_EID) AND EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP2 INNER JOIN PERSON UNBOUND_EMP2_1 ON UNBOUND_EMP2_1.PERSON_ID = UNBOUND_EMP2.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP2 WHERE THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP2.EMPLOYEE_ID = THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_EID) AND UNBOUND_EMP1_1.LASTNAME = ? OR UNBOUND_EMP2_1.LASTNAME = ?" : Column not found: UNBOUND_EMP1_1.LASTNAME in statement [SELECT 'org.jpox.samples.models.company.Manager' AS JPOXMETADATA,THIS.EMPLOYEE_ID,THIS_1.AGE,THIS_1.EMAIL_ADDRESS,THIS_1.FIRSTNAME,THIS_1.GLOBALNUM,THIS_1.LASTNAME,THIS_1.PERSONNUM,THIS_2.MANAGER_EMPLOYEE_ID_OID,THIS_2.SALARY,THIS_2.SALARY_CURRENCY,THIS_2.SERIAL_NO FROM MANAGER THIS INNER JOIN PERSON THIS_1 ON THIS_1.PERSON_ID = THIS.EMPLOYEE_ID INNER JOIN EMPLOYEE THIS_2 ON THIS_2.EMPLOYEE_ID = THIS.EMPLOYEE_ID WHERE EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP1 INNER JOIN PERSON UNBOUND_EMP1_1 ON UNBOUND_EMP1_1.PERSON_ID = UNBOUND_EMP1.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP1 WHERE THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP1.EMPLOYEE_ID = THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_EID) AND EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP2 INNER JOIN PERSON UNBOUND_EMP2_1 ON UNBOUND_EMP2_1.PERSON_ID = UNBOUND_EMP2.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP2 WHERE THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP2.EMPLOYEE_ID = THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_EID) AND UNBOUND_EMP1_1.LASTNAME = ? OR UNBOUND_EMP2_1.LASTNAME = ?].
Error testQueryUsesContainsValueTwiceOnFieldUsingWorkaround 0.18
[JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM GYM_WARDROBES THIS_WARDROBES_W1 , WARDROBE UNBOUND_W1 WHERE THIS_WARDROBES_W1.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES_W1.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W1.WARDROBE_ID = THIS_WARDROBES_W1.WARDROBE_ID_VID) AND EXISTS (SELECT 1 FROM GYM_WARDROBES THIS_WARDROBES_W2 , WARDROBE UNBOUND_W2 WHERE THIS_WARDROBES_W2.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES_W2.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W2.WARDROBE_ID = THIS_WARDROBES_W2.WARDROBE_ID_VID) AND UNBOUND_W1.MODEL = ? OR UNBOUND_W2.MODEL = ?" : Column not found: UNBOUND_W1.MODEL in statement [SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM GYM_WARDROBES THIS_WARDROBES_W1 , WARDROBE UNBOUND_W1 WHERE THIS_WARDROBES_W1.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES_W1.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W1.WARDROBE_ID = THIS_WARDROBES_W1.WARDROBE_ID_VID) AND EXISTS (SELECT 1 FROM GYM_WARDROBES THIS_WARDROBES_W2 , WARDROBE UNBOUND_W2 WHERE THIS_WARDROBES_W2.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES_W2.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W2.WARDROBE_ID = THIS_WARDROBES_W2.WARDROBE_ID_VID) AND UNBOUND_W1.MODEL = ? OR UNBOUND_W2.MODEL = ?].
Error 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.25
[JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE2_W1 INNER JOIN WARDROBE UNBOUND_W1 ON THIS_WARDROBESINVERSE2_W1.WARDROBE_ID = UNBOUND_W1.WARDROBE_ID WHERE THIS_WARDROBESINVERSE2_W1.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE2_W1.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID) AND EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE2_W2 INNER JOIN WARDROBE UNBOUND_W2 ON THIS_WARDROBESINVERSE2_W2.WARDROBE_ID = UNBOUND_W2.WARDROBE_ID WHERE THIS_WARDROBESINVERSE2_W2.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE2_W2.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID) AND UNBOUND_W1.MODEL = ? OR UNBOUND_W2.MODEL = ?" : Column not found: UNBOUND_W1.MODEL in statement [SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE2_W1 INNER JOIN WARDROBE UNBOUND_W1 ON THIS_WARDROBESINVERSE2_W1.WARDROBE_ID = UNBOUND_W1.WARDROBE_ID WHERE THIS_WARDROBESINVERSE2_W1.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE2_W1.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID) AND EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE2_W2 INNER JOIN WARDROBE UNBOUND_W2 ON THIS_WARDROBESINVERSE2_W2.WARDROBE_ID = UNBOUND_W2.WARDROBE_ID WHERE THIS_WARDROBESINVERSE2_W2.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE2_W2.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID) AND UNBOUND_W1.MODEL = ? OR UNBOUND_W2.MODEL = ?].
Error testQueryUsesContainsKeyTwiceOnFieldUsingWorkaround 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 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.12
Success testQueryUsesContainsValueTwiceOnFieldWithNamespace 0.16
Success testQueryUsesContainsValueTwiceOnFieldWithNamespaceInverse 0.18
Success testQueryUsesContainsKeyTwiceOnFieldWithNamespaceInverse 0.16
Success testQueryUsesContainsKeyTwiceOnFieldWithNamespace 0.16
Success testQueryUsesContainsTwiceOnFieldWithNamespaceInverse 0.18
Success testQueryUsesContainsTwiceOnFieldWithNamespaceMtoN 0.08
Success testQueryUsesContainsTwiceOnFieldWithNamespace2MtoN 0.06
Error testQueryUsesContainsTwiceOnFieldNoNamespace 0.12
[JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.models.company.Manager' AS JPOXMETADATA,THIS.EMPLOYEE_ID,THIS_1.AGE,THIS_1.EMAIL_ADDRESS,THIS_1.FIRSTNAME,THIS_1.GLOBALNUM,THIS_1.LASTNAME,THIS_1.PERSONNUM,THIS_2.MANAGER_EMPLOYEE_ID_OID,THIS_2.SALARY,THIS_2.SALARY_CURRENCY,THIS_2.SERIAL_NO FROM MANAGER THIS INNER JOIN PERSON THIS_1 ON THIS_1.PERSON_ID = THIS.EMPLOYEE_ID INNER JOIN EMPLOYEE THIS_2 ON THIS_2.EMPLOYEE_ID = THIS.EMPLOYEE_ID WHERE EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP1 INNER JOIN PERSON UNBOUND_EMP1_1 ON UNBOUND_EMP1_1.PERSON_ID = UNBOUND_EMP1.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP1 WHERE THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP1.EMPLOYEE_ID = THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_EID AND UNBOUND_EMP1_1.LASTNAME = ?) AND EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP2 INNER JOIN PERSON UNBOUND_EMP2_1 ON UNBOUND_EMP2_1.PERSON_ID = UNBOUND_EMP2.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP2 WHERE THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP2.EMPLOYEE_ID = THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_EID) AND UNBOUND_EMP2_1.LASTNAME = ?" : Column not found: UNBOUND_EMP2_1.LASTNAME in statement [SELECT 'org.jpox.samples.models.company.Manager' AS JPOXMETADATA,THIS.EMPLOYEE_ID,THIS_1.AGE,THIS_1.EMAIL_ADDRESS,THIS_1.FIRSTNAME,THIS_1.GLOBALNUM,THIS_1.LASTNAME,THIS_1.PERSONNUM,THIS_2.MANAGER_EMPLOYEE_ID_OID,THIS_2.SALARY,THIS_2.SALARY_CURRENCY,THIS_2.SERIAL_NO FROM MANAGER THIS INNER JOIN PERSON THIS_1 ON THIS_1.PERSON_ID = THIS.EMPLOYEE_ID INNER JOIN EMPLOYEE THIS_2 ON THIS_2.EMPLOYEE_ID = THIS.EMPLOYEE_ID WHERE EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP1 INNER JOIN PERSON UNBOUND_EMP1_1 ON UNBOUND_EMP1_1.PERSON_ID = UNBOUND_EMP1.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP1 WHERE THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP1.EMPLOYEE_ID = THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_EID AND UNBOUND_EMP1_1.LASTNAME = ?) AND EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP2 INNER JOIN PERSON UNBOUND_EMP2_1 ON UNBOUND_EMP2_1.PERSON_ID = UNBOUND_EMP2.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP2 WHERE THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP2.EMPLOYEE_ID = THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_EID) AND UNBOUND_EMP2_1.LASTNAME = ?].
Success testIsEmptyOredWithContains 0.03
Success testContainsResultVariableNestedContains2 0.10
MapTest
Success testNormalPutItems 0.42
Success testNormalRemoveItem 0.19
Success testNormalEntrySet 0.10
Success testNormalKeySet 0.09
Success testNormalValues 0.11
Success testNormalNonPrimitiveKeyEntrySet 0.13
Success testNormalNonPrimitiveSameKeyValueInstances 0.94
Success testNormalNonPrimitiveKeyKeySet 0.15
Success testNormalNonPrimitiveKeyQuery 0.15
Success testNormalNonPrimitiveKeyValues 0.10
Success testNormalClearIsEmpty 0.07
Success testNormalInheritance 0.08
Success testNormalQueries 0.06
Success testNormalQueriesPrimitive 0.07
Success testNormalAttachDetach 0.18
Success testInversePutItems 0.11
Success testInverseRemoveItem 0.08
Success testInverseEntrySet 0.08
Success testInverseKeySet 0.09
Success testInverseValues 0.09
Success testInverseNonPrimitiveKeyEntrySet 0.11
Success testInverseNonPrimitiveKeyKeySet 0.10
Success testInverseNonPrimitiveKeyValues 0.14
Success testInverseClearIsEmpty 0.08
Success testInverseInheritance 0.09
Success testInverseQueries 0.11
Success testInverseAttachDetach 0.20
ValueGeneratorTest
Success testTablePoidMultiThreadedNewPM 1.72
Success testTableGenerator 0.03
Success testAUIDGenerator 5.05
Success testUUIDStringGenerator 0.04
Success testUUIDHexGenerator 0.03
Success testMaxGenerator 0.02
Success testSequenceGenerator 0.05
Success testIdentityGenerator 0.04
Success testAutoIncrementWithNoOtherFields 0.01
Success testAutoIncrementWithInheritance 0.10
Success testMixedGeneratorInherited 0.04
OptimisticTest
Success testBasicVersionNumberStrategy 0.30
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.03
Success testOptimisticQuery 0.02
Success testPCnewToPCdirty 0.03
Success testDetachAttach 0.03
Success testRefreshOfOptimisticObjects 0.02
Success testOptimisticJoinTableRelation 0.08
Success testSCOContainerClear 0.03
Success testOptimisticRollingBack 0.00
Success testRetrieveAfterPersistBeforeFlush 0.01
Success testInheritance 0.07
Success testInheritanceUsingQuery 0.03
Success testDetachAllOnCommitVersionNumber 0.02
Success testDetachCopyVersionNumber 0.02
Success testOptimisticWithIdentityFieldObjects 0.12
SQLQueryTest
Success testNullQuery 0.04
Success testInvalidQuery 0.00
Success testSelectStarQuery 0.50
Success testWithCandidateClassWithoutResultClass 0.12
Success testWithCandidateClassWithResultClass 0.11
Success testWithoutCandidateClassWithoutResultClass 0.02
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.32
Success testNumberedParameters 0.18
Success testNamedParameters 0.04
Success testTimestampQueryOnOracle 0.00
Success testSQLUpdateStatement 0.33
PersistenceModelsTest
Success testClassWithoutFields 0.51
Success testClassWithOnlyContainerFields 0.89
Success testClassWithOnlyContainerFieldsInFetchPlan 0.29
Success testPersistenceOfFKListFKListStructures 0.33
Success testPersistenceOfFKSetFKListStructures 0.20
Success test1toNInheritance 0.08
CollectionSerialTest
Success testJoinAddCollection 0.30
Success testJoinRemoveCollection 0.04
Success testJoinRetainCollection 0.04
Success testJoinClearIsEmpty 0.04
Success testJoinAttachDetach 0.09
Success testFKAddCollection 0.08
Success testFKRemoveCollection 0.06
Success testFKRetainCollection 0.06
Success testFKClearIsEmpty 0.06
Success testFKAttachDetach 0.14
HashtableTest
Success testNormalPutItems 0.39
Success testNormalRemoveItem 0.12
Success testNormalEntrySet 0.12
Success testNormalKeySet 0.08
Success testNormalValues 0.08
Success testNormalClearIsEmpty 0.07
Success testNormalInheritance 0.08
Success testNormalQueries 0.10
Success testNormalQueriesPrimitive 0.06
Success testNormalAttachDetach 0.23
Success testInversePutItems 0.10
Success testInverseRemoveItem 0.09
Success testInverseEntrySet 0.09
Success testInverseKeySet 0.10
Success testInverseValues 0.09
Success testInverseClearIsEmpty 0.10
Success testInverseInheritance 0.08
Success testInverseQueries 0.09
Success testInverseAttachDetach 0.19
SetTest
Success testNormalPersistByCollection 0.35
Success testNormalChildAddCollection 0.07
Success testNormalRemoveCollection 0.10
Success testNormalRetainCollection 0.07
Success testNormalChildRemoveCollection 0.06
Success testNormalRemoveItem 0.07
Success testNormalClearIsEmpty 0.04
Success testNormalContains 0.07
Success testNormalInheritance 0.05
Success testNormalQuery 0.13
Success testNormalAttachDetach 0.14
Success testInverseAddCollection 0.07
Success testInverseRemoveCollection 0.06
Success testInverseRetainCollection 0.06
Success testInverseAddElement 0.06
Success testInverseClearIsEmpty 0.06
Success testInverseInheritance 0.07
Success testInverseQuery 0.08
Success testInverseAttachDetach 0.12
Success testInversePersistByCollectionDFG 0.08
Success testInversePersistByElementDFG 0.03
ReachabilityTest
Success testPersistCascadeFalse 0.23
Success testOneToOneUniClassPessimistic 0.11
Success testOneToOneUniClassOptimistic 0.07
Success testOneToOneUniInterfacePessimistic 0.34
Success testOneToOneUniInterfaceOptimistic 0.03
Success testOneToOneUniClassTemporaryPessimistic 0.04
Success testOneToOneUniClassTemporaryOptimistic 0.03
Failure testOneToOneUniTemporaryStates 0.03
Field value of former persistent-new-deleted (now transient) object has been changed expected:<JPOX Corporation> but was:<null>
Success testOneToOneUniClassNewDeleted 2.83
Success testOneToOneBiClassNewDeleted 2.48
Success testDeepReachabilityByClass 0.37
Success testNewObjectUnreachableWithDirtyObjectOwner 0.21
Success testBaseOnQuery 0.06
Success testIncorrectAssignment 0.03
MapForeignKeyTest
Success testMapWithKeyAsFieldInValue 1.02
Success testMapWithValueAsFieldInKey 0.16
DatastoreIdentityTest
Success testSimpleDatastoreID 0.63
RelationshipTest
Success test1to1Unidir 0.20
Success test1to1Bidir 0.16
Success test1to1BidirQuery 0.14
Success test1to1BidirInheritance 0.29
Success test1toNBidirJoin 0.32
Success test1toNUnidirJoinSubclassTable 0.33
Success testMtoN 0.17
Success testMtoNInheritance 0.19
Success test1toNInheritance 0.08
Success testQueryWithInheritanceAndOrdering 0.06
Failure test1to1UnidirInheritanceSubclassTable 0.12
Number of readers who read "Daily Mail" newspaper was incorrect expected:<0> but was:<1>
Success test1to1BidirInheritanceSuperclassTable 0.08
Success test1toNBidir_1to1Unidir 0.12
Success test1toNunidirFK 0.06
Success test1toNUnidirFKToSelf 0.09
Success test1toNUnidirFKList 0.06
Success test1toNUnidirFKListToSelf 0.10
Success test1toNUnidirFKMap 0.12
Success test1toNUnidirFKMapToSelf 0.14
Success test1toNBidirFK 0.03
Success test1toNMap 0.17
Success test1toNUnidirFKSetInheritanceTarget 0.05
Success test1toNUnidirFKListInheritanceTarget 0.06
Success test1toNUnidirSetSharedJoin 0.05
Success test1toNUnidirSetSharedFK 0.05
Success test1toNUnidirListSharedJoin 0.06
Success test1toNUnidirListSharedFK 0.07
Success test1toNUnidirOrderedList 0.06
Success testDoublyLinkedList 0.09
Success testSinglyLinkedList 0.05
Success testParentChildLinkRelation 0.04
Success test1toNListFKUsingOrderMappedBy 0.07
LinkedListTest
Success testNormalAddCollection 0.35
Success testNormalRemoveCollection 0.10
Success testNormalRetainCollection 0.11
Success testNormalRemoveItem 0.08
Success testNormalRemoveAt 0.06
Success testNormalGetItem 0.05
Success testNormalClearIsEmpty 0.04
Success testNormalInheritance 0.05
Success testNormalQuery 0.10
Success testNormalAttachDetach 0.16
Success testInverseAddCollection 0.06
Success testInverseRemoveCollection 0.06
Success testInverseRetainCollection 0.06
Success testInverseRemoveItem 0.06
Success testInverseGetItem 0.06
Success testInverseClearIsEmpty 0.04
Success testInverseInheritance 0.06
Success testInverseQuery 0.08
Success testInverseAttachDetach 0.11
VectorTest
Success testNormalAddCollection 0.37
Success testNormalRemoveCollection 0.10
Success testNormalRetainCollection 0.11
Success testNormalRemoveItem 0.08
Success testNormalRemoveAt 0.06
Success testNormalGetItem 0.06
Success testNormalClearIsEmpty 0.05
Success testNormalInheritance 0.06
Success testNormalQuery 0.11
Success testNormalAttachDetach 0.16
Success testInverseAddCollection 0.06
Success testInverseRemoveCollection 0.06
Success testInverseRetainCollection 0.07
Success testInverseRemoveItem 0.06
Success testInverseGetItem 0.06
Success testInverseClearIsEmpty 0.04
Success testInverseInheritance 0.05
Success testInverseQuery 0.08
Success testInverselAttachDetach 0.11
PersistentInterfacesTest
Success testMakePersistent 0.79
Success testQuery 0.04
Success testFreshPMF 0.37
Success testObjectWithReferenceToPersistentInterface 0.13
Success testNewInstancePCClass 0.00
Success testNewInstance 0.00
Success testNewInstance3 0.00
StackTest
Success testNormalAddCollection 0.36
Success testNormalRemoveCollection 0.10
Success testNormalRetainCollection 0.11
Success testNormalRemoveItem 0.08
Success testNormalRemoveAt 0.06
Success testNormalGetItem 0.05
Success testNormalClearIsEmpty 0.04
Success testNormalInheritance 0.06
Success testNormalQuery 0.10
Success testNormalAttachDetach 0.16
Success testInverseAddCollection 0.06
Success testInverseRemoveCollection 0.06
Success testInverseRetainCollection 0.06
Success testInverseRemoveItem 0.06
Success testInverseGetItem 0.06
Success testInverseClearIsEmpty 0.04
Success testInverseInheritance 0.05
Success testInverseQuery 0.08
Success testInverseAttachDetach 0.11
JDOQLResultTest
Success testRangeAndUnique 0.36
Success testUniqueResultAggregates 0.08
Success testSetResultCartesianProduct1 0.70
Success testSetResultCartesianProduct2 0.10
Success testSetResultCartesianProductCollection 0.28
Error testSetResultCartesianProductMap 0.01
implement this
Success testSetResultCartesianProductContains1 0.24
Success testSetResultCartesianProductContains2 0.21
Success testSetResultCartesianProduct1to1 0.23
Success testSetResultCartesianProductContainsVariableNoNavigation 0.08
Success testOrdering 0.11
Success testOrderingUsingCollectionExpression 0.18
Success testSetResultDistinct 0.04
Success testSetResult 0.03
Success testCandidateCollection 0.04
Success testCandidateCollectionWithResultNotSameTypeAsCandidates 0.02
Success testSetIllegalAttributeInResult 0.02
Success testSetResultParameter 0.08
Success testResultSetMetaData 0.06
Success testSetResultWithAggregationWithoutSubclasses 0.04
Success testSetResultWithAggregationWithSubclasses 0.02
Success testSetResultWithAggregation1 0.04
Success testSetResultWithAggregation2 0.03
Success testSetResultWithAggregationAndNonAggregateExpression 0.04
Success testSetResultWithAggregationAndNonAggregateExpression2 0.01
Success testResultSetInsensitive 0.05
Success testCountOnClassHierarchy 0.03
Success testNewObjectInResult 0.05
Success testSetResultClass 0.04
LinkedHashMapTest
Success testNormalPutItems 0.39
Success testNormalRemoveItem 0.11
Success testNormalEntrySet 0.12
Success testNormalKeySet 0.08
Success testNormalValues 0.08
Success testNormalClearIsEmpty 0.08
Success testNormalInheritance 0.08
Success testNormalQueries 0.10
Success testNormalQueriesPrimitive 0.06
Success testNormalAttachDetach 0.24
Success testInversePutItems 0.10
Success testInverseRemoveItem 0.09
Success testInverseEntrySet 0.09
Success testInverseKeySet 0.10
Success testInverseValues 0.09
Success testInverseClearIsEmpty 0.10
Success testInverseInheritance 0.09
Success testInverseQueries 0.09
Success testInverseAttachDetach 0.20
DependentFieldTest
Success testDependentFieldsDeletion 0.83
Success testDependentFieldsInverseSetsDeletion 0.27
Success testDependentFieldsInverseListsDeletion 0.27
Success testDependentFieldsInverseMapsDeletion 0.31
Success testDependentFieldsInverseMapsValuesDeletion 0.27
Success testDependentFieldsInverseMapsKeysDeletion 0.26
Success testDependentElementsRemovalUsingJoinTable 0.28
Success testDependentElementsRemovalUsingForeignKey 0.28
Success testDependentKeysRemovalUsingJoinTable 0.23
Success testDependentKeysRemovalUsingForeignKey 0.24
Success testBidirectionalDependentFields 0.28
Success testInterfaceDependentFields 0.35
Success testNullify1to1Relation 0.16
Success testRemoveDependentFieldOnDetached 0.16
AbstractClassesTest
Success testCreationSimple 0.40
Success testRetrievalSimple 0.14
Success testQuerySimple 0.11
Success testDeletionSimple 0.15
Success testJoinTableSetCreationSimple 0.05
Success testJoinTableSetRetrievalSimple 0.06
Success testJoinTableListCreationSimple 0.04
Success testJoinTableListRetrievalSimple 0.05
Success testAbstractWithCollection 0.43
HashMapTest
Success testNormalPutItems 0.42
Success testNormalRemoveItem 0.12
Success testNormalEntrySet 0.13
Success testNormalKeySet 0.08
Success testNormalValues 0.08
Success testNormalClearIsEmpty 0.08
Success testNormalInheritance 0.08
Success testNormalQueries 0.10
Success testNormalQueriesPrimitive 0.06
Success testNormalAttachDetach 0.24
Success testInversePutItems 0.10
Success testInverseRemoveItem 0.09
Success testInverseEntrySet 0.09
Success testInverseKeySet 0.09
Success testInverseValues 0.10
Success testInverseClearIsEmpty 0.10
Success testInverseInheritance 0.08
Success testInverseQueries 0.09
Success testInverseAttachDetach 0.20
InterfacesTest
Success testCreation 0.89
Success testReadAllShapeHolders 0.18
Success testChangeImplementation 0.11
Success testNullValues 0.02
Success testInsertThenDelete 0.03
Success testSetJoin 0.05
Success testListJoin 0.09
Failure testSetFK 0.07
Exception thrown during create of set of interface objects using FK : [JPOX-056041] Class "org.jpox.samples.interfaces.ShapeHolder3" has collection field "shapeList" and this has no mapping in the table for the index of the element class "org.jpox.samples.interfaces.SquareInverse". Maybe you declared the field as a java.util.Collection and instantiated it as a java.util.List yet omitted the <order> element in the MetaData ?
Error testListFK 0.02
[JPOX-056041] Class "org.jpox.samples.interfaces.ShapeHolder3" has collection field "shapeList" and this has no mapping in the table for the index of the element class "org.jpox.samples.interfaces.SquareInverse". Maybe you declared the field as a java.util.Collection and instantiated it as a java.util.List yet omitted the <order> element in the MetaData ?
Success testMultipleImplementations 0.05
Success testMultipleImplWithMissingColumns 0.05
Success testQueryOnInterfaceFields 0.45
Success testQueryOnInterfaceFieldsBooleanOps 0.42
Success testCorrectCastOnInterfaceField 0.36
Success testAccessToFieldsInInterfaces 0.36
Success testQueryForNullShape 0.34
Success testQueryForNonNullShape 0.33
QueueTest
Success testQueue1 0.60
CollectionPrimitiveTest
Success testCollectionNonPCUsingJoinTable 0.35
Success testCollectionNonPCWithoutJoinTable 0.10
Success testCollectionNonPCSerialised 0.05
LinkedHashSetTest
Success testNormalAddCollection 0.35
Success testNormalChildAddCollection 0.07
Success testNormalRemoveCollection 0.10
Success testNormalRetainCollection 0.07
Success testNormalChildRemoveCollection 0.05
Success testNormalRemoveItem 0.07
Success testNormalClearIsEmpty 0.05
Success testNormalInheritance 0.05
Success testNormalQuery 0.10
Success testNormalAttachDetach 0.13
Success testInverseAddCollection 0.07
Success testInverseRemoveCollection 0.06
Success testInverseRetainCollection 0.06
Success testInverseAddElement 0.07
Success testInverseClearIsEmpty 0.05
Success testInverseInheritance 0.07
Success testInverseQuery 0.09
Success testInverseAttachDetach 0.12
ObjectsTest
Success testOneToOneRelation 0.80
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.19
Success testNewTableOverrideFields 0.03
Success testSuperclassTableValueMapInteger 0.02
CollectionTest
Success testNormalAddCollection 0.34
Success testNormalChildAddCollection 0.06
Success testNormalRemoveCollection 0.10
Success testNormalRetainCollection 0.07
Success testNormalChildRemoveCollection 0.06
Success testNormalRemoveItem 0.07
Success testNormalClearIsEmpty 0.05
Success testNormalInheritance 0.06
Success testNormalQuery 0.11
Success testNormalAttachDetach 0.14
Success testInverseAddCollection 0.08
Success testInverseRemoveCollection 0.06
Success testInverseRetainCollection 0.07
Success testInverseAddElement 0.06
Success testInverseClearIsEmpty 0.05
Success testInverseInheritance 0.08
Success testInverseQuery 0.09
Success testInverseAttachDetach 0.12
PropertiesTest
Success testNormalPutItems 0.34
Success testNormalRemoveItem 0.04
Success testNormalEntrySet 0.04
Success testNormalKeySet 0.03
Success testNormalValues 0.04
Success testNormalClearIsEmpty 0.04
Success testNormalAttachDetach 0.08
Failure details
Failure testAvg
Exception thrown executing JDOQL query with AVG : [JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.types.basic.BasicTypeHolder' AS JPOXMETADATA,THIS.BASICTYPEHOLDER_ID,THIS.BOOLEAN_FIELD,THIS.BOOLEAN_OBJ_FIELD,THIS.BYTE_FIELD,THIS.BYTE_OBJ_FIELD,THIS.CHAR_FIELD,THIS.CHAR_OBJ_FIELD,THIS.INT_FIELD,THIS.INT_OBJ_FIELD,THIS.LONG_FIELD,THIS.LONG_OBJ_FIELD,THIS.SHORT_FIELD,THIS.SHORT_OBJ_FIELD FROM BASICTYPEHOLDER THIS , BASICTYPEHOLDER UNBOUND_P WHERE THIS.LONG_FIELD = AVG(UNBOUND_P.LONG_FIELD)" : Not a condition in statement [SELECT 'org.jpox.samples.types.basic.BasicTypeHolder' AS JPOXMETADATA,THIS.BASICTYPEHOLDER_ID,THIS.BOOLEAN_FIELD,THIS.BOOLEAN_OBJ_FIELD,THIS.BYTE_FIELD,THIS.BYTE_OBJ_FIELD,THIS.CHAR_FIELD,THIS.CHAR_OBJ_FIELD,THIS.INT_FIELD,THIS.INT_OBJ_FIELD,THIS.LONG_FIELD,THIS.LONG_OBJ_FIELD,THIS.SHORT_FIELD,THIS.SHORT_OBJ_FIELD FROM BASICTYPEHOLDER THIS , BASICTYPEHOLDER UNBOUND_P WHERE THIS.LONG_FIELD = AVG(UNBOUND_P.LONG_FIELD)].
junit.framework.AssertionFailedError: Exception thrown executing JDOQL query with AVG : [JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.types.basic.BasicTypeHolder' AS JPOXMETADATA,THIS.BASICTYPEHOLDER_ID,THIS.BOOLEAN_FIELD,THIS.BOOLEAN_OBJ_FIELD,THIS.BYTE_FIELD,THIS.BYTE_OBJ_FIELD,THIS.CHAR_FIELD,THIS.CHAR_OBJ_FIELD,THIS.INT_FIELD,THIS.INT_OBJ_FIELD,THIS.LONG_FIELD,THIS.LONG_OBJ_FIELD,THIS.SHORT_FIELD,THIS.SHORT_OBJ_FIELD FROM BASICTYPEHOLDER THIS , BASICTYPEHOLDER UNBOUND_P WHERE THIS.LONG_FIELD = AVG(UNBOUND_P.LONG_FIELD)" : Not a condition in statement [SELECT 'org.jpox.samples.types.basic.BasicTypeHolder' AS JPOXMETADATA,THIS.BASICTYPEHOLDER_ID,THIS.BOOLEAN_FIELD,THIS.BOOLEAN_OBJ_FIELD,THIS.BYTE_FIELD,THIS.BYTE_OBJ_FIELD,THIS.CHAR_FIELD,THIS.CHAR_OBJ_FIELD,THIS.INT_FIELD,THIS.INT_OBJ_FIELD,THIS.LONG_FIELD,THIS.LONG_OBJ_FIELD,THIS.SHORT_FIELD,THIS.SHORT_OBJ_FIELD FROM BASICTYPEHOLDER THIS , BASICTYPEHOLDER UNBOUND_P WHERE THIS.LONG_FIELD = AVG(UNBOUND_P.LONG_FIELD)]. at org.jpox.tests.JDOQLBasicTest.testAvg(JDOQLBasicTest.java:1542)
Failure testEq_Neq_UnboundVariables
expected:<2> but was:<0>
junit.framework.AssertionFailedError: expected:<2> but was:<0> at org.jpox.tests.JDOQLBasicTest.testEq_Neq_UnboundVariables(JDOQLBasicTest.java:2512)
Failure testInheritanceCastWithUnion
Exception thrown during test [JPOX-052500] Range variable THIS_INST already in use in query : SELECT 'org.jpox.samples.inheritance.ABase' AS JPOXMETADATA FROM ABASE THIS LEFT OUTER JOIN ASUB2 SUBELEMENT0 ON SUBELEMENT0.ASUB2_ID = THIS.ABASE_ID LEFT OUTER JOIN ASUB1 SUBELEMENT1 ON SUBELEMENT1.ASUB1_ID = THIS.ABASE_ID INNER JOIN ASUB1 THIS_INST ON THIS_INST.ASUB1_ID = THIS.ABASE_ID WHERE SUBELEMENT0.ASUB2_ID IS NULL AND SUBELEMENT1.ASUB1_ID IS NULL UNION SELECT 'org.jpox.samples.inheritance.ASub2' AS JPOXMETADATA FROM ABASE THIS INNER JOIN ASUB2 "ELEMENT" ON "ELEMENT".ASUB2_ID = THIS.ABASE_ID INNER JOIN ASUB1 THIS_INST ON THIS_INST.ASUB1_ID = THIS.ABASE_ID UNION SELECT 'org.jpox.samples.inheritance.ASub1' AS JPOXMETADATA FROM ABASE THIS INNER JOIN ASUB1 "ELEMENT" ON "ELEMENT".ASUB1_ID = THIS.ABASE_ID INNER JOIN ASUB1 THIS_INST ON THIS_INST.ASUB1_ID = THIS.ABASE_ID
junit.framework.AssertionFailedError: Exception thrown during test [JPOX-052500] Range variable THIS_INST already in use in query : SELECT 'org.jpox.samples.inheritance.ABase' AS JPOXMETADATA FROM ABASE THIS LEFT OUTER JOIN ASUB2 SUBELEMENT0 ON SUBELEMENT0.ASUB2_ID = THIS.ABASE_ID LEFT OUTER JOIN ASUB1 SUBELEMENT1 ON SUBELEMENT1.ASUB1_ID = THIS.ABASE_ID INNER JOIN ASUB1 THIS_INST ON THIS_INST.ASUB1_ID = THIS.ABASE_ID WHERE SUBELEMENT0.ASUB2_ID IS NULL AND SUBELEMENT1.ASUB1_ID IS NULL UNION SELECT 'org.jpox.samples.inheritance.ASub2' AS JPOXMETADATA FROM ABASE THIS INNER JOIN ASUB2 "ELEMENT" ON "ELEMENT".ASUB2_ID = THIS.ABASE_ID INNER JOIN ASUB1 THIS_INST ON THIS_INST.ASUB1_ID = THIS.ABASE_ID UNION SELECT 'org.jpox.samples.inheritance.ASub1' AS JPOXMETADATA FROM ABASE THIS INNER JOIN ASUB1 "ELEMENT" ON "ELEMENT".ASUB1_ID = THIS.ABASE_ID INNER JOIN ASUB1 THIS_INST ON THIS_INST.ASUB1_ID = THIS.ABASE_ID at org.jpox.tests.JDOQLBasicTest.testInheritanceCastWithUnion(JDOQLBasicTest.java:3554)
Failure testGetInOrderingInMapFields
expected:<2> but was:<3>
junit.framework.AssertionFailedError: expected:<2> but was:<3> at org.jpox.tests.JDOQLContainerTest.testGetInOrderingInMapFields(JDOQLContainerTest.java:735)
Error testContainsInParameterArray2
[JPOX-021060] Error binding "dept0" to "ObjectExpression "UNBOUND_DEPT0.DEPARTMENT_ID"" since it was previously bound to "ObjectExpression "UNBOUND_DEPT0.DEPARTMENT_ID"".
javax.jdo.JDOFatalInternalException: [JPOX-021060] Error binding "dept0" to "ObjectExpression "UNBOUND_DEPT0.DEPARTMENT_ID"" since it was previously bound to "ObjectExpression "UNBOUND_DEPT0.DEPARTMENT_ID"". at org.jpox.jdo.JPOXJDOHelper.getJDOExceptionForJPOXException(JPOXJDOHelper.java:393) at org.jpox.jdo.JDOQuery.execute(JDOQuery.java:227) at org.jpox.tests.JDOQLContainerTest.testContainsInParameterArray2(JDOQLContainerTest.java:1257) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) NestedThrowablesStackTrace: [JPOX-021060] Error binding "dept0" to "ObjectExpression "UNBOUND_DEPT0.DEPARTMENT_ID"" since it was previously bound to "ObjectExpression "UNBOUND_DEPT0.DEPARTMENT_ID"". org.jpox.exceptions.JPOXException: [JPOX-021060] Error binding "dept0" to "ObjectExpression "UNBOUND_DEPT0.DEPARTMENT_ID"" since it was previously bound to "ObjectExpression "UNBOUND_DEPT0.DEPARTMENT_ID"". at org.jpox.store.rdbms.query.JavaQueryCompiler.bindVariable(JavaQueryCompiler.java:594) at org.jpox.store.expression.UnboundVariable.bindTo(UnboundVariable.java:119) at org.jpox.store.expression.UnboundVariable.eq(UnboundVariable.java:180) at org.jpox.store.expression.ObjectExpression.eq(ObjectExpression.java:312) at org.jpox.store.expression.ObjectLiteral.eq(ObjectLiteral.java:124) at org.jpox.store.expression.ArrayExpression.containsMethod(ArrayExpression.java:163) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at org.jpox.store.expression.ScalarExpression.callMethod(ScalarExpression.java:836) at org.jpox.store.rdbms.query.JDOQLQueryCompiler.compilePrimary(JDOQLQueryCompiler.java:669) at org.jpox.store.rdbms.query.JavaQueryCompiler.compileUnaryExpressionNotPlusMinus(JavaQueryCompiler.java:765) at org.jpox.store.rdbms.query.JavaQueryCompiler.compileUnaryExpression(JavaQueryCompiler.java:746) at org.jpox.store.rdbms.query.JavaQueryCompiler.compileMultiplicativeExpression(JavaQueryCompiler.java:699) at org.jpox.store.rdbms.query.JavaQueryCompiler.compileAdditiveExpression(JavaQueryCompiler.java:676) at org.jpox.store.rdbms.query.JDOQLQueryCompiler.compileRelationalExpression(JDOQLQueryCompiler.java:506) at org.jpox.store.rdbms.query.JDOQLQueryCompiler.compileEqualityExpression(JDOQLQueryCompiler.java:478) at org.jpox.store.rdbms.query.JDOQLQueryCompiler.compileAndExpression(JDOQLQueryCompiler.java:466) at org.jpox.store.rdbms.query.JDOQLQueryCompiler.compileExclusiveOrExpression(JDOQLQueryCompiler.java:454) at org.jpox.store.rdbms.query.JDOQLQueryCompiler.compileInclusiveOrExpression(JDOQLQueryCompiler.java:442) at org.jpox.store.rdbms.query.JDOQLQueryCompiler.compileConditionalAndExpression(JDOQLQueryCompiler.java:430) at org.jpox.store.rdbms.query.JDOQLQueryCompiler.compileConditionalOrExpression(JDOQLQueryCompiler.java:412) at org.jpox.store.rdbms.query.JDOQLQueryCompiler.compileExpression(JDOQLQueryCompiler.java:389) at org.jpox.store.rdbms.query.JDOQLQueryCompiler.compileExpressionFromString(JDOQLQueryCompiler.java:369) at org.jpox.store.rdbms.query.JavaQueryCompiler.compileFilter(JavaQueryCompiler.java:280) at org.jpox.store.rdbms.query.JDOQLQueryCompiler.performCompile(JDOQLQueryCompiler.java:189) at org.jpox.store.rdbms.query.JavaQueryCompiler.executionCompile(JavaQueryCompiler.java:188) at org.jpox.store.rdbms.query.JDOQLQuery.compileInternal(JDOQLQuery.java:165) at org.jpox.store.rdbms.query.JDOQLQuery.performExecute(JDOQLQuery.java:246) at org.jpox.store.query.Query.executeWithMap(Query.java:1267) at org.jpox.store.query.Query.executeWithArray(Query.java:1233) at org.jpox.store.query.Query.execute(Query.java:1166) at org.jpox.jdo.JDOQuery.execute(JDOQuery.java:222) at org.jpox.tests.JDOQLContainerTest.testContainsInParameterArray2(JDOQLContainerTest.java:1257)
Error testMapGetAsLiteralWithKeyAsExpression
Cannot perform operation "getMethod" on MapKeyLiteral "('2 doors')" and StringExpression "THIS.MODEL"
javax.jdo.JDOUserException: Cannot perform operation "getMethod" on MapKeyLiteral "('2 doors')" and StringExpression "THIS.MODEL" at org.jpox.jdo.JPOXJDOHelper.getJDOExceptionForJPOXException(JPOXJDOHelper.java:354) at org.jpox.jdo.JDOQuery.execute(JDOQuery.java:227) at org.jpox.tests.JDOQLContainerTest.testMapGetAsLiteralWithKeyAsExpression(JDOQLContainerTest.java:1808) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) NestedThrowablesStackTrace: Cannot perform operation "getMethod" on MapKeyLiteral "('2 doors')" and StringExpression "THIS.MODEL" org.jpox.store.expression.ScalarExpression$IllegalOperationException: Cannot perform operation "getMethod" on MapKeyLiteral "('2 doors')" and StringExpression "THIS.MODEL" at org.jpox.store.expression.MapKeyLiteral.getMethod(MapKeyLiteral.java:152) at org.jpox.store.expression.MapLiteral.getMethod(MapLiteral.java:119) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at org.jpox.store.expression.ScalarExpression.callMethod(ScalarExpression.java:836) at org.jpox.store.rdbms.query.JDOQLQueryCompiler.compilePrimary(JDOQLQueryCompiler.java:669) at org.jpox.store.rdbms.query.JavaQueryCompiler.compileUnaryExpressionNotPlusMinus(JavaQueryCompiler.java:765) at org.jpox.store.rdbms.query.JavaQueryCompiler.compileUnaryExpression(JavaQueryCompiler.java:746) at org.jpox.store.rdbms.query.JavaQueryCompiler.compileMultiplicativeExpression(JavaQueryCompiler.java:699) at org.jpox.store.rdbms.query.JavaQueryCompiler.compileAdditiveExpression(JavaQueryCompiler.java:676) at org.jpox.store.rdbms.query.JDOQLQueryCompiler.compileRelationalExpression(JDOQLQueryCompiler.java:506) at org.jpox.store.rdbms.query.JDOQLQueryCompiler.compileEqualityExpression(JDOQLQueryCompiler.java:484) at org.jpox.store.rdbms.query.JDOQLQueryCompiler.compileAndExpression(JDOQLQueryCompiler.java:466) at org.jpox.store.rdbms.query.JDOQLQueryCompiler.compileExclusiveOrExpression(JDOQLQueryCompiler.java:454) at org.jpox.store.rdbms.query.JDOQLQueryCompiler.compileInclusiveOrExpression(JDOQLQueryCompiler.java:442) at org.jpox.store.rdbms.query.JDOQLQueryCompiler.compileConditionalAndExpression(JDOQLQueryCompiler.java:430) at org.jpox.store.rdbms.query.JDOQLQueryCompiler.compileConditionalOrExpression(JDOQLQueryCompiler.java:412) at org.jpox.store.rdbms.query.JDOQLQueryCompiler.compileExpression(JDOQLQueryCompiler.java:389) at org.jpox.store.rdbms.query.JDOQLQueryCompiler.compileExpressionFromString(JDOQLQueryCompiler.java:369) at org.jpox.store.rdbms.query.JavaQueryCompiler.compileFilter(JavaQueryCompiler.java:280) at org.jpox.store.rdbms.query.JDOQLQueryCompiler.performCompile(JDOQLQueryCompiler.java:189) at org.jpox.store.rdbms.query.JavaQueryCompiler.executionCompile(JavaQueryCompiler.java:188) at org.jpox.store.rdbms.query.JDOQLQuery.compileInternal(JDOQLQuery.java:165) at org.jpox.store.rdbms.query.JDOQLQuery.performExecute(JDOQLQuery.java:246) at org.jpox.store.query.Query.executeWithMap(Query.java:1267) at org.jpox.store.query.Query.executeWithArray(Query.java:1233) at org.jpox.store.query.Query.execute(Query.java:1166) at org.jpox.jdo.JDOQuery.execute(JDOQuery.java:222) at org.jpox.tests.JDOQLContainerTest.testMapGetAsLiteralWithKeyAsExpression(JDOQLContainerTest.java:1808)
Error testQueryUsesContainsTwiceOnFieldUsingWorkaround
[JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.models.company.Manager' AS JPOXMETADATA,THIS.EMPLOYEE_ID,THIS_1.AGE,THIS_1.EMAIL_ADDRESS,THIS_1.FIRSTNAME,THIS_1.GLOBALNUM,THIS_1.LASTNAME,THIS_1.PERSONNUM,THIS_2.MANAGER_EMPLOYEE_ID_OID,THIS_2.SALARY,THIS_2.SALARY_CURRENCY,THIS_2.SERIAL_NO FROM MANAGER THIS INNER JOIN PERSON THIS_1 ON THIS_1.PERSON_ID = THIS.EMPLOYEE_ID INNER JOIN EMPLOYEE THIS_2 ON THIS_2.EMPLOYEE_ID = THIS.EMPLOYEE_ID WHERE EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP1 INNER JOIN PERSON UNBOUND_EMP1_1 ON UNBOUND_EMP1_1.PERSON_ID = UNBOUND_EMP1.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP1 WHERE THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP1.EMPLOYEE_ID = THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_EID) AND EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP2 INNER JOIN PERSON UNBOUND_EMP2_1 ON UNBOUND_EMP2_1.PERSON_ID = UNBOUND_EMP2.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP2 WHERE THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP2.EMPLOYEE_ID = THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_EID) AND UNBOUND_EMP1_1.LASTNAME = ? OR UNBOUND_EMP2_1.LASTNAME = ?" : Column not found: UNBOUND_EMP1_1.LASTNAME in statement [SELECT 'org.jpox.samples.models.company.Manager' AS JPOXMETADATA,THIS.EMPLOYEE_ID,THIS_1.AGE,THIS_1.EMAIL_ADDRESS,THIS_1.FIRSTNAME,THIS_1.GLOBALNUM,THIS_1.LASTNAME,THIS_1.PERSONNUM,THIS_2.MANAGER_EMPLOYEE_ID_OID,THIS_2.SALARY,THIS_2.SALARY_CURRENCY,THIS_2.SERIAL_NO FROM MANAGER THIS INNER JOIN PERSON THIS_1 ON THIS_1.PERSON_ID = THIS.EMPLOYEE_ID INNER JOIN EMPLOYEE THIS_2 ON THIS_2.EMPLOYEE_ID = THIS.EMPLOYEE_ID WHERE EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP1 INNER JOIN PERSON UNBOUND_EMP1_1 ON UNBOUND_EMP1_1.PERSON_ID = UNBOUND_EMP1.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP1 WHERE THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP1.EMPLOYEE_ID = THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_EID) AND EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP2 INNER JOIN PERSON UNBOUND_EMP2_1 ON UNBOUND_EMP2_1.PERSON_ID = UNBOUND_EMP2.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP2 WHERE THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP2.EMPLOYEE_ID = THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_EID) AND UNBOUND_EMP1_1.LASTNAME = ? OR UNBOUND_EMP2_1.LASTNAME = ?].
javax.jdo.JDODataStoreException: [JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.models.company.Manager' AS JPOXMETADATA,THIS.EMPLOYEE_ID,THIS_1.AGE,THIS_1.EMAIL_ADDRESS,THIS_1.FIRSTNAME,THIS_1.GLOBALNUM,THIS_1.LASTNAME,THIS_1.PERSONNUM,THIS_2.MANAGER_EMPLOYEE_ID_OID,THIS_2.SALARY,THIS_2.SALARY_CURRENCY,THIS_2.SERIAL_NO FROM MANAGER THIS INNER JOIN PERSON THIS_1 ON THIS_1.PERSON_ID = THIS.EMPLOYEE_ID INNER JOIN EMPLOYEE THIS_2 ON THIS_2.EMPLOYEE_ID = THIS.EMPLOYEE_ID WHERE EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP1 INNER JOIN PERSON UNBOUND_EMP1_1 ON UNBOUND_EMP1_1.PERSON_ID = UNBOUND_EMP1.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP1 WHERE THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP1.EMPLOYEE_ID = THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_EID) AND EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP2 INNER JOIN PERSON UNBOUND_EMP2_1 ON UNBOUND_EMP2_1.PERSON_ID = UNBOUND_EMP2.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP2 WHERE THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP2.EMPLOYEE_ID = THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_EID) AND UNBOUND_EMP1_1.LASTNAME = ? OR UNBOUND_EMP2_1.LASTNAME = ?" : Column not found: UNBOUND_EMP1_1.LASTNAME in statement [SELECT 'org.jpox.samples.models.company.Manager' AS JPOXMETADATA,THIS.EMPLOYEE_ID,THIS_1.AGE,THIS_1.EMAIL_ADDRESS,THIS_1.FIRSTNAME,THIS_1.GLOBALNUM,THIS_1.LASTNAME,THIS_1.PERSONNUM,THIS_2.MANAGER_EMPLOYEE_ID_OID,THIS_2.SALARY,THIS_2.SALARY_CURRENCY,THIS_2.SERIAL_NO FROM MANAGER THIS INNER JOIN PERSON THIS_1 ON THIS_1.PERSON_ID = THIS.EMPLOYEE_ID INNER JOIN EMPLOYEE THIS_2 ON THIS_2.EMPLOYEE_ID = THIS.EMPLOYEE_ID WHERE EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP1 INNER JOIN PERSON UNBOUND_EMP1_1 ON UNBOUND_EMP1_1.PERSON_ID = UNBOUND_EMP1.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP1 WHERE THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP1.EMPLOYEE_ID = THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_EID) AND EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP2 INNER JOIN PERSON UNBOUND_EMP2_1 ON UNBOUND_EMP2_1.PERSON_ID = UNBOUND_EMP2.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP2 WHERE THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP2.EMPLOYEE_ID = THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_EID) AND UNBOUND_EMP1_1.LASTNAME = ? OR UNBOUND_EMP2_1.LASTNAME = ?]. at org.jpox.jdo.JPOXJDOHelper.getJDOExceptionForJPOXException(JPOXJDOHelper.java:289) at org.jpox.jdo.JDOQuery.execute(JDOQuery.java:209) at org.jpox.tests.JDOQLContainerTest.testQueryUsesContainsTwiceOnFieldUsingWorkaround(JDOQLContainerTest.java:4647) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) NestedThrowablesStackTrace: java.sql.SQLException: Column not found: UNBOUND_EMP1_1.LASTNAME in statement [SELECT 'org.jpox.samples.models.company.Manager' AS JPOXMETADATA,THIS.EMPLOYEE_ID,THIS_1.AGE,THIS_1.EMAIL_ADDRESS,THIS_1.FIRSTNAME,THIS_1.GLOBALNUM,THIS_1.LASTNAME,THIS_1.PERSONNUM,THIS_2.MANAGER_EMPLOYEE_ID_OID,THIS_2.SALARY,THIS_2.SALARY_CURRENCY,THIS_2.SERIAL_NO FROM MANAGER THIS INNER JOIN PERSON THIS_1 ON THIS_1.PERSON_ID = THIS.EMPLOYEE_ID INNER JOIN EMPLOYEE THIS_2 ON THIS_2.EMPLOYEE_ID = THIS.EMPLOYEE_ID WHERE EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP1 INNER JOIN PERSON UNBOUND_EMP1_1 ON UNBOUND_EMP1_1.PERSON_ID = UNBOUND_EMP1.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP1 WHERE THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP1.EMPLOYEE_ID = THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_EID) AND EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP2 INNER JOIN PERSON UNBOUND_EMP2_1 ON UNBOUND_EMP2_1.PERSON_ID = UNBOUND_EMP2.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP2 WHERE THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP2.EMPLOYEE_ID = THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_EID) AND UNBOUND_EMP1_1.LASTNAME = ? OR UNBOUND_EMP2_1.LASTNAME = ?] at org.hsqldb.jdbc.Util.throwError(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source) at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source) at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:181) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:283) at org.jpox.store.rdbms.SQLController.getStatementForQuery(SQLController.java:302) at org.jpox.store.rdbms.query.SQLEvaluator.getStatement(SQLEvaluator.java:270) at org.jpox.store.rdbms.query.SQLEvaluator.evaluate(SQLEvaluator.java:95) at org.jpox.store.rdbms.query.JDOQLQuery.performExecute(JDOQLQuery.java:319) at org.jpox.store.query.Query.executeWithMap(Query.java:1267) at org.jpox.store.query.Query.executeWithArray(Query.java:1233) at org.jpox.store.query.Query.execute(Query.java:1154) at org.jpox.jdo.JDOQuery.execute(JDOQuery.java:204) at org.jpox.tests.JDOQLContainerTest.testQueryUsesContainsTwiceOnFieldUsingWorkaround(JDOQLContainerTest.java:4647)
Error testQueryUsesContainsValueTwiceOnFieldUsingWorkaround
[JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM GYM_WARDROBES THIS_WARDROBES_W1 , WARDROBE UNBOUND_W1 WHERE THIS_WARDROBES_W1.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES_W1.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W1.WARDROBE_ID = THIS_WARDROBES_W1.WARDROBE_ID_VID) AND EXISTS (SELECT 1 FROM GYM_WARDROBES THIS_WARDROBES_W2 , WARDROBE UNBOUND_W2 WHERE THIS_WARDROBES_W2.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES_W2.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W2.WARDROBE_ID = THIS_WARDROBES_W2.WARDROBE_ID_VID) AND UNBOUND_W1.MODEL = ? OR UNBOUND_W2.MODEL = ?" : Column not found: UNBOUND_W1.MODEL in statement [SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM GYM_WARDROBES THIS_WARDROBES_W1 , WARDROBE UNBOUND_W1 WHERE THIS_WARDROBES_W1.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES_W1.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W1.WARDROBE_ID = THIS_WARDROBES_W1.WARDROBE_ID_VID) AND EXISTS (SELECT 1 FROM GYM_WARDROBES THIS_WARDROBES_W2 , WARDROBE UNBOUND_W2 WHERE THIS_WARDROBES_W2.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES_W2.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W2.WARDROBE_ID = THIS_WARDROBES_W2.WARDROBE_ID_VID) AND UNBOUND_W1.MODEL = ? OR UNBOUND_W2.MODEL = ?].
javax.jdo.JDODataStoreException: [JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM GYM_WARDROBES THIS_WARDROBES_W1 , WARDROBE UNBOUND_W1 WHERE THIS_WARDROBES_W1.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES_W1.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W1.WARDROBE_ID = THIS_WARDROBES_W1.WARDROBE_ID_VID) AND EXISTS (SELECT 1 FROM GYM_WARDROBES THIS_WARDROBES_W2 , WARDROBE UNBOUND_W2 WHERE THIS_WARDROBES_W2.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES_W2.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W2.WARDROBE_ID = THIS_WARDROBES_W2.WARDROBE_ID_VID) AND UNBOUND_W1.MODEL = ? OR UNBOUND_W2.MODEL = ?" : Column not found: UNBOUND_W1.MODEL in statement [SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM GYM_WARDROBES THIS_WARDROBES_W1 , WARDROBE UNBOUND_W1 WHERE THIS_WARDROBES_W1.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES_W1.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W1.WARDROBE_ID = THIS_WARDROBES_W1.WARDROBE_ID_VID) AND EXISTS (SELECT 1 FROM GYM_WARDROBES THIS_WARDROBES_W2 , WARDROBE UNBOUND_W2 WHERE THIS_WARDROBES_W2.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES_W2.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W2.WARDROBE_ID = THIS_WARDROBES_W2.WARDROBE_ID_VID) AND UNBOUND_W1.MODEL = ? OR UNBOUND_W2.MODEL = ?]. at org.jpox.jdo.JPOXJDOHelper.getJDOExceptionForJPOXException(JPOXJDOHelper.java:289) at org.jpox.jdo.JDOQuery.execute(JDOQuery.java:209) at org.jpox.tests.JDOQLContainerTest.testQueryUsesContainsValueTwiceOnFieldUsingWorkaround(JDOQLContainerTest.java:4733) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) NestedThrowablesStackTrace: java.sql.SQLException: Column not found: UNBOUND_W1.MODEL in statement [SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM GYM_WARDROBES THIS_WARDROBES_W1 , WARDROBE UNBOUND_W1 WHERE THIS_WARDROBES_W1.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES_W1.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W1.WARDROBE_ID = THIS_WARDROBES_W1.WARDROBE_ID_VID) AND EXISTS (SELECT 1 FROM GYM_WARDROBES THIS_WARDROBES_W2 , WARDROBE UNBOUND_W2 WHERE THIS_WARDROBES_W2.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES_W2.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W2.WARDROBE_ID = THIS_WARDROBES_W2.WARDROBE_ID_VID) AND UNBOUND_W1.MODEL = ? OR UNBOUND_W2.MODEL = ?] at org.hsqldb.jdbc.Util.throwError(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source) at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source) at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:181) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:283) at org.jpox.store.rdbms.SQLController.getStatementForQuery(SQLController.java:302) at org.jpox.store.rdbms.query.SQLEvaluator.getStatement(SQLEvaluator.java:270) at org.jpox.store.rdbms.query.SQLEvaluator.evaluate(SQLEvaluator.java:95) at org.jpox.store.rdbms.query.JDOQLQuery.performExecute(JDOQLQuery.java:319) at org.jpox.store.query.Query.executeWithMap(Query.java:1267) at org.jpox.store.query.Query.executeWithArray(Query.java:1233) at org.jpox.store.query.Query.execute(Query.java:1154) at org.jpox.jdo.JDOQuery.execute(JDOQuery.java:204) at org.jpox.tests.JDOQLContainerTest.testQueryUsesContainsValueTwiceOnFieldUsingWorkaround(JDOQLContainerTest.java:4733)
Error testQueryUsesContainsValueTwiceOnFieldUsingWorkaroundInverse
[JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE_W1 WHERE THIS_WARDROBESINVERSE_W1.GYM_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE_W1.GYM_GYM_ID_OID = THIS.GYM_ID) AND EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE_W2 WHERE THIS_WARDROBESINVERSE_W2.GYM_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE_W2.GYM_GYM_ID_OID = THIS.GYM_ID) AND THIS_WARDROBESINVERSE_W1.MODEL = ? OR THIS_WARDROBESINVERSE_W2.MODEL = ?" : Column not found: THIS_WARDROBESINVERSE_W1.MODEL in statement [SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE_W1 WHERE THIS_WARDROBESINVERSE_W1.GYM_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE_W1.GYM_GYM_ID_OID = THIS.GYM_ID) AND EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE_W2 WHERE THIS_WARDROBESINVERSE_W2.GYM_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE_W2.GYM_GYM_ID_OID = THIS.GYM_ID) AND THIS_WARDROBESINVERSE_W1.MODEL = ? OR THIS_WARDROBESINVERSE_W2.MODEL = ?].
javax.jdo.JDODataStoreException: [JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE_W1 WHERE THIS_WARDROBESINVERSE_W1.GYM_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE_W1.GYM_GYM_ID_OID = THIS.GYM_ID) AND EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE_W2 WHERE THIS_WARDROBESINVERSE_W2.GYM_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE_W2.GYM_GYM_ID_OID = THIS.GYM_ID) AND THIS_WARDROBESINVERSE_W1.MODEL = ? OR THIS_WARDROBESINVERSE_W2.MODEL = ?" : Column not found: THIS_WARDROBESINVERSE_W1.MODEL in statement [SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE_W1 WHERE THIS_WARDROBESINVERSE_W1.GYM_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE_W1.GYM_GYM_ID_OID = THIS.GYM_ID) AND EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE_W2 WHERE THIS_WARDROBESINVERSE_W2.GYM_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE_W2.GYM_GYM_ID_OID = THIS.GYM_ID) AND THIS_WARDROBESINVERSE_W1.MODEL = ? OR THIS_WARDROBESINVERSE_W2.MODEL = ?]. at org.jpox.jdo.JPOXJDOHelper.getJDOExceptionForJPOXException(JPOXJDOHelper.java:289) at org.jpox.jdo.JDOQuery.execute(JDOQuery.java:209) at org.jpox.tests.JDOQLContainerTest.testQueryUsesContainsValueTwiceOnFieldUsingWorkaroundInverse(JDOQLContainerTest.java:4829) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) NestedThrowablesStackTrace: java.sql.SQLException: Column not found: THIS_WARDROBESINVERSE_W1.MODEL in statement [SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE_W1 WHERE THIS_WARDROBESINVERSE_W1.GYM_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE_W1.GYM_GYM_ID_OID = THIS.GYM_ID) AND EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE_W2 WHERE THIS_WARDROBESINVERSE_W2.GYM_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE_W2.GYM_GYM_ID_OID = THIS.GYM_ID) AND THIS_WARDROBESINVERSE_W1.MODEL = ? OR THIS_WARDROBESINVERSE_W2.MODEL = ?] at org.hsqldb.jdbc.Util.throwError(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source) at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source) at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:181) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:283) at org.jpox.store.rdbms.SQLController.getStatementForQuery(SQLController.java:302) at org.jpox.store.rdbms.query.SQLEvaluator.getStatement(SQLEvaluator.java:270) at org.jpox.store.rdbms.query.SQLEvaluator.evaluate(SQLEvaluator.java:95) at org.jpox.store.rdbms.query.JDOQLQuery.performExecute(JDOQLQuery.java:319) at org.jpox.store.query.Query.executeWithMap(Query.java:1267) at org.jpox.store.query.Query.executeWithArray(Query.java:1233) at org.jpox.store.query.Query.execute(Query.java:1154) at org.jpox.jdo.JDOQuery.execute(JDOQuery.java:204) at org.jpox.tests.JDOQLContainerTest.testQueryUsesContainsValueTwiceOnFieldUsingWorkaroundInverse(JDOQLContainerTest.java:4829)
Error testQueryUsesContainsKeyTwiceOnFieldUsingWorkaroundInverse
[JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE2_W1 INNER JOIN WARDROBE UNBOUND_W1 ON THIS_WARDROBESINVERSE2_W1.WARDROBE_ID = UNBOUND_W1.WARDROBE_ID WHERE THIS_WARDROBESINVERSE2_W1.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE2_W1.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID) AND EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE2_W2 INNER JOIN WARDROBE UNBOUND_W2 ON THIS_WARDROBESINVERSE2_W2.WARDROBE_ID = UNBOUND_W2.WARDROBE_ID WHERE THIS_WARDROBESINVERSE2_W2.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE2_W2.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID) AND UNBOUND_W1.MODEL = ? OR UNBOUND_W2.MODEL = ?" : Column not found: UNBOUND_W1.MODEL in statement [SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE2_W1 INNER JOIN WARDROBE UNBOUND_W1 ON THIS_WARDROBESINVERSE2_W1.WARDROBE_ID = UNBOUND_W1.WARDROBE_ID WHERE THIS_WARDROBESINVERSE2_W1.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE2_W1.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID) AND EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE2_W2 INNER JOIN WARDROBE UNBOUND_W2 ON THIS_WARDROBESINVERSE2_W2.WARDROBE_ID = UNBOUND_W2.WARDROBE_ID WHERE THIS_WARDROBESINVERSE2_W2.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE2_W2.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID) AND UNBOUND_W1.MODEL = ? OR UNBOUND_W2.MODEL = ?].
javax.jdo.JDODataStoreException: [JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE2_W1 INNER JOIN WARDROBE UNBOUND_W1 ON THIS_WARDROBESINVERSE2_W1.WARDROBE_ID = UNBOUND_W1.WARDROBE_ID WHERE THIS_WARDROBESINVERSE2_W1.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE2_W1.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID) AND EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE2_W2 INNER JOIN WARDROBE UNBOUND_W2 ON THIS_WARDROBESINVERSE2_W2.WARDROBE_ID = UNBOUND_W2.WARDROBE_ID WHERE THIS_WARDROBESINVERSE2_W2.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE2_W2.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID) AND UNBOUND_W1.MODEL = ? OR UNBOUND_W2.MODEL = ?" : Column not found: UNBOUND_W1.MODEL in statement [SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE2_W1 INNER JOIN WARDROBE UNBOUND_W1 ON THIS_WARDROBESINVERSE2_W1.WARDROBE_ID = UNBOUND_W1.WARDROBE_ID WHERE THIS_WARDROBESINVERSE2_W1.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE2_W1.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID) AND EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE2_W2 INNER JOIN WARDROBE UNBOUND_W2 ON THIS_WARDROBESINVERSE2_W2.WARDROBE_ID = UNBOUND_W2.WARDROBE_ID WHERE THIS_WARDROBESINVERSE2_W2.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE2_W2.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID) AND UNBOUND_W1.MODEL = ? OR UNBOUND_W2.MODEL = ?]. at org.jpox.jdo.JPOXJDOHelper.getJDOExceptionForJPOXException(JPOXJDOHelper.java:289) at org.jpox.jdo.JDOQuery.execute(JDOQuery.java:209) at org.jpox.tests.JDOQLContainerTest.testQueryUsesContainsKeyTwiceOnFieldUsingWorkaroundInverse(JDOQLContainerTest.java:4923) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) NestedThrowablesStackTrace: java.sql.SQLException: Column not found: UNBOUND_W1.MODEL in statement [SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE2_W1 INNER JOIN WARDROBE UNBOUND_W1 ON THIS_WARDROBESINVERSE2_W1.WARDROBE_ID = UNBOUND_W1.WARDROBE_ID WHERE THIS_WARDROBESINVERSE2_W1.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE2_W1.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID) AND EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE2_W2 INNER JOIN WARDROBE UNBOUND_W2 ON THIS_WARDROBESINVERSE2_W2.WARDROBE_ID = UNBOUND_W2.WARDROBE_ID WHERE THIS_WARDROBESINVERSE2_W2.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE2_W2.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID) AND UNBOUND_W1.MODEL = ? OR UNBOUND_W2.MODEL = ?] at org.hsqldb.jdbc.Util.throwError(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source) at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source) at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:181) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:283) at org.jpox.store.rdbms.SQLController.getStatementForQuery(SQLController.java:302) at org.jpox.store.rdbms.query.SQLEvaluator.getStatement(SQLEvaluator.java:270) at org.jpox.store.rdbms.query.SQLEvaluator.evaluate(SQLEvaluator.java:95) at org.jpox.store.rdbms.query.JDOQLQuery.performExecute(JDOQLQuery.java:319) at org.jpox.store.query.Query.executeWithMap(Query.java:1267) at org.jpox.store.query.Query.executeWithArray(Query.java:1233) at org.jpox.store.query.Query.execute(Query.java:1154) at org.jpox.jdo.JDOQuery.execute(JDOQuery.java:204) at org.jpox.tests.JDOQLContainerTest.testQueryUsesContainsKeyTwiceOnFieldUsingWorkaroundInverse(JDOQLContainerTest.java:4923)
Error testQueryUsesContainsKeyTwiceOnFieldUsingWorkaround
[JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM GYM_WARDROBES2 THIS_WARDROBES2_W1 , WARDROBE UNBOUND_W1 WHERE THIS_WARDROBES2_W1.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES2_W1.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W1.WARDROBE_ID = THIS_WARDROBES2_W1.WARDROBE_ID_KID) AND EXISTS (SELECT 1 FROM GYM_WARDROBES2 THIS_WARDROBES2_W2 , WARDROBE UNBOUND_W2 WHERE THIS_WARDROBES2_W2.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES2_W2.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W2.WARDROBE_ID = THIS_WARDROBES2_W2.WARDROBE_ID_KID) AND UNBOUND_W1.MODEL = ? OR UNBOUND_W2.MODEL = ?" : Column not found: UNBOUND_W1.MODEL in statement [SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM GYM_WARDROBES2 THIS_WARDROBES2_W1 , WARDROBE UNBOUND_W1 WHERE THIS_WARDROBES2_W1.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES2_W1.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W1.WARDROBE_ID = THIS_WARDROBES2_W1.WARDROBE_ID_KID) AND EXISTS (SELECT 1 FROM GYM_WARDROBES2 THIS_WARDROBES2_W2 , WARDROBE UNBOUND_W2 WHERE THIS_WARDROBES2_W2.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES2_W2.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W2.WARDROBE_ID = THIS_WARDROBES2_W2.WARDROBE_ID_KID) AND UNBOUND_W1.MODEL = ? OR UNBOUND_W2.MODEL = ?].
javax.jdo.JDODataStoreException: [JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM GYM_WARDROBES2 THIS_WARDROBES2_W1 , WARDROBE UNBOUND_W1 WHERE THIS_WARDROBES2_W1.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES2_W1.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W1.WARDROBE_ID = THIS_WARDROBES2_W1.WARDROBE_ID_KID) AND EXISTS (SELECT 1 FROM GYM_WARDROBES2 THIS_WARDROBES2_W2 , WARDROBE UNBOUND_W2 WHERE THIS_WARDROBES2_W2.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES2_W2.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W2.WARDROBE_ID = THIS_WARDROBES2_W2.WARDROBE_ID_KID) AND UNBOUND_W1.MODEL = ? OR UNBOUND_W2.MODEL = ?" : Column not found: UNBOUND_W1.MODEL in statement [SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM GYM_WARDROBES2 THIS_WARDROBES2_W1 , WARDROBE UNBOUND_W1 WHERE THIS_WARDROBES2_W1.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES2_W1.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W1.WARDROBE_ID = THIS_WARDROBES2_W1.WARDROBE_ID_KID) AND EXISTS (SELECT 1 FROM GYM_WARDROBES2 THIS_WARDROBES2_W2 , WARDROBE UNBOUND_W2 WHERE THIS_WARDROBES2_W2.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES2_W2.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W2.WARDROBE_ID = THIS_WARDROBES2_W2.WARDROBE_ID_KID) AND UNBOUND_W1.MODEL = ? OR UNBOUND_W2.MODEL = ?]. at org.jpox.jdo.JPOXJDOHelper.getJDOExceptionForJPOXException(JPOXJDOHelper.java:289) at org.jpox.jdo.JDOQuery.execute(JDOQuery.java:209) at org.jpox.tests.JDOQLContainerTest.testQueryUsesContainsKeyTwiceOnFieldUsingWorkaround(JDOQLContainerTest.java:5019) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) NestedThrowablesStackTrace: java.sql.SQLException: Column not found: UNBOUND_W1.MODEL in statement [SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM GYM_WARDROBES2 THIS_WARDROBES2_W1 , WARDROBE UNBOUND_W1 WHERE THIS_WARDROBES2_W1.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES2_W1.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W1.WARDROBE_ID = THIS_WARDROBES2_W1.WARDROBE_ID_KID) AND EXISTS (SELECT 1 FROM GYM_WARDROBES2 THIS_WARDROBES2_W2 , WARDROBE UNBOUND_W2 WHERE THIS_WARDROBES2_W2.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES2_W2.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W2.WARDROBE_ID = THIS_WARDROBES2_W2.WARDROBE_ID_KID) AND UNBOUND_W1.MODEL = ? OR UNBOUND_W2.MODEL = ?] at org.hsqldb.jdbc.Util.throwError(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source) at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source) at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:181) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:283) at org.jpox.store.rdbms.SQLController.getStatementForQuery(SQLController.java:302) at org.jpox.store.rdbms.query.SQLEvaluator.getStatement(SQLEvaluator.java:270) at org.jpox.store.rdbms.query.SQLEvaluator.evaluate(SQLEvaluator.java:95) at org.jpox.store.rdbms.query.JDOQLQuery.performExecute(JDOQLQuery.java:319) at org.jpox.store.query.Query.executeWithMap(Query.java:1267) at org.jpox.store.query.Query.executeWithArray(Query.java:1233) at org.jpox.store.query.Query.execute(Query.java:1154) at org.jpox.jdo.JDOQuery.execute(JDOQuery.java:204) at org.jpox.tests.JDOQLContainerTest.testQueryUsesContainsKeyTwiceOnFieldUsingWorkaround(JDOQLContainerTest.java:5019)
Error testQueryUsesContainsTwiceOnFieldNoNamespace
[JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.models.company.Manager' AS JPOXMETADATA,THIS.EMPLOYEE_ID,THIS_1.AGE,THIS_1.EMAIL_ADDRESS,THIS_1.FIRSTNAME,THIS_1.GLOBALNUM,THIS_1.LASTNAME,THIS_1.PERSONNUM,THIS_2.MANAGER_EMPLOYEE_ID_OID,THIS_2.SALARY,THIS_2.SALARY_CURRENCY,THIS_2.SERIAL_NO FROM MANAGER THIS INNER JOIN PERSON THIS_1 ON THIS_1.PERSON_ID = THIS.EMPLOYEE_ID INNER JOIN EMPLOYEE THIS_2 ON THIS_2.EMPLOYEE_ID = THIS.EMPLOYEE_ID WHERE EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP1 INNER JOIN PERSON UNBOUND_EMP1_1 ON UNBOUND_EMP1_1.PERSON_ID = UNBOUND_EMP1.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP1 WHERE THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP1.EMPLOYEE_ID = THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_EID AND UNBOUND_EMP1_1.LASTNAME = ?) AND EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP2 INNER JOIN PERSON UNBOUND_EMP2_1 ON UNBOUND_EMP2_1.PERSON_ID = UNBOUND_EMP2.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP2 WHERE THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP2.EMPLOYEE_ID = THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_EID) AND UNBOUND_EMP2_1.LASTNAME = ?" : Column not found: UNBOUND_EMP2_1.LASTNAME in statement [SELECT 'org.jpox.samples.models.company.Manager' AS JPOXMETADATA,THIS.EMPLOYEE_ID,THIS_1.AGE,THIS_1.EMAIL_ADDRESS,THIS_1.FIRSTNAME,THIS_1.GLOBALNUM,THIS_1.LASTNAME,THIS_1.PERSONNUM,THIS_2.MANAGER_EMPLOYEE_ID_OID,THIS_2.SALARY,THIS_2.SALARY_CURRENCY,THIS_2.SERIAL_NO FROM MANAGER THIS INNER JOIN PERSON THIS_1 ON THIS_1.PERSON_ID = THIS.EMPLOYEE_ID INNER JOIN EMPLOYEE THIS_2 ON THIS_2.EMPLOYEE_ID = THIS.EMPLOYEE_ID WHERE EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP1 INNER JOIN PERSON UNBOUND_EMP1_1 ON UNBOUND_EMP1_1.PERSON_ID = UNBOUND_EMP1.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP1 WHERE THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP1.EMPLOYEE_ID = THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_EID AND UNBOUND_EMP1_1.LASTNAME = ?) AND EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP2 INNER JOIN PERSON UNBOUND_EMP2_1 ON UNBOUND_EMP2_1.PERSON_ID = UNBOUND_EMP2.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP2 WHERE THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP2.EMPLOYEE_ID = THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_EID) AND UNBOUND_EMP2_1.LASTNAME = ?].
javax.jdo.JDODataStoreException: [JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.models.company.Manager' AS JPOXMETADATA,THIS.EMPLOYEE_ID,THIS_1.AGE,THIS_1.EMAIL_ADDRESS,THIS_1.FIRSTNAME,THIS_1.GLOBALNUM,THIS_1.LASTNAME,THIS_1.PERSONNUM,THIS_2.MANAGER_EMPLOYEE_ID_OID,THIS_2.SALARY,THIS_2.SALARY_CURRENCY,THIS_2.SERIAL_NO FROM MANAGER THIS INNER JOIN PERSON THIS_1 ON THIS_1.PERSON_ID = THIS.EMPLOYEE_ID INNER JOIN EMPLOYEE THIS_2 ON THIS_2.EMPLOYEE_ID = THIS.EMPLOYEE_ID WHERE EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP1 INNER JOIN PERSON UNBOUND_EMP1_1 ON UNBOUND_EMP1_1.PERSON_ID = UNBOUND_EMP1.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP1 WHERE THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP1.EMPLOYEE_ID = THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_EID AND UNBOUND_EMP1_1.LASTNAME = ?) AND EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP2 INNER JOIN PERSON UNBOUND_EMP2_1 ON UNBOUND_EMP2_1.PERSON_ID = UNBOUND_EMP2.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP2 WHERE THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP2.EMPLOYEE_ID = THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_EID) AND UNBOUND_EMP2_1.LASTNAME = ?" : Column not found: UNBOUND_EMP2_1.LASTNAME in statement [SELECT 'org.jpox.samples.models.company.Manager' AS JPOXMETADATA,THIS.EMPLOYEE_ID,THIS_1.AGE,THIS_1.EMAIL_ADDRESS,THIS_1.FIRSTNAME,THIS_1.GLOBALNUM,THIS_1.LASTNAME,THIS_1.PERSONNUM,THIS_2.MANAGER_EMPLOYEE_ID_OID,THIS_2.SALARY,THIS_2.SALARY_CURRENCY,THIS_2.SERIAL_NO FROM MANAGER THIS INNER JOIN PERSON THIS_1 ON THIS_1.PERSON_ID = THIS.EMPLOYEE_ID INNER JOIN EMPLOYEE THIS_2 ON THIS_2.EMPLOYEE_ID = THIS.EMPLOYEE_ID WHERE EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP1 INNER JOIN PERSON UNBOUND_EMP1_1 ON UNBOUND_EMP1_1.PERSON_ID = UNBOUND_EMP1.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP1 WHERE THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP1.EMPLOYEE_ID = THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_EID AND UNBOUND_EMP1_1.LASTNAME = ?) AND EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP2 INNER JOIN PERSON UNBOUND_EMP2_1 ON UNBOUND_EMP2_1.PERSON_ID = UNBOUND_EMP2.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP2 WHERE THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP2.EMPLOYEE_ID = THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_EID) AND UNBOUND_EMP2_1.LASTNAME = ?]. at org.jpox.jdo.JPOXJDOHelper.getJDOExceptionForJPOXException(JPOXJDOHelper.java:289) at org.jpox.jdo.JDOQuery.execute(JDOQuery.java:209) at org.jpox.tests.JDOQLContainerTest.testQueryUsesContainsTwiceOnFieldNoNamespace(JDOQLContainerTest.java:5766) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) NestedThrowablesStackTrace: java.sql.SQLException: Column not found: UNBOUND_EMP2_1.LASTNAME in statement [SELECT 'org.jpox.samples.models.company.Manager' AS JPOXMETADATA,THIS.EMPLOYEE_ID,THIS_1.AGE,THIS_1.EMAIL_ADDRESS,THIS_1.FIRSTNAME,THIS_1.GLOBALNUM,THIS_1.LASTNAME,THIS_1.PERSONNUM,THIS_2.MANAGER_EMPLOYEE_ID_OID,THIS_2.SALARY,THIS_2.SALARY_CURRENCY,THIS_2.SERIAL_NO FROM MANAGER THIS INNER JOIN PERSON THIS_1 ON THIS_1.PERSON_ID = THIS.EMPLOYEE_ID INNER JOIN EMPLOYEE THIS_2 ON THIS_2.EMPLOYEE_ID = THIS.EMPLOYEE_ID WHERE EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP1 INNER JOIN PERSON UNBOUND_EMP1_1 ON UNBOUND_EMP1_1.PERSON_ID = UNBOUND_EMP1.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP1 WHERE THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP1.EMPLOYEE_ID = THIS_SUBORDINATES_EMP1.EMPLOYEE_ID_EID AND UNBOUND_EMP1_1.LASTNAME = ?) AND EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP2 INNER JOIN PERSON UNBOUND_EMP2_1 ON UNBOUND_EMP2_1.PERSON_ID = UNBOUND_EMP2.EMPLOYEE_ID , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP2 WHERE THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_OID = THIS.EMPLOYEE_ID AND UNBOUND_EMP2.EMPLOYEE_ID = THIS_SUBORDINATES_EMP2.EMPLOYEE_ID_EID) AND UNBOUND_EMP2_1.LASTNAME = ?] at org.hsqldb.jdbc.Util.throwError(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source) at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source) at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:181) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:283) at org.jpox.store.rdbms.SQLController.getStatementForQuery(SQLController.java:302) at org.jpox.store.rdbms.query.SQLEvaluator.getStatement(SQLEvaluator.java:270) at org.jpox.store.rdbms.query.SQLEvaluator.evaluate(SQLEvaluator.java:95) at org.jpox.store.rdbms.query.JDOQLQuery.performExecute(JDOQLQuery.java:319) at org.jpox.store.query.Query.executeWithMap(Query.java:1267) at org.jpox.store.query.Query.executeWithArray(Query.java:1233) at org.jpox.store.query.Query.execute(Query.java:1154) at org.jpox.jdo.JDOQuery.execute(JDOQuery.java:204) at org.jpox.tests.JDOQLContainerTest.testQueryUsesContainsTwiceOnFieldNoNamespace(JDOQLContainerTest.java:5766)
Failure testOneToOneUniTemporaryStates
Field value of former persistent-new-deleted (now transient) object has been changed expected:<JPOX Corporation> but was:<null>
junit.framework.ComparisonFailure: Field value of former persistent-new-deleted (now transient) object has been changed expected:<JPOX Corporation> but was:<null> at org.jpox.tests.ReachabilityTest.testOneToOneUniTemporaryStates(ReachabilityTest.java:541)
Failure test1to1UnidirInheritanceSubclassTable
Number of readers who read "Daily Mail" newspaper was incorrect expected:<0> but was:<1>
junit.framework.AssertionFailedError: Number of readers who read "Daily Mail" newspaper was incorrect expected:<0> but was:<1> at org.jpox.tests.RelationshipTest.test1to1UnidirInheritanceSubclassTable(RelationshipTest.java:2232)
Error testSetResultCartesianProductMap
implement this
java.lang.RuntimeException: implement this at org.jpox.tests.JDOQLResultTest.testSetResultCartesianProductMap(JDOQLResultTest.java:606)
Failure testSetFK
Exception thrown during create of set of interface objects using FK : [JPOX-056041] Class "org.jpox.samples.interfaces.ShapeHolder3" has collection field "shapeList" and this has no mapping in the table for the index of the element class "org.jpox.samples.interfaces.SquareInverse". Maybe you declared the field as a java.util.Collection and instantiated it as a java.util.List yet omitted the <order> element in the MetaData ?
junit.framework.AssertionFailedError: Exception thrown during create of set of interface objects using FK : [JPOX-056041] Class "org.jpox.samples.interfaces.ShapeHolder3" has collection field "shapeList" and this has no mapping in the table for the index of the element class "org.jpox.samples.interfaces.SquareInverse". Maybe you declared the field as a java.util.Collection and instantiated it as a java.util.List yet omitted the <order> element in the MetaData ? at org.jpox.tests.InterfacesTest.testSetFK(InterfacesTest.java:571)
Error testListFK
[JPOX-056041] Class "org.jpox.samples.interfaces.ShapeHolder3" has collection field "shapeList" and this has no mapping in the table for the index of the element class "org.jpox.samples.interfaces.SquareInverse". Maybe you declared the field as a java.util.Collection and instantiated it as a java.util.List yet omitted the <order> element in the MetaData ?
javax.jdo.JDOUserException: [JPOX-056041] Class "org.jpox.samples.interfaces.ShapeHolder3" has collection field "shapeList" and this has no mapping in the table for the index of the element class "org.jpox.samples.interfaces.SquareInverse". Maybe you declared the field as a java.util.Collection and instantiated it as a java.util.List yet omitted the <order> element in the MetaData ? at org.jpox.jdo.JPOXJDOHelper.getJDOExceptionForJPOXException(JPOXJDOHelper.java:354) at org.jpox.jdo.AbstractPersistenceManager.jdoMakePersistent(AbstractPersistenceManager.java:646) at org.jpox.jdo.AbstractPersistenceManager.makePersistent(AbstractPersistenceManager.java:666) at org.jpox.tests.InterfacesTest.testListFK(InterfacesTest.java:617) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) NestedThrowablesStackTrace: [JPOX-056041] Class "org.jpox.samples.interfaces.ShapeHolder3" has collection field "shapeList" and this has no mapping in the table for the index of the element class "org.jpox.samples.interfaces.SquareInverse". Maybe you declared the field as a java.util.Collection and instantiated it as a java.util.List yet omitted the <order> element in the MetaData ? org.jpox.exceptions.JPOXUserException: [JPOX-056041] Class "org.jpox.samples.interfaces.ShapeHolder3" has collection field "shapeList" and this has no mapping in the table for the index of the element class "org.jpox.samples.interfaces.SquareInverse". Maybe you declared the field as a java.util.Collection and instantiated it as a java.util.List yet omitted the <order> element in the MetaData ? at org.jpox.store.rdbms.scostore.FKListStore.<init>(FKListStore.java:205) at org.jpox.store.rdbms.RDBMSManager.getBackingStoreForCollection(RDBMSManager.java:1117) at org.jpox.store.mapping.CollectionMapping.getBackingStore(CollectionMapping.java:97) at org.jpox.store.mapping.CollectionMapping.postInsert(CollectionMapping.java:236) at org.jpox.store.rdbms.request.InsertRequest.execute(InsertRequest.java:450) at org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2888) at org.jpox.store.MappedStoreManager.insertObject(MappedStoreManager.java:180) at org.jpox.state.JDOStateManagerImpl.internalMakePersistent(JDOStateManagerImpl.java:3108) at org.jpox.state.JDOStateManagerImpl.makePersistent(JDOStateManagerImpl.java:3088) at org.jpox.ObjectManagerImpl.persistObjectInternal(ObjectManagerImpl.java:1166) at org.jpox.ObjectManagerImpl.persistObject(ObjectManagerImpl.java:1017) at org.jpox.jdo.AbstractPersistenceManager.jdoMakePersistent(AbstractPersistenceManager.java:641) at org.jpox.jdo.AbstractPersistenceManager.makePersistent(AbstractPersistenceManager.java:666) at org.jpox.tests.InterfacesTest.testListFK(InterfacesTest.java:617)