JPOX
JPOX
 Project  |  Ver 1.1  |  Ver 1.2  |  JDO  |  JPA  |  Guides  |  Tools
1.1 | Preparation | O/R Mapping | Runtime | Extensions | Developer
Development
Testing
Summary

[ summary] [ package list] [ test cases]

TestsErrorsFailuresSuccess rateTime(s)
664151096.23%118.28

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

Package List

[ summary] [ package list] [ test cases]

PackageTestsErrorsFailuresSuccess RateTime
org.jpox.sco 31200100.00%33.06
org.jpox.persistence 352151092.90%85.23

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

org.jpox.sco
ClassTestsErrorsFailuresSuccess RateTime
Success CollectionTest 1800100.00%2.185
Success HashSetTest 1800100.00%1.799
Success LinkedHashMapTest 1900100.00%2.379
Success LinkedListTest 1900100.00%1.890
Success LinkedHashSetTest 1800100.00%1.669
Success ListTest 2200100.00%1.963
Success ArrayListTest 2300100.00%2.016
Success StackTest 1900100.00%1.742
Success QueueTest 100100.00%0.252
Success VectorTest 1900100.00%1.751
Success MapTest 2700100.00%5.932
Success SetTest 1900100.00%1.667
Success PropertiesTest 700100.00%1.007
Success TreeSetTest 1800100.00%1.511
Success SCOUtilsTest 1700100.00%0.088
Success HashtableTest 1900100.00%2.177
Success HashMapTest 1900100.00%2.152
Success CollectionSerialTest 1000100.00%0.879
org.jpox.persistence
ClassTestsErrorsFailuresSuccess RateTime
Success OptimisticTest 1500100.00%1.086
Failure ReachabilityTest 180288.89%2.103
Error BasicQueryTest 103070.00%11.247
Failure IdGeneratorTest 110190.91%5.685
Success InheritanceStrategyTest 1200100.00%1.304
Success PrimitiveCollectionTest 300100.00%0.365
Success DatastoreSchemaTest 3300100.00%11.461
Success DatastoreIdTest 100100.00%0.520
Success PersistenceModelsTest 500100.00%1.216
Success InterfaceQueryTest 400100.00%0.885
Success SecondaryTableTest 200100.00%0.267
Success StateTransitionsTest 100100.00%0.456
Success SQLQueryTest 1600100.00%5.425
Success MapForeignKeyTest 200100.00%0.392
Success AbstractFCOTest 1000100.00%1.022
Error JDOQLContainerTest 729186.11%11.311
Failure RelationshipTest 320293.75%4.177
Error InterfaceFCOTest 121183.33%0.951
Error JDOQLResultTest 241191.67%2.787
Error JDOQLBasicTest 541294.44%11.402
Success DependentFieldTest 1400100.00%2.884
Success FinishScenarioTest 100100.00%8.280
Test Cases

[ summary] [ package list] [ test cases]

CollectionTest
Success testNormalAddCollection0.41
Success testNormalChildAddCollection0.12
Success testNormalRemoveCollection0.13
Success testNormalRetainCollection0.10
Success testNormalChildRemoveCollection0.11
Success testNormalRemoveItem0.09
Success testNormalClearIsEmpty0.08
Success testNormalInheritance0.09
Success testNormalQuery0.15
Success testNormalAttachDetach0.18
Success testInverseAddCollection0.09
Success testInverseRemoveCollection0.08
Success testInverseRetainCollection0.06
Success testInverseAddElement0.06
Success testInverseClearIsEmpty0.06
Success testInverseInheritance0.08
Success testInverseQuery0.16
Success testInverseAttachDetach0.14
HashSetTest
Success testNormalAddCollection0.29
Success testNormalChildAddCollection0.09
Success testNormalRemoveCollection0.13
Success testNormalRetainCollection0.08
Success testNormalChildRemoveCollection0.08
Success testNormalRemoveItem0.07
Success testNormalClearIsEmpty0.06
Success testNormalInheritance0.06
Success testNormalQuery0.11
Success testNormalAttachDetach0.15
Success testInverseAddCollection0.07
Success testInverseRemoveCollection0.06
Success testInverseRetainCollection0.06
Success testInverseAddElement0.05
Success testInverseClearIsEmpty0.12
Success testInverseInheritance0.07
Success testInverseQuery0.10
Success testInverseAttachDetach0.11
LinkedHashMapTest
Success testNormalPutItems0.33
Success testNormalRemoveItem0.15
Success testNormalEntrySet0.12
Success testNormalKeySet0.11
Success testNormalValues0.09
Success testNormalClearIsEmpty0.09
Success testNormalInheritance0.12
Success testNormalQueries0.10
Success testNormalQueriesPrimitive0.15
Success testNormalAttachDetach0.19
Success testInversePutItems0.10
Success testInverseRemoveItem0.10
Success testInverseEntrySet0.10
Success testInverseKeySet0.10
Success testInverseValues0.10
Success testInverseClearIsEmpty0.08
Success testInverseInheritance0.07
Success testInverseQueries0.08
Success testInverseAttachDetach0.18
LinkedListTest
Success testNormalAddCollection0.30
Success testNormalRemoveCollection0.11
Success testNormalRetainCollection0.10
Success testNormalRemoveItem0.09
Success testNormalRemoveAt0.08
Success testNormalGetItem0.07
Success testNormalClearIsEmpty0.07
Success testNormalInheritance0.08
Success testNormalQuery0.19
Success testNormalAttachDetach0.17
Success testInverseAddCollection0.06
Success testInverseRemoveCollection0.06
Success testInverseRetainCollection0.07
Success testInverseRemoveItem0.08
Success testInverseGetItem0.06
Success testInverseClearIsEmpty0.06
Success testInverseInheritance0.05
Success testInverseQuery0.07
Success testInverseAttachDetach0.12
LinkedHashSetTest
Success testNormalAddCollection0.27
Success testNormalChildAddCollection0.08
Success testNormalRemoveCollection0.08
Success testNormalRetainCollection0.07
Success testNormalChildRemoveCollection0.07
Success testNormalRemoveItem0.07
Success testNormalClearIsEmpty0.06
Success testNormalInheritance0.07
Success testNormalQuery0.18
Success testNormalAttachDetach0.12
Success testInverseAddCollection0.07
Success testInverseRemoveCollection0.07
Success testInverseRetainCollection0.06
Success testInverseAddElement0.06
Success testInverseClearIsEmpty0.05
Success testInverseInheritance0.06
Success testInverseQuery0.08
Success testInverseAttachDetach0.13
ListTest
Success testNormalAddCollection0.27
Success testNormalChildAddCollection0.08
Success testNormalRemoveCollection0.09
Success testNormalRetainCollection0.08
Success testNormalChildRemovalCollection0.07
Success testNormalRemoveItem0.07
Success testNormalRemoveAt0.07
Success testNormalGetItem0.07
Success testNormalContains0.07
Success testNormalClearIsEmpty0.13
Success testNormalInheritance0.06
Success testNormalQuery0.12
Success testNormalAttachDetach0.15
Success testInverseAddCollection0.07
Success testInverseRemoveCollection0.06
Success testInverseRetainCollection0.06
Success testInverseRemoveItem0.06
Success testInverseGetItem0.05
Success testInverseClearIsEmpty0.06
Success testInverseInheritance0.05
Success testInverseQuery0.06
Success testInverseAttachDetach0.14
ArrayListTest
Success testNormalAddCollection0.28
Success testNormalAddItem0.10
Success testNormalChildAddCollection0.07
Success testNormalRemoveCollection0.08
Success testNormalRetainCollection0.08
Success testNormalChildRemoveCollection0.07
Success testNormalRemoveItem0.13
Success testNormalRemoveAt0.08
Success testNormalGetItem0.06
Success testNormalClearIsEmpty0.06
Success testNormalInheritance0.07
Success testNormalQuery0.11
Success testNormalAttachDetach0.14
Success testInverseAddCollection0.07
Success testInverseRemoveCollection0.06
Success testInverseRetainCollection0.07
Success testInverseRemoveItem0.06
Success testInverseRemoveAt0.06
Success testInverseGetItem0.05
Success testInverseClearIsEmpty0.04
Success testInverseInheritance0.05
Success testInverseQuery0.08
Success testInverseAttachDetach0.13
StackTest
Success testNormalAddCollection0.28
Success testNormalRemoveCollection0.10
Success testNormalRetainCollection0.09
Success testNormalRemoveItem0.08
Success testNormalRemoveAt0.07
Success testNormalGetItem0.06
Success testNormalClearIsEmpty0.13
Success testNormalInheritance0.07
Success testNormalQuery0.10
Success testNormalAttachDetach0.17
Success testInverseAddCollection0.06
Success testInverseRemoveCollection0.06
Success testInverseRetainCollection0.07
Success testInverseRemoveItem0.06
Success testInverseGetItem0.06
Success testInverseClearIsEmpty0.06
Success testInverseInheritance0.05
Success testInverseQuery0.07
Success testInverseAttachDetach0.11
QueueTest
Success testNormalQueue0.24
VectorTest
Success testNormalAddCollection0.28
Success testNormalRemoveCollection0.09
Success testNormalRetainCollection0.09
Success testNormalRemoveItem0.08
Success testNormalRemoveAt0.07
Success testNormalGetItem0.07
Success testNormalClearIsEmpty0.06
Success testNormalInheritance0.07
Success testNormalQuery0.10
Success testNormalAttachDetach0.18
Success testInverseAddCollection0.06
Success testInverseRemoveCollection0.06
Success testInverseRetainCollection0.06
Success testInverseRemoveItem0.06
Success testInverseGetItem0.05
Success testInverseClearIsEmpty0.05
Success testInverseInheritance0.05
Success testInverseQuery0.14
Success testInverselAttachDetach0.12
MapTest
Success testNormalPutItems0.46
Success testNormalRemoveItem0.11
Success testNormalEntrySet0.10
Success testNormalKeySet0.10
Success testNormalValues0.11
Success testNormalNonPrimitiveKeyEntrySet0.16
Success testNormalNonPrimitiveSameKeyValueInstances2.43
Success testNormalNonPrimitiveKeyKeySet0.13
Success testNormalNonPrimitiveKeyQuery0.14
Success testNormalNonPrimitiveKeyValues0.12
Success testNormalClearIsEmpty0.08
Success testNormalInheritance0.09
Success testNormalQueries0.10
Success testNormalQueriesPrimitive0.11
Success testNormalAttachDetach0.27
Success testInversePutItems0.10
Success testInverseRemoveItem0.10
Success testInverseEntrySet0.10
Success testInverseKeySet0.11
Success testInverseValues0.11
Success testInverseNonPrimitiveKeyEntrySet0.11
Success testInverseNonPrimitiveKeyKeySet0.13
Success testInverseNonPrimitiveKeyValues0.13
Success testInverseClearIsEmpty0.11
Success testInverseInheritance0.10
Success testInverseQueries0.11
Success testInverseAttachDetach0.22
SetTest
Success testNormalAddCollection0.27
Success testNormalChildAddCollection0.14
Success testNormalRemoveCollection0.08
Success testNormalRetainCollection0.06
Success testNormalChildRemoveCollection0.08
Success testNormalRemoveItem0.08
Success testNormalClearIsEmpty0.08
Success testNormalContains0.07
Success testNormalInheritance0.06
Success testNormalQuery0.11
Success testNormalAttachDetach0.12
Success testInverseAddCollection0.06
Success testInverseRemoveCollection0.06
Success testInverseRetainCollection0.06
Success testInverseAddElement0.05
Success testInverseClearIsEmpty0.04
Success testInverseInheritance0.05
Success testInverseQuery0.08
Success testInverseAttachDetach0.10
PropertiesTest
Success testNormalPutItems0.43
Success testNormalRemoveItem0.10
Success testNormalEntrySet0.09
Success testNormalKeySet0.07
Success testNormalValues0.07
Success testNormalClearIsEmpty0.11
Success testNormalAttachDetach0.13
TreeSetTest
Success testNormalAddCollection0.27
Success testNormalChildAddCollection0.07
Success testNormalRemoveCollection0.08
Success testNormalRetainCollection0.07
Success testNormalChildRemoveCollection0.07
Success testNormalRemoveItem0.09
Success testNormalClearIsEmpty0.06
Success testNormalInheritance0.06
Success testNormalQuery0.10
Success testNormalAttachDetach0.13
Success testInverseAddCollection0.07
Success testInverseRemoveCollection0.06
Success testInverseRetainCollection0.05
Success testInverseAddElement0.05
Success testInverseClearIsEmpty0.04
Success testInverseInheritance0.05
Success testInverseQuery0.08
Success testInverseAttachDetach0.10
SCOUtilsTest
Success testNewSCOInstance0.00
Success testUseContainerCache0.00
Success testUseCachedLazyLoading0.00
Success testCollectionHasElementsWithoutIdentity0.00
Success testMapHasKeysWithoutIdentity0.00
Success testMapHasValuesWithoutIdentity0.00
Success testCollectionHasSerialisedElements0.00
Success testArrayHasSerialisedElements0.00
Success testMapHasSerialisedKeysAndValues0.00
Success testUpdateCollectionWithCollection0.00
Success testUpdateStoreWithCollection0.00
Success testUpdateCollectionWithCollectionElements0.00
Success testUpdateListWithListElements0.00
Success testUpdateMapWithMapKeysValues0.00
Success testPopulateMapDelegateWithStoreData0.00
Success testToArrayCollectionStoreStateManager0.04
Success testToArrayCollectionStoreStateManagerObjectArray0.00
HashtableTest
Success testNormalPutItems0.31
Success testNormalRemoveItem0.11
Success testNormalEntrySet0.10
Success testNormalKeySet0.10
Success testNormalValues0.09
Success testNormalClearIsEmpty0.09
Success testNormalInheritance0.09
Success testNormalQueries0.09
Success testNormalQueriesPrimitive0.06
Success testNormalAttachDetach0.18
Success testInversePutItems0.09
Success testInverseRemoveItem0.08
Success testInverseEntrySet0.08
Success testInverseKeySet0.09
Success testInverseValues0.10
Success testInverseClearIsEmpty0.08
Success testInverseInheritance0.08
Success testInverseQueries0.17
Success testInverseAttachDetach0.16
HashMapTest
Success testNormalPutItems0.32
Success testNormalRemoveItem0.12
Success testNormalEntrySet0.10
Success testNormalKeySet0.10
Success testNormalValues0.09
Success testNormalClearIsEmpty0.08
Success testNormalInheritance0.10
Success testNormalQueries0.09
Success testNormalQueriesPrimitive0.06
Success testNormalAttachDetach0.18
Success testInversePutItems0.08
Success testInverseRemoveItem0.08
Success testInverseEntrySet0.08
Success testInverseKeySet0.08
Success testInverseValues0.09
Success testInverseClearIsEmpty0.08
Success testInverseInheritance0.15
Success testInverseQueries0.09
Success testInverseAttachDetach0.16
CollectionSerialTest
Success testJoinAddCollection0.24
Success testJoinRemoveCollection0.05
Success testJoinRetainCollection0.05
Success testJoinClearIsEmpty0.04
Success testJoinAttachDetach0.09
Success testFKAddCollection0.07
Success testFKRemoveCollection0.06
Success testFKRetainCollection0.06
Success testFKClearIsEmpty0.07
Success testFKAttachDetach0.15
OptimisticTest
Success testBasicVersionNumber0.21
Success testBasicDateTime0.04
Success testBasicNone0.23
Success testCreationUpdateVersionColumns0.07
Success testDeleteAfterUpdate0.02
Success testMultipleUpdates0.03
Success testConflictTransactionsVersionNumberFromQuery0.04
Success testOptimisticQuery0.09
Success testPCnewToPCdirty0.03
Success testDetachAttach0.04
Success testRefreshOfOptimisticObjects0.02
Success testOptimisticJoinTableRelation0.05
Success testOptimisticWithAutoIncrementObjects0.08
Success testOptimisticWithSequenceTablePoidObjects0.13
Success testOptimisticRollingBack0.00
ReachabilityTest
Success testSimpleReachability0.64
Failure testSimpleReachabilityAfterMakePersistentOnOptimisticTx0.06
reachable persistent alpha: isPersistent() == false
Success testSimpleReachabilityOnOptimisticTxs0.09
Success testSimpleReachabilityOnOptimisticTxsDatastoreAttributedId0.09
Failure testDeepReachability0.08
beta by query not the same as beta by navigation expected same:<org.jpox.samples.reachability.ContainerItem@12fb0af> was not:<org.jpox.samples.reachability.ExtendedItem@1f8bd0d>
Success testTemporaryReachability0.06
Success testNewObjectUnreachableWithDirtObjectOwner0.07
Success testBaseOnQuery0.11
Success testInheritanceOnQuery0.14
Success testInheritanceWithInterface0.11
Success testInheritanceWithBaseClass0.10
Success testObjectIdWithInterface0.09
Success testObjectIdWithBaseClass0.10
Success testIncorrectAssignment0.04
Success testNonTransactionalAccess0.07
Success testNonTransactionalAccess20.07
Success testPopulateBaseCollection0.09
Success testPopulateInverseCollection0.07
BasicQueryTest
Error testQueryOnWidgets0.85
Error executing JDOQL query "SELECT 'org.jpox.samples.widget.Widget ' AS JPOXMETADATA,THIS.WIDGET_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 WIDGET THIS LEFT OUTER JOIN LOCALEWIDGET SUBELEMENT0 ON SUBELEMENT0.LOCALEWIDGET_ID = THIS.WIDGET_ID LEFT OUTER JOIN DECIMALWIDGET SUBELEMENT1 ON SUBELEMENT1.DECIMALWIDGET_ID = THIS.WIDGET_ID LEFT OUTER JOIN ELEMENTWIDGET SUBELEMENT2 ON SUBELEMENT2.ELEMENTWIDGET_ID = THIS.WIDGET_ID LEFT OUTER JOIN SETWIDGET SUBELEMENT3 ON SUBELEMENT3.SETWIDGET_ID = THIS.WIDGET_ID LEFT OUTER JOIN HASHSETWIDGET SUBELEMENT4 ON SUBELEMENT4.HASHSETWIDGET_ID = THIS.WIDGET_ID LEFT OUTER JOIN DATEWIDGET SUBELEMENT5 ON SUBELEMENT5.DATEWIDGET_ID = THIS.WIDGET_ID LEFT OUTER JOIN CURRENCYWIDGET SUBELEMENT6 ON SUBELEMENT6.CURRENCYWIDGET_ID = THIS.WIDGET_ID LEFT OUTER JOIN STRINGWIDGET SUBELEMENT7 ON SUBELEMENT7.STRINGWIDGET_ID = THIS.WIDGET_ID LEFT OUTER JOIN TIMEZONEWIDGET SUBELEMENT8 ON SUBELEMENT8.TIMEZONEWIDGET_ID = THIS.WIDGET_ID LEFT OUTER JOIN FLOATWIDGET SUBELEMENT9 ON SUBELEMENT9.FLOATWIDGET_ID = THIS.WIDGET_ID WHERE SUBELEMENT0.LOCALEWIDGET_ID IS NULL AND SUBELEMENT1.DECIMALWIDGET_ID IS NULL AND SUBELEMENT2.ELEMENTWIDGET_ID IS NULL AND SUBELEMENT3.SETWIDGET_ID IS NULL AND SUBELEMENT4.HASHSETWIDGET_ID IS NULL AND SUBELEMENT5.DATEWIDGET_ID IS NULL AND SUBELEMENT6.CURRENCYWIDGET_ID IS NULL AND SUBELEMENT7.STRINGWIDGET_ID IS NULL AND SUBELEMENT8.TIMEZONEWIDGET_ID IS NULL AND SUBELEMENT9.FLOATWIDGET_ID IS NULL AND THIS.BOOLEAN_FIELD = (THIS.INT_FIELD < ?) AND THIS.INT_FIELD < ? = (THIS.SHORT_FIELD < ?) UNION SELECT 'org.jpox.samples.widget.LocaleWidget ' AS JPOXMETADATA,THIS.WIDGET_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 WIDGET THIS INNER JOIN LOCALEWIDGET "ELEMENT" ON "ELEMENT".LOCALEWIDGET_ID = THIS.WIDGET_ID WHERE THIS.BOOLEAN_FIELD = (THIS.INT_FIELD < ?) AND THIS.INT_FIELD < ? = (THIS.SHORT_FIELD < ?) UNION SELECT 'org.jpox.samples.widget.DecimalWidget ' AS JPOXMETADATA,THIS.WIDGET_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 WIDGET THIS INNER JOIN DECIMALWIDGET "ELEMENT" ON "ELEMENT".DECIMALWIDGET_ID = THIS.WIDGET_ID WHERE THIS.BOOLEAN_FIELD = (THIS.INT_FIELD < ?) AND THIS.INT_FIELD < ? = (THIS.SHORT_FIELD < ?) UNION SELECT 'org.jpox.samples.widget.ElementWidget ' AS JPOXMETADATA,THIS.WIDGET_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 WIDGET THIS INNER JOIN ELEMENTWIDGET "ELEMENT" ON "ELEMENT".ELEMENTWIDGET_ID = THIS.WIDGET_ID WHERE THIS.BOOLEAN_FIELD = (THIS.INT_FIELD < ?) AND THIS.INT_FIELD < ? = (THIS.SHORT_FIELD < ?) UNION SELECT 'org.jpox.samples.widget.SetWidget ' AS JPOXMETADATA,THIS.WIDGET_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 WIDGET THIS INNER JOIN SETWIDGET "ELEMENT" ON "ELEMENT".SETWIDGET_ID = THIS.WIDGET_ID WHERE THIS.BOOLEAN_FIELD = (THIS.INT_FIELD < ?) AND THIS.INT_FIELD < ? = (THIS.SHORT_FIELD < ?) UNION SELECT 'org.jpox.samples.widget.HashSetWidget ' AS JPOXMETADATA,THIS.WIDGET_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 WIDGET THIS INNER JOIN HASHSETWIDGET "ELEMENT" ON "ELEMENT".HASHSETWIDGET_ID = THIS.WIDGET_ID WHERE THIS.BOOLEAN_FIELD = (THIS.INT_FIELD < ?) AND THIS.INT_FIELD < ? = (THIS.SHORT_FIELD < ?) UNION SELECT 'org.jpox.samples.widget.DateWidget ' AS JPOXMETADATA,THIS.WIDGET_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 WIDGET THIS INNER JOIN DATEWIDGET "ELEMENT" ON "ELEMENT".DATEWIDGET_ID = THIS.WIDGET_ID WHERE THIS.BOOLEAN_FIELD = (THIS.INT_FIELD < ?) AND THIS.INT_FIELD < ? = (THIS.SHORT_FIELD < ?) UNION SELECT 'org.jpox.samples.widget.CurrencyWidget' AS JPOXMETADATA,THIS.WIDGET_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 WIDGET THIS INNER JOIN CURRENCYWIDGET "ELEMENT" ON "ELEMENT".CURRENCYWIDGET_ID = THIS.WIDGET_ID WHERE THIS.BOOLEAN_FIELD = (THIS.INT_FIELD < ?) AND THIS.INT_FIELD < ? = (THIS.SHORT_FIELD < ?) UNION SELECT 'org.jpox.samples.widget.StringWidget ' AS JPOXMETADATA,THIS.WIDGET_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 WIDGET THIS INNER JOIN STRINGWIDGET "ELEMENT" ON "ELEMENT".STRINGWIDGET_ID = THIS.WIDGET_ID WHERE THIS.BOOLEAN_FIELD = (THIS.INT_FIELD < ?) AND THIS.INT_FIELD < ? = (THIS.SHORT_FIELD < ?) UNION SELECT 'org.jpox.samples.widget.TimeZoneWidget' AS JPOXMETADATA,THIS.WIDGET_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 WIDGET THIS INNER JOIN TIMEZONEWIDGET "ELEMENT" ON "ELEMENT".TIMEZONEWIDGET_ID = THIS.WIDGET_ID WHERE THIS.BOOLEAN_FIELD = (THIS.INT_FIELD < ?) AND THIS.INT_FIELD < ? = (THIS.SHORT_FIELD < ?) UNION SELECT 'org.jpox.samples.widget.FloatWidget ' AS JPOXMETADATA,THIS.WIDGET_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 WIDGET THIS INNER JOIN FLOATWIDGET "ELEMENT" ON "ELEMENT".FLOATWIDGET_ID = THIS.WIDGET_ID WHERE THIS.BOOLEAN_FIELD = (THIS.INT_FIELD < ?) AND THIS.INT_FIELD < ? = (THIS.SHORT_FIELD < ?)" : Unexpected token: = in statement [SELECT 'org.jpox.samples.widget.Widget ' AS JPOXMETADATA,THIS.WIDGET_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 WIDGET THIS LEFT OUTER JOIN LOCALEWIDGET SUBELEMENT0 ON SUBELEMENT0.LOCALEWIDGET_ID = THIS.WIDGET_ID LEFT OUTER JOIN DECIMALWIDGET SUBELEMENT1 ON SUBELEMENT1.DECIMALWIDGET_ID = THIS.WIDGET_ID LEFT OUTER JOIN ELEMENTWIDGET SUBELEMENT2 ON SUBELEMENT2.ELEMENTWIDGET_ID = THIS.WIDGET_ID LEFT OUTER JOIN SETWIDGET SUBELEMENT3 ON SUBELEMENT3.SETWIDGET_ID = THIS.WIDGET_ID LEFT OUTER JOIN HASHSETWIDGET SUBELEMENT4 ON SUBELEMENT4.HASHSETWIDGET_ID = THIS.WIDGET_ID LEFT OUTER JOIN DATEWIDGET SUBELEMENT5 ON SUBELEMENT5.DATEWIDGET_ID = THIS.WIDGET_ID LEFT OUTER JOIN CURRENCYWIDGET SUBELEMENT6 ON SUBELEMENT6.CURRENCYWIDGET_ID = THIS.WIDGET_ID LEFT OUTER JOIN STRINGWIDGET SUBELEMENT7 ON SUBELEMENT7.STRINGWIDGET_ID = THIS.WIDGET_ID LEFT OUTER JOIN TIMEZONEWIDGET SUBELEMENT8 ON SUBELEMENT8.TIMEZONEWIDGET_ID = THIS.WIDGET_ID LEFT OUTER JOIN FLOATWIDGET SUBELEMENT9 ON SUBELEMENT9.FLOATWIDGET_ID = THIS.WIDGET_ID WHERE SUBELEMENT0.LOCALEWIDGET_ID IS NULL AND SUBELEMENT1.DECIMALWIDGET_ID IS NULL AND SUBELEMENT2.ELEMENTWIDGET_ID IS NULL AND SUBELEMENT3.SETWIDGET_ID IS NULL AND SUBELEMENT4.HASHSETWIDGET_ID IS NULL AND SUBELEMENT5.DATEWIDGET_ID IS NULL AND SUBELEMENT6.CURRENCYWIDGET_ID IS NULL AND SUBELEMENT7.STRINGWIDGET_ID IS NULL AND SUBELEMENT8.TIMEZONEWIDGET_ID IS NULL AND SUBELEMENT9.FLOATWIDGET_ID IS NULL AND THIS.BOOLEAN_FIELD = (THIS.INT_FIELD < ?) AND THIS.INT_FIELD < ? = (THIS.SHORT_FIELD < ?) UNION SELECT 'org.jpox.samples.widget.LocaleWidget ' AS JPOXMETADATA,THIS.WIDGET_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 WIDGET THIS INNER JOIN LOCALEWIDGET "ELEMENT" ON "ELEMENT".LOCALEWIDGET_ID = THIS.WIDGET_ID WHERE THIS.BOOLEAN_FIELD = (THIS.INT_FIELD < ?) AND THIS.INT_FIELD < ? = (THIS.SHORT_FIELD < ?) UNION SELECT 'org.jpox.samples.widget.DecimalWidget ' AS JPOXMETADATA,THIS.WIDGET_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 WIDGET THIS INNER JOIN DECIMALWIDGET "ELEMENT" ON "ELEMENT".DECIMALWIDGET_ID = THIS.WIDGET_ID WHERE THIS.BOOLEAN_FIELD = (THIS.INT_FIELD < ?) AND THIS.INT_FIELD < ? = (THIS.SHORT_FIELD < ?) UNION SELECT 'org.jpox.samples.widget.ElementWidget ' AS JPOXMETADATA,THIS.WIDGET_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 WIDGET THIS INNER JOIN ELEMENTWIDGET "ELEMENT" ON "ELEMENT".ELEMENTWIDGET_ID = THIS.WIDGET_ID WHERE THIS.BOOLEAN_FIELD = (THIS.INT_FIELD < ?) AND THIS.INT_FIELD < ? = (THIS.SHORT_FIELD < ?) UNION SELECT 'org.jpox.samples.widget.SetWidget ' AS JPOXMETADATA,THIS.WIDGET_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 WIDGET THIS INNER JOIN SETWIDGET "ELEMENT" ON "ELEMENT".SETWIDGET_ID = THIS.WIDGET_ID WHERE THIS.BOOLEAN_FIELD = (THIS.INT_FIELD < ?) AND THIS.INT_FIELD < ? = (THIS.SHORT_FIELD < ?) UNION SELECT 'org.jpox.samples.widget.HashSetWidget ' AS JPOXMETADATA,THIS.WIDGET_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 WIDGET THIS INNER JOIN HASHSETWIDGET "ELEMENT" ON "ELEMENT".HASHSETWIDGET_ID = THIS.WIDGET_ID WHERE THIS.BOOLEAN_FIELD = (THIS.INT_FIELD < ?) AND THIS.INT_FIELD < ? = (THIS.SHORT_FIELD < ?) UNION SELECT 'org.jpox.samples.widget.DateWidget ' AS JPOXMETADATA,THIS.WIDGET_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 WIDGET THIS INNER JOIN DATEWIDGET "ELEMENT" ON "ELEMENT".DATEWIDGET_ID = THIS.WIDGET_ID WHERE THIS.BOOLEAN_FIELD = (THIS.INT_FIELD < ?) AND THIS.INT_FIELD < ? = (THIS.SHORT_FIELD < ?) UNION SELECT 'org.jpox.samples.widget.CurrencyWidget' AS JPOXMETADATA,THIS.WIDGET_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 WIDGET THIS INNER JOIN CURRENCYWIDGET "ELEMENT" ON "ELEMENT".CURRENCYWIDGET_ID = THIS.WIDGET_ID WHERE THIS.BOOLEAN_FIELD = (THIS.INT_FIELD < ?) AND THIS.INT_FIELD < ? = (THIS.SHORT_FIELD < ?) UNION SELECT 'org.jpox.samples.widget.StringWidget ' AS JPOXMETADATA,THIS.WIDGET_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 WIDGET THIS INNER JOIN STRINGWIDGET "ELEMENT" ON "ELEMENT".STRINGWIDGET_ID = THIS.WIDGET_ID WHERE THIS.BOOLEAN_FIELD = (THIS.INT_FIELD < ?) AND THIS.INT_FIELD < ? = (THIS.SHORT_FIELD < ?) UNION SELECT 'org.jpox.samples.widget.TimeZoneWidget' AS JPOXMETADATA,THIS.WIDGET_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 WIDGET THIS INNER JOIN TIMEZONEWIDGET "ELEMENT" ON "ELEMENT".TIMEZONEWIDGET_ID = THIS.WIDGET_ID WHERE THIS.BOOLEAN_FIELD = (THIS.INT_FIELD < ?) AND THIS.INT_FIELD < ? = (THIS.SHORT_FIELD < ?) UNION SELECT 'org.jpox.samples.widget.FloatWidget ' AS JPOXMETADATA,THIS.WIDGET_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 WIDGET THIS INNER JOIN FLOATWIDGET "ELEMENT" ON "ELEMENT".FLOATWIDGET_ID = THIS.WIDGET_ID WHERE THIS.BOOLEAN_FIELD = (THIS.INT_FIELD < ?) AND THIS.INT_FIELD < ? = (THIS.SHORT_FIELD < ?)].
Success testQueryOnStringWidgets0.41
Success testQueryOnDateWidgets0.26
Success testQueryOnFloatWidgets0.16
Success testQueryOnSetWidgets5.03
Success testQueryOnHashSetWidgets3.91
Error </