| [
summary] [
package list] [
test cases]
| Tests | Errors | Failures | Success rate | Time(s) |
| 665 | 10 | 7 | 97.44% | 100.44 | Note:
failuresare anticipated and checked for with assertions while
errorsare unanticipated. [
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.
[
summary] [
package list] [
test cases]
| testNormalAddCollection | 0.33 |
| testNormalChildAddCollection | 0.06 |
| testNormalRemoveCollection | 0.10 |
| testNormalRetainCollection | 0.07 |
| testNormalChildRemoveCollection | 0.06 |
| testNormalRemoveItem | 0.07 |
| testNormalClearIsEmpty | 0.05 |
| testNormalInheritance | 0.06 |
| testNormalQuery | 0.10 |
| testNormalAttachDetach | 0.13 |
| testInverseAddCollection | 0.07 |
| testInverseRemoveCollection | 0.06 |
| testInverseRetainCollection | 0.06 |
| testInverseAddElement | 0.06 |
| testInverseClearIsEmpty | 0.05 |
| testInverseInheritance | 0.08 |
| testInverseQuery | 0.09 |
| testInverseAttachDetach | 0.12 |
| testSecondaryTable | 0.41 |
| testQuerySecondaryTable | 0.04 |
| testTableColumnNames | 0.58 |
| testColumnSpecifications | 0.02 |
| testUnique | 0.27 |
| testColumnWidth | 0.46 |
| testReadOnlyDatastore | 0.43 |
| testFixedDatastore | 0.43 |
| testClassUsingSQLKeywords | 0.47 |
| testClassWithLongName | 0.33 |
| testClassAsSQLKeyword | 0.00 |
| testTableReuseForDifferentClasses | 0.13 |
| test1To1Bidir | 0.06 |
| testSecondaryTableSchema | 0.03 |
| testInterfaces | 0.18 |
| testObjectFields | 0.05 |
| test1To1UnidirectionalSchema | 0.04 |
| testOverridingColumnsBaseNewTableSubNewTable | 0.29 |
| testOverridingColumnsBaseSubclassTableSubNewTable | 0.02 |
| testOverridingColumnsBaseNewTableSubSuperclassTable | 0.01 |
| testEmbeddedPCSchema | 0.13 |
| testEmbeddedPCCollectionSchema | 0.02 |
| testEmbeddedPCListSchema | 0.01 |
| testEmbeddedPCMapSchema | 0.02 |
| testMtoN | 0.08 |
| testArrayNonPC | 0.29 |
| testArrayPC | 0.02 |
| testSet | 0.23 |
| testList | 0.09 |
| testMap | 0.13 |
| testDefaultedFields | 0.02 |
| testUnmappedColumns | 0.01 |
| testIsNullable | 0.07 |
| testNullsAllowed | 0.03 |
| testMakePersistent | 0.78 |
| testQuery | 0.04 |
| testObjectWithReferenceToPersistentInterface | 0.17 |
| testNewInstance | 0.00 |
| testNewInstance3 | 0.00 |
| testNormalAddCollection | 0.36 |
| testNormalAddItem | 0.10 |
| testNormalChildAddCollection | 0.07 |
| testNormalRemoveCollection | 0.08 |
| testNormalRetainCollection | 0.08 |
| testNormalChildRemoveCollection | 0.06 |
| testNormalRemoveItem | 0.07 |
| testNormalRemoveAt | 0.06 |
| testNormalGetItem | 0.06 |
| testNormalClearIsEmpty | 0.05 |
| testNormalInheritance | 0.07 |
| testNormalQuery | 0.10 |
| testNormalAttachDetach | 0.15 |
| testInverseAddCollection | 0.06 |
| testInverseRemoveCollection | 0.06 |
| testInverseRetainCollection | 0.06 |
| testInverseRemoveItem | 0.06 |
| testInverseRemoveAt | 0.06 |
| testInverseGetItem | 0.05 |
| testInverseClearIsEmpty | 0.04 |
| testInverseInheritance | 0.06 |
| testInverseQuery | 0.08 |
| testInverseAttachDetach | 0.15 |
| testNormalAddCollection | 0.36 |
| testNormalChildAddCollection | 0.07 |
| testNormalRemoveCollection | 0.10 |
| testNormalRetainCollection | 0.11 |
| testNormalChildRemovalCollection | 0.06 |
| testNormalRemoveItem | 0.06 |
| testNormalRemoveAt | 0.06 |
| testNormalGetItem | 0.05 |
| testNormalContains | 0.08 |
| testNormalClearIsEmpty | 0.05 |
| testNormalInheritance | 0.06 |
| testNormalQuery | 0.13 |
| testNormalAttachDetach | 0.14 |
| testInverseAddCollection | 0.07 |
| testInverseRemoveCollection | 0.07 |
| testInverseRetainCollection | 0.06 |
| testInverseRemoveItem | 0.06 |
| testInverseGetItem | 0.06 |
| testInverseClearIsEmpty | 0.05 |
| testInverseInheritance | 0.06 |
| testInverseQuery | 0.08 |
| testInverseAttachDetach | 0.18 |
| testInvalidOperator | 0.11 |
| testDeclareImports | 0.08 |
| testCandidateCollection | 0.37 |
| testQueryUsesInnerJoin | 0.34 |
| testQueryReturnSameObject | 0.10 |
| testStringIndexOf | 0.10 |
| testStaticFields | 0.12 |
| testStringStartsWith | 0.10 |
| testStringEndsWith | 0.08 |
| testStringSubstring | 0.03 |
| testStringTranslate | 0.00 |
| testStringToLowerCase | 0.16 |
| testStringToUpperCase | 0.05 |
| testStringMatches | 0.12 |
| testArrayContains | 0.17 |
| testArrayLength | 0.05 |
| testArrayParameter | 0.06 |
| testMathAbs | 0.07 |
| testMathSqrt | 0.09 |
| 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)].
|
| testDateTimeMethods | 0.05 |
| testPCLiteralOnQueryCompile | 0.10 |
| testJDOHelperGetObjectID1 | 0.45 |
| testJDOHelperGetObjectID2 | 0.10 |
| testAnalysisRollup | 0.00 |
| testSingleString | 0.05 |
| testSingleStringKeywordAsFieldName | 0.00 |
| testSingleStringParameters | 0.11 |
| testNamedQueries | 0.10 |
| testNonstandardCharacters | 0.07 |
| testInstanceof | 0.23 |
| testSingleQuotes | 0.09 |
| testCharLiteralInvalidComparison | 0.09 |
| testEscapeSingleQuoteInString | 0.05 |
| testEq_Neq_UnboundVariables | 0.08 |
expected:<2> but was:<0>
|
| testQueryUnboundVariables | 0.10 |
| testQueryUnboundVariablesInheritance1 | 0.20 |
| testQueryUnboundVariablesInheritance2 | 0.14 |
| testQueryUnboundVariablesInheritanceRightHandDeclared1 | 0.15 |
| testQueryUnboundVariablesInheritanceRightHandDeclared2 | 0.04 |
| testConcatStringAndNumbers | 0.09 |
| testNullEqualsNull | 0.04 |
| testUseOfParentheses | 0.04 |
| testQueryCheckValueDiffFields | 0.07 |
| testCast | 0.15 |
| testKeepResultsQueryAfterQueryClose | 0.01 |
| testKeepResultsQueryAfterTxClose | 0.01 |
| testKeepResultsQueryAfterPMClose | 0.00 |
| testQueryWithNonNullFieldCondition | 0.12 |
| testBoolean | 0.07 |
| testQueryWithDetachedObjects | 0.11 |
| testModuloOperator | 0.03 |
| testInheritanceCastWithDiscriminator | 0.57 |
| 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
|
| testDeleteByQuery | 0.02 |
| testClose | 0.05 |
| testMultipleActiveQueryCandidateCollection | 1.80 |
| testMultipleActiveQueryMapGet | 1.39 |
| testNormalAddCollection | 0.40 |
| testNormalChildAddCollection | 0.08 |
| testNormalRemoveCollection | 0.11 |
| testNormalRetainCollection | 0.09 |
| testNormalChildRemoveCollection | 0.06 |
| testNormalRemoveItem | 0.08 |
| testNormalClearIsEmpty | 0.06 |
| testNormalInheritance | 0.06 |
| testNormalQuery | 0.11 |
| testNormalAttachDetach | 0.15 |
| testInverseAddCollection | 0.08 |
| testInverseRemoveCollection | 0.07 |
| testInverseRetainCollection | 0.07 |
| testInverseAddElement | 0.06 |
| testInverseClearIsEmpty | 0.05 |
| testInverseInheritance | 0.09 |
| testInverseQuery | 0.09 |
| testInverseAttachDetach | 0.14 |
| testNotContainsValuesInMapFields | 0.72 |
| testNotContainsValuesInMapFieldsInverse | 0.10 |
| testNotContainsKeysInMapFields | 0.32 |
| testNotContainsKeysInMapFieldsInverse | 0.25 |
| testNotContainsEntryInMapFields | 0.23 |
| testNotContainsEntryInMapFieldsInverse | 0.26 |
| testGetInMapFields | 0.20 |
| testGetInOrderingInMapFields | 0.18 |
expected:<2> but was:<3>
|
| testNegateContains | 0.34 |
| testContainsInListFields | 0.04 |
| testContainsInSetFields | 0.08 |
| testContainsInMapFields | 0.26 |
| testContainsInParameterCollection | 0.24 |
| testContainsInParameterArray | 0.32 |
| 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"".
|
| testContainsResultVariable | 0.18 |
| testContainsResultVariableNestedContains | 0.20 |
| testContainsInParameterCollectionOfPCleanInstances | 0.15 |
| testContainsInImplicitParameterCollection | 0.15 |
| testContainsInImplicitParameterCollectionOfPCleanInstances | 0.14 |
| testMapGetMethod | 0.16 |
| testMapGetAsLiteralWithKeyAsExpression | 0.14 |
Cannot perform operation "getMethod" on MapKeyLiteral "('2 doors')" and StringExpression "THIS.MODEL"
|
| testCollectionSize | 0.09 |
| testCollectionIsEmpty | 0.10 |
| testMapSize | 0.15 |
| testMapIsEmpty | 0.12 |
| testQueryUsesContainsOnceOnOneUnboundVariable | 0.17 |
| testQueryUsesContainsOnceAndEqualsOnOneUnboundVariable | 0.13 |
| testQueryUsesContainsValueOnceOnOneUnboundVariable | 0.24 |
| testQueryUsesContainsValueAndEqualsOnceOnOneUnboundVariable | 0.16 |
| testQueryUsesContainsValueOnceOnOneUnboundVariableInverse | 0.24 |
| testQueryContainsKeyOnCharacter | 0.05 |
| testQueryUsesContainsKeyOnceOnOneUnboundVariableInverse | 0.22 |
| testQueryUsesContainsKeyOnceOnOneUnboundVariable | 0.28 |
| testQueryUsesContainsOnceOnOneUnboundVariableUsingParameters | 0.15 |
| testQueryUsesContainsValueOnceOnOneUnboundVariableUsingParameters | 0.17 |
| testQueryUsesContainsValueOnceOnOneUnboundVariableUsingParametersInverse | 0.17 |
| testQueryUsesContainsKeyOnceOnOneUnboundVariableUsingParametersInverse | 0.16 |
| testQueryUsesContainsKeyOnceOnOneUnboundVariableUsingParameters | 0.15 |
| testQueryUsesContainsOnceOnOneUnboundVariableImplicitVariables | 0.17 |
| testQueryUsesContainsValueOnceOnOneUnboundVariableImplicitVariables | 0.17 |
| testQueryUsesContainsValueOnceOnOneUnboundVariableImplicitVariablesInverse | 0.19 |
| testQueryUsesContainsKeyOnceOnOneUnboundVariableImplicitVariablesInverse | 0.16 |
| testQueryUsesContainsKeyOnceOnOneUnboundVariableImplicitVariables | 0.16 |
| testQueryUsesContainsOnceOnOneUnboundVariableInverse | 0.15 |
| testQueryUsesContainsOnceOnOneUnboundVariableInverseImplicitVariables | 0.15 |
| testQueryUsesContainsOnceOnOneUnboundVariableInverseUsingParameter | 0.17 |
| testQueryUsesContainsOnceOnOneUnboundVariableMtoN | 0.07 |
| testQueryUsesContainsTwiceOnOneUnboundVariable | 0.13 |
| testQueryUsesContainsValueTwiceOnOneUnboundVariable | 0.17 |
| testQueryUsesContainsValueTwiceOnOneUnboundVariableInverse | 0.19 |
| testQueryUsesContainsKeyTwiceOnOneUnboundVariableInverse | 0.17 |
| testQueryUsesContainsKeyTwiceOnOneUnboundVariable | 0.15 |
| testQueryUsesContainsTwiceOnOneUnboundVariableInverse | 0.15 |
| testQueryUsesContainsTwiceOnOneUnboundVariableMtoN | 0.07 |
| 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 = ?].
|
| 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 = ?].
|
| 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 = ?].
|
| 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 = ?].
|
| 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 = ?].
|
| testQueryUsesContainsTwiceOnFieldWithNamespace | 0.12 |
| testQueryUsesContainsValueTwiceOnFieldWithNamespace | 0.16 |
| testQueryUsesContainsValueTwiceOnFieldWithNamespaceInverse | 0.18 |
| testQueryUsesContainsKeyTwiceOnFieldWithNamespaceInverse | 0.16 |
| testQueryUsesContainsKeyTwiceOnFieldWithNamespace | 0.16 |
| testQueryUsesContainsTwiceOnFieldWithNamespaceInverse | 0.18 |
| testQueryUsesContainsTwiceOnFieldWithNamespaceMtoN | 0.08 |
| testQueryUsesContainsTwiceOnFieldWithNamespace2MtoN | 0.06 |
| 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 = ?].
|
| testIsEmptyOredWithContains | 0.03 |
| testContainsResultVariableNestedContains2 | 0.10 |
| testNormalPutItems | 0.42 |
| testNormalRemoveItem | 0.19 |
| testNormalEntrySet | 0.10 |
| testNormalKeySet | 0.09 |
| testNormalValues | 0.11 |
| testNormalNonPrimitiveKeyEntrySet | 0.13 |
| testNormalNonPrimitiveSameKeyValueInstances | 0.94 |
| testNormalNonPrimitiveKeyKeySet | 0.15 |
| testNormalNonPrimitiveKeyQuery | 0.15 |
| testNormalNonPrimitiveKeyValues | 0.10 |
| testNormalClearIsEmpty | 0.07 |
| testNormalInheritance | 0.08 |
| testNormalQueries | 0.06 |
| testNormalQueriesPrimitive | 0.07 |
| testNormalAttachDetach | 0.18 |
| testInversePutItems | 0.11 |
| testInverseRemoveItem | 0.08 |
| testInverseEntrySet | 0.08 |
| testInverseKeySet | 0.09 |
| testInverseValues | 0.09 |
| testInverseNonPrimitiveKeyEntrySet | 0.11 |
| testInverseNonPrimitiveKeyKeySet | 0.10 |
| testInverseNonPrimitiveKeyValues | 0.14 |
| testInverseClearIsEmpty | 0.08 |
| testInverseInheritance | 0.09 |
| testInverseQueries | 0.11 |
| testInverseAttachDetach | 0.20 |
| testTablePoidMultiThreadedNewPM | 1.72 |
| testTableGenerator | 0.03 |
| testAUIDGenerator | 5.05 |
| testUUIDStringGenerator | 0.04 |
| testUUIDHexGenerator | 0.03 |
| testMaxGenerator | 0.02 |
| testSequenceGenerator | 0.05 |
| testIdentityGenerator | 0.04 |
| testAutoIncrementWithNoOtherFields | 0.01 |
| testAutoIncrementWithInheritance | 0.10 |
| testMixedGeneratorInherited | 0.04 |
| testBasicVersionNumberStrategy | 0.30 |
| testBasicDateTimeStrategy | 0.03 |
| testBasicNoneStrategy | 0.05 |
| testBasicVersionNumberStrategyVersionField | 0.03 |
| testCreationUpdateVersionColumns | 0.07 |
| testDeleteAfterUpdate | 0.02 |
| testMultipleUpdates | 0.02 |
| testConflictTransactionsVersionNumberFromQuery | 0.03 |
| testOptimisticQuery | 0.02 |
| testPCnewToPCdirty | 0.03 |
| testDetachAttach | 0.03 |
| testRefreshOfOptimisticObjects | 0.02 |
| testOptimisticJoinTableRelation | 0.08 |
| testSCOContainerClear | 0.03 |
| testOptimisticRollingBack | 0.00 |
| testRetrieveAfterPersistBeforeFlush | 0.01 |
| testInheritance | 0.07 |
| testInheritanceUsingQuery | 0.03 |
| testDetachAllOnCommitVersionNumber | 0.02 |
| testDetachCopyVersionNumber | 0.02 |
| testOptimisticWithIdentityFieldObjects | 0.12 |
| testNullQuery | 0.04 |
| testInvalidQuery | 0.00 |
| testSelectStarQuery | 0.50 |
| testWithCandidateClassWithoutResultClass | 0.12 |
| testWithCandidateClassWithResultClass | 0.11 |
| testWithoutCandidateClassWithoutResultClass | 0.02 |
| testWithoutCandidateClassWithResultClass | 0.07 |
| testWithoutCandidatesClassWithParameters | 0.02 |
| testWithoutCandidatesWithParametersInMap | 0.02 |
| testNamedQueries | 0.03 |
| testNamedQueriesDescoped | 0.02 |
| testQueryWithTimeout | 0.00 |
| testQueryFromJdoqueryFile | 0.03 |
| testInvalidQueryAllowedByConfiguration | 0.12 |
| testWithoutCandidatesClassWithParametersMultipleExecution | 0.32 |
| testNumberedParameters | 0.18 |
| testNamedParameters | 0.04 |
| testTimestampQueryOnOracle | 0.00 |
| testSQLUpdateStatement | 0.33 |
| testClassWithoutFields | 0.51 |
| testClassWithOnlyContainerFields | 0.89 |
| testClassWithOnlyContainerFieldsInFetchPlan | 0.29 |
| testPersistenceOfFKListFKListStructures | 0.33 |
| testPersistenceOfFKSetFKListStructures | 0.20 |
| test1toNInheritance | 0.08 |
| testJoinAddCollection | 0.30 |
| testJoinRemoveCollection | 0.04 |
| testJoinRetainCollection | 0.04 |
| testJoinClearIsEmpty | 0.04 |
| testJoinAttachDetach | 0.09 |
| testFKAddCollection | 0.08 |
| testFKRemoveCollection | 0.06 |
| testFKRetainCollection | 0.06 |
| testFKClearIsEmpty | 0.06 |
| testFKAttachDetach | 0.14 |
| testNormalPutItems | 0.39 |
| testNormalRemoveItem | 0.12 |
| testNormalEntrySet | 0.12 |
| testNormalKeySet | 0.08 |
| testNormalValues | 0.08 |
| testNormalClearIsEmpty | 0.07 |
| testNormalInheritance | 0.08 |
| testNormalQueries | 0.10 |
| testNormalQueriesPrimitive | 0.06 |
| testNormalAttachDetach | 0.23 |
| testInversePutItems | 0.10 |
| testInverseRemoveItem | 0.09 |
| testInverseEntrySet | 0.09 |
| testInverseKeySet | 0.10 |
| testInverseValues | 0.09 |
| testInverseClearIsEmpty | 0.10 |
| testInverseInheritance | 0.08 |
| testInverseQueries | 0.09 |
| testInverseAttachDetach | 0.19 |
| testNormalPersistByCollection | 0.35 |
| testNormalChildAddCollection | 0.07 |
| testNormalRemoveCollection | 0.10 |
| testNormalRetainCollection | 0.07 |
| testNormalChildRemoveCollection | 0.06 |
| testNormalRemoveItem | 0.07 |
| testNormalClearIsEmpty | 0.04 |
| testNormalContains | 0.07 |
| testNormalInheritance | 0.05 |
| testNormalQuery | 0.13 |
| testNormalAttachDetach | 0.14 |
| testInverseAddCollection | 0.07 |
| testInverseRemoveCollection | 0.06 |
| testInverseRetainCollection | 0.06 |
| testInverseAddElement | 0.06 |
| testInverseClearIsEmpty | 0.06 |
| testInverseInheritance | 0.07 |
| testInverseQuery | 0.08 |
| testInverseAttachDetach | 0.12 |
| testInversePersistByCollectionDFG | 0.08 |
| testInversePersistByElementDFG | 0.03 |
| testPersistCascadeFalse | 0.23 |
| testOneToOneUniClassPessimistic | 0.11 |
| testOneToOneUniClassOptimistic | 0.07 |
| testOneToOneUniInterfacePessimistic | 0.34 |
| testOneToOneUniInterfaceOptimistic | 0.03 |
| testOneToOneUniClassTemporaryPessimistic | 0.04 |
| testOneToOneUniClassTemporaryOptimistic | 0.03 |
| testOneToOneUniTemporaryStates | 0.03 |
Field value of former persistent-new-deleted (now transient) object has been changed expected:<JPOX Corporation> but was:<null>
|
| testOneToOneUniClassNewDeleted | 2.83 |
| testOneToOneBiClassNewDeleted | 2.48 |
| testDeepReachabilityByClass | 0.37 |
| testNewObjectUnreachableWithDirtyObjectOwner | 0.21 |
| testBaseOnQuery | 0.06 |
| testIncorrectAssignment | 0.03 |
| testMapWithKeyAsFieldInValue | 1.02 |
| testMapWithValueAsFieldInKey | 0.16 |
| testSimpleDatastoreID | 0.63 |
| test1to1Unidir | 0.20 |
| test1to1Bidir | 0.16 |
| test1to1BidirQuery | 0.14 |
| test1to1BidirInheritance | 0.29 |
| test1toNBidirJoin | 0.32 |
| test1toNUnidirJoinSubclassTable | 0.33 |
| testMtoN | 0.17 |
| testMtoNInheritance | 0.19 |
| test1toNInheritance | 0.08 |
| testQueryWithInheritanceAndOrdering | 0.06 |
| test1to1UnidirInheritanceSubclassTable | 0.12 |
Number of readers who read "Daily Mail" newspaper was incorrect expected:<0> but was:<1>
|
| test1to1BidirInheritanceSuperclassTable | 0.08 |
| test1toNBidir_1to1Unidir | 0.12 |
| test1toNunidirFK | 0.06 |
| test1toNUnidirFKToSelf | 0.09 |
| test1toNUnidirFKList | 0.06 |
| test1toNUnidirFKListToSelf | 0.10 |
| test1toNUnidirFKMap | 0.12 |
| test1toNUnidirFKMapToSelf | 0.14 |
| test1toNBidirFK | 0.03 |
| test1toNMap | 0.17 |
| test1toNUnidirFKSetInheritanceTarget | 0.05 |
| test1toNUnidirFKListInheritanceTarget | 0.06 |
| test1toNUnidirSetSharedJoin | 0.05 |
| test1toNUnidirSetSharedFK | 0.05 |
| test1toNUnidirListSharedJoin | 0.06 |
| test1toNUnidirListSharedFK | 0.07 |
| test1toNUnidirOrderedList | 0.06 |
| testDoublyLinkedList | 0.09 |
| testSinglyLinkedList | 0.05 |
| testParentChildLinkRelation | 0.04 |
| test1toNListFKUsingOrderMappedBy | 0.07 |
| testNormalAddCollection | 0.35 |
| testNormalRemoveCollection | 0.10 |
| testNormalRetainCollection | 0.11 |
| testNormalRemoveItem | 0.08 |
| testNormalRemoveAt | 0.06 |
| testNormalGetItem | 0.05 |
| testNormalClearIsEmpty | 0.04 |
| testNormalInheritance | 0.05 |
| testNormalQuery | 0.10 |
| testNormalAttachDetach | 0.16 |
| testInverseAddCollection | 0.06 |
| testInverseRemoveCollection | 0.06 |
| testInverseRetainCollection | 0.06 |
| testInverseRemoveItem | 0.06 |
| testInverseGetItem | 0.06 |
| testInverseClearIsEmpty | 0.04 |
| testInverseInheritance | 0.06 |
| testInverseQuery | 0.08 |
| testInverseAttachDetach | 0.11 |
| testNormalAddCollection | 0.37 |
| testNormalRemoveCollection | 0.10 |
| testNormalRetainCollection | 0.11 |
| testNormalRemoveItem | 0.08 |
| testNormalRemoveAt | 0.06 |
| testNormalGetItem | 0.06 |
| testNormalClearIsEmpty | 0.05 |
| testNormalInheritance | 0.06 |
| testNormalQuery | 0.11 |
| testNormalAttachDetach | 0.16 |
| testInverseAddCollection | 0.06 |
| testInverseRemoveCollection | 0.06 |
| testInverseRetainCollection | 0.07 |
| testInverseRemoveItem | 0.06 |
| testInverseGetItem | 0.06 |
| testInverseClearIsEmpty | 0.04 |
| testInverseInheritance | 0.05 |
| testInverseQuery | 0.08 |
| testInverselAttachDetach | 0.11 |
| testMakePersistent | 0.79 |
| testQuery | 0.04 |
| testFreshPMF | 0.37 |
| testObjectWithReferenceToPersistentInterface | 0.13 |
| testNewInstancePCClass | 0.00 |
| testNewInstance | 0.00 |
| testNewInstance3 | 0.00 |
| testNormalAddCollection | 0.36 |
| testNormalRemoveCollection | 0.10 |
| testNormalRetainCollection | 0.11 |
| testNormalRemoveItem | 0.08 |
| testNormalRemoveAt | 0.06 |
| testNormalGetItem | 0.05 |
| testNormalClearIsEmpty | 0.04 |
| testNormalInheritance | 0.06 |
| testNormalQuery | 0.10 |
| testNormalAttachDetach | 0.16 |
| testInverseAddCollection | 0.06 |
| testInverseRemoveCollection | 0.06 |
| testInverseRetainCollection | 0.06 |
| testInverseRemoveItem | 0.06 |
| testInverseGetItem | 0.06 |
| testInverseClearIsEmpty | 0.04 |
| testInverseInheritance | 0.05 |
| testInverseQuery | 0.08 |
| testInverseAttachDetach | 0.11 |
| testRangeAndUnique | 0.36 |
| testUniqueResultAggregates | 0.08 |
| testSetResultCartesianProduct1 | 0.70 |
| testSetResultCartesianProduct2 | 0.10 |
| testSetResultCartesianProductCollection | 0.28 |
| testSetResultCartesianProductMap | 0.01 |
implement this
|
| testSetResultCartesianProductContains1 | 0.24 |
| testSetResultCartesianProductContains2 | 0.21 |
| testSetResultCartesianProduct1to1 | 0.23 |
| testSetResultCartesianProductContainsVariableNoNavigation | 0.08 |
| testOrdering | 0.11 |
| testOrderingUsingCollectionExpression | 0.18 |
| testSetResultDistinct | 0.04 |
| testSetResult | 0.03 |
| testCandidateCollection | 0.04 |
| testCandidateCollectionWithResultNotSameTypeAsCandidates | 0.02 |
| testSetIllegalAttributeInResult | 0.02 |
| testSetResultParameter | 0.08 |
| testResultSetMetaData | 0.06 |
| testSetResultWithAggregationWithoutSubclasses | 0.04 |
| testSetResultWithAggregationWithSubclasses | 0.02 |
| testSetResultWithAggregation1 | 0.04 |
| testSetResultWithAggregation2 | 0.03 |
| testSetResultWithAggregationAndNonAggregateExpression | 0.04 |
| testSetResultWithAggregationAndNonAggregateExpression2 | 0.01 |
| testResultSetInsensitive | 0.05 |
| testCountOnClassHierarchy | 0.03 |
| testNewObjectInResult | 0.05 |
| testSetResultClass | 0.04 |
| testNormalPutItems | 0.39 |
| testNormalRemoveItem | 0.11 |
| testNormalEntrySet | 0.12 |
| testNormalKeySet | 0.08 |
| testNormalValues | 0.08 |
| testNormalClearIsEmpty | 0.08 |
| testNormalInheritance | 0.08 |
| testNormalQueries | 0.10 |
| testNormalQueriesPrimitive | 0.06 |
| testNormalAttachDetach | 0.24 |
| testInversePutItems | 0.10 |
| testInverseRemoveItem | 0.09 |
| testInverseEntrySet | 0.09 |
| testInverseKeySet | 0.10 |
| testInverseValues | 0.09 |
| testInverseClearIsEmpty | 0.10 |
| testInverseInheritance | 0.09 |
| testInverseQueries | 0.09 |
| testInverseAttachDetach | 0.20 |
| testDependentFieldsDeletion | 0.83 |
| testDependentFieldsInverseSetsDeletion | 0.27 |
| testDependentFieldsInverseListsDeletion | 0.27 |
| testDependentFieldsInverseMapsDeletion | 0.31 |
| testDependentFieldsInverseMapsValuesDeletion | 0.27 |
| testDependentFieldsInverseMapsKeysDeletion | 0.26 |
| testDependentElementsRemovalUsingJoinTable | 0.28 |
| testDependentElementsRemovalUsingForeignKey | 0.28 |
| testDependentKeysRemovalUsingJoinTable | 0.23 |
| testDependentKeysRemovalUsingForeignKey | 0.24 |
| testBidirectionalDependentFields | 0.28 |
| testInterfaceDependentFields | 0.35 |
| testNullify1to1Relation | 0.16 |
| testRemoveDependentFieldOnDetached | 0.16 |
| testCreationSimple | 0.40 |
| testRetrievalSimple | 0.14 |
| testQuerySimple | 0.11 |
| testDeletionSimple | 0.15 |
| testJoinTableSetCreationSimple | 0.05 |
| testJoinTableSetRetrievalSimple | 0.06 |
| testJoinTableListCreationSimple | 0.04 |
| testJoinTableListRetrievalSimple | 0.05 |
| testAbstractWithCollection | 0.43 |
| testNormalPutItems | 0.42 |
| testNormalRemoveItem | 0.12 |
| testNormalEntrySet | 0.13 |
| testNormalKeySet | 0.08 |
| testNormalValues | 0.08 |
| testNormalClearIsEmpty | 0.08 |
| testNormalInheritance | 0.08 |
| testNormalQueries | 0.10 |
| testNormalQueriesPrimitive | 0.06 |
| testNormalAttachDetach | 0.24 |
| testInversePutItems | 0.10 |
| testInverseRemoveItem | 0.09 |
| testInverseEntrySet | 0.09 |
| testInverseKeySet | 0.09 |
| testInverseValues | 0.10 |
| testInverseClearIsEmpty | 0.10 |
| testInverseInheritance | 0.08 |
| testInverseQueries | 0.09 |
| testInverseAttachDetach | 0.20 |
| testCreation | 0.89 |
| testReadAllShapeHolders | 0.18 |
| testChangeImplementation | 0.11 |
| testNullValues | 0.02 |
| testInsertThenDelete | 0.03 |
| testSetJoin | 0.05 |
| testListJoin | 0.09 |
| 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 ?
|
| 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 ?
|
| testMultipleImplementations | 0.05 |
| testMultipleImplWithMissingColumns | 0.05 |
| testQueryOnInterfaceFields | 0.45 |
| testQueryOnInterfaceFieldsBooleanOps | 0.42 |
| testCorrectCastOnInterfaceField | 0.36 |
| testAccessToFieldsInInterfaces | 0.36 |
| testQueryForNullShape | 0.34 |
| testQueryForNonNullShape | 0.33 |
| testQueue1 | 0.60 |
| testCollectionNonPCUsingJoinTable | 0.35 |
| testCollectionNonPCWithoutJoinTable | 0.10 |
| testCollectionNonPCSerialised | 0.05 |
| testNormalAddCollection | 0.35 |
| testNormalChildAddCollection | 0.07 |
| testNormalRemoveCollection | 0.10 |
| testNormalRetainCollection | 0.07 |
| testNormalChildRemoveCollection | 0.05 |
| testNormalRemoveItem | 0.07 |
| testNormalClearIsEmpty | 0.05 |
| testNormalInheritance | 0.05 |
| testNormalQuery | 0.10 |
| testNormalAttachDetach | 0.13 |
| testInverseAddCollection | 0.07 |
| testInverseRemoveCollection | 0.06 |
| testInverseRetainCollection | 0.06 |
| testInverseAddElement | 0.07 |
| testInverseClearIsEmpty | 0.05 |
| testInverseInheritance | 0.07 |
| testInverseQuery | 0.09 |
| testInverseAttachDetach | 0.12 |
| testOneToOneRelation | 0.80 |
| testOneToManyRelationWithJoinTable | 0.04 |
| testSubclassTable | 0.30 |
| testSubclassTableNewTable | 0.07 |
| testInheritanceWithNoTable | 0.01 |
| testNewTableSuperclassTableValueMap | 0.09 |
| testNewTableSuperclassTableClassName | 0.08 |
| testNewTableNewTable | 0.08 |
| testNewTableExtentResults | 0.07 |
| testNewTableSubclassTableNewTable | 0.08 |
| testSuperclassTable1toNJoinTableRelationship | 0.04 |
| testSuperclassTable1toNFKRelationship | 0.05 |
| testInverseCollectionWithElementUsingSuperclassTable | 0.19 |
| testNewTableOverrideFields | 0.03 |
| testSuperclassTableValueMapInteger | 0.02 |
| testNormalAddCollection | 0.34 |
| testNormalChildAddCollection | 0.06 |
| testNormalRemoveCollection | 0.10 |
| testNormalRetainCollection | 0.07 |
| testNormalChildRemoveCollection | 0.06 |
| testNormalRemoveItem | 0.07 |
| testNormalClearIsEmpty | 0.05 |
| testNormalInheritance | 0.06 |
| testNormalQuery | 0.11 |
| testNormalAttachDetach | 0.14 |
| testInverseAddCollection | 0.08 |
| testInverseRemoveCollection | 0.06 |
| testInverseRetainCollection | 0.07 |
| testInverseAddElement | 0.06 |
| testInverseClearIsEmpty | 0.05 |
| testInverseInheritance | 0.08 |
| testInverseQuery | 0.09 |
| testInverseAttachDetach | 0.12 |
| testNormalPutItems | 0.34 |
| testNormalRemoveItem | 0.04 |
| testNormalEntrySet | 0.04 |
| testNormalKeySet | 0.03 |
| testNormalValues | 0.04 |
| testNormalClearIsEmpty | 0.04 |
| testNormalAttachDetach | 0.08 |
|
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)
|
|
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)
|
|
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)
|
|
testGetInOrderingInMapFields
|
expected:<2> but was:<3>
|
junit.framework.AssertionFailedError: expected:<2> but was:<3> at org.jpox.tests.JDOQLContainerTest.testGetInOrderingInMapFields(JDOQLContainerTest.java:735)
|
|
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)
|
|
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)
|
|
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)
|
|
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)
|
|
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)
|
|
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)
|
|
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)
|
|
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)
|
|
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)
|
|
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)
|
|
testSetResultCartesianProductMap
|
implement this
|
java.lang.RuntimeException: implement this at org.jpox.tests.JDOQLResultTest.testSetResultCartesianProductMap(JDOQLResultTest.java:606)
|
|
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)
|
|
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)
|
|