Development
Core Plugins
Datastores
Documentation
Testing
Summary

[ summary] [ package list] [ test cases]

Tests Errors Failures Success rate Time(s)
309 4 7 96.44% 125.77

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

Package List

[ summary] [ package list] [ test cases]

Package Tests Errors Failures Success Rate Time
org.jpox.tests.types 23 0 1 95.65% 4.31
org.jpox.tests 286 4 6 96.50% 121.45

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

org.jpox.tests.types
Class Tests Errors Failures Success Rate Time
Success URITest 3 0 0 100.00% 0.434
Success StringBufferTest 2 0 0 100.00% 0.318
Success URLTest 3 0 0 100.00% 0.382
Success UUIDMappingTest 3 0 0 100.00% 0.845
Success BufferedImageTest 1 0 0 100.00% 0.713
Failure CalendarTest 6 0 1 83.33% 0.517
Success PointTest 2 0 0 100.00% 0.411
Success BitSetTest 2 0 0 100.00% 0.402
Success ColorTest 1 0 0 100.00% 0.290
org.jpox.tests
Class Tests Errors Failures Success Rate Time
Success ExpressionTest 2 0 0 100.00% 0.489
Success CacheTest 9 0 0 100.00% 4.064
Failure TypeStorageTest 12 0 1 91.67% 10.819
Failure NondurableIdTest 3 0 2 33.33% 1.059
Success AttachDetachReplicateTest 6 0 0 100.00% 3.475
Success SerializationTest 7 0 0 100.00% 2.694
Failure AttachDetachTest 36 0 1 97.22% 7.362
Success ManagedRelationshipTest 16 0 0 100.00% 1.177
Success ArrayTest 28 0 0 100.00% 2.758
Success JDOQLSingleStringParserTest 2 0 0 100.00% 0.038
Success TypesMappingTest 2 0 0 100.00% 0.017
Success MetaDataTest 17 0 0 100.00% 6.268
Success TransactionTest 4 0 0 100.00% 1.125
Success JPOXSQLQueryTest 6 0 0 100.00% 1.259
Success EmbeddedTest 11 0 0 100.00% 1.046
Success ClassLoaderTest 10 0 0 100.00% 0.264
Success PersistenceManagerFactoryTest 3 0 0 100.00% 4.194
Error BasicQueryTest 11 3 0 72.73% 14.770
Success ExtentTest 5 0 0 100.00% 0.832
Success SequenceTest 4 0 0 100.00% 0.425
Success MemoryTest 1 0 0 100.00% 33.408
Success IdentifierFactoryTest 2 0 0 100.00% 0.474
Error ViewTest 5 1 0 80.00% 2.169
Success TypeManagerTest 3 0 0 100.00% 0.025
Success GeneralTest 5 0 0 100.00% 1.162
Success JPOXJDOHelperTest 1 0 0 100.00% 0.341
Success StateTransitionsTest 1 0 0 100.00% 0.552
Success PersistenceManagerTest 49 0 0 100.00% 4.825
Success I18NTest 3 0 0 100.00% 0.753
Success MultithreadTest 7 0 0 100.00% 8.330
Success FetchPlanImplTest 13 0 0 100.00% 1.942
Failure ConcurrencyTest 2 0 2 0.00% 3.337
Test Cases

[ summary] [ package list] [ test cases]

URITest
Success testQuery 0.31
Success testBasicPersistence 0.03
Success testDetachAttach 0.08
StringBufferTest
Success testBasicPersistence 0.28
Success testQuery 0.02
URLTest
Success testQuery 0.29
Success testBasicPersistence 0.02
Success testDetachAttach 0.06
UUIDMappingTest
Success testRandomUuid 0.72
Success testNullUuid 0.02
Success testQueryUuid 0.09
BufferedImageTest
Success testBasicPersistence 0.70
CalendarTest
Success testBasicPersistenceAsTwoColumns 0.32
Success testDetachAttachAsTwoColumns 0.06
Failure testQueryCalendarAsTwoColumns 0.03
Unexpected exception thrown while querying Calendar : JPOX doesnt support querying of Calendar fields when stored as 2 columns
Success testBasicPersistenceAsOneColumn 0.03
Success testNullAsOneColumn 0.02
Success testNullAsTwoColumn 0.04
PointTest
Success testBasicPersistence 0.34
Success testDetachAttach 0.06
BitSetTest
Success testBasicPersistence 0.33
Success testDetachAttach 0.05
ColorTest
Success testBasicPersistence 0.28
ExpressionTest
Success testExpression 0.47
Success testStringExpression 0.00
CacheTest
Success testL1WeakRefL2 0.81
Success testL1SoftRefL2 0.60
Success testL2CachedObject 0.43
Success testL2LoadedFields 0.36
Success testSCOAndPCReuse 0.40
Success testEvictAll 0.37
Success testDetachAllOnCommitWithoutL2 0.44
Success testDetachAllOnCommitWithL2 0.32
Success testMultithreadObjectRead 0.32
TypeStorageTest
Success testBasicTypes 0.57
Success testString 0.24
Success testDate 0.36
Success testLocale 1.37
Success testCurrency 0.21
Success testTimeZone 0.24
Success testDecimal 0.24
Success testFloat 0.22
Success testStringBlobWidgets 1.78
Success testStringClobWidgets 1.61
Failure testSetWidgets 2.40
inverseSet should not contain deleted object
Success testHashSetWidgets 1.57
NondurableIdTest
Success testPersist 0.42
Failure testUpdate 0.37
Exception thrown while updating field of nondurable object : Update of object "org.jpox.samples.nondurable.LogEntry@2db19d" using statement "UPDATE LOGENTRY SET "LEVEL"=? WHERE " failed : Unexpected token: in statement [UPDATE LOGENTRY SET "LEVEL"=? WHERE ]
Failure testDelete 0.26
Exception thrown while deleting nondurable object : Delete of object "org.jpox.samples.nondurable.LogEntry@a00185" using statement "DELETE FROM LOGENTRY WHERE " failed : Unexpected token: in statement [DELETE FROM LOGENTRY WHERE ]
AttachDetachReplicateTest
Success testReplicateSimple 0.75
Success testReplicateRelation_1to1_circular 0.49
Success testMoveAcrossDatastores_company 0.72
Success testMoveAcrossDatastoresWithRelation 0.51
Success testSetDetachedObjectOnFieldInPCNewObject 0.28
Success testReplicateApplicationIdentityWith1toN 0.71
SerializationTest
Success testOIDSerialization 0.90
Success testSerialisedPC 0.11
Success testSerialisedPCDetach 0.06
Success testSerialisedInterface 0.27
Success testSerialisedCollectionElements 0.51
Success testSerialisedMapValues 0.28
Success testSerialiseDetach 0.56
AttachDetachTest
Success testDetachStates 1.05
Success testSimpleDetach 1.41
Success testBasicDetachAttach 0.31
Success testDetachAttach_ManyToOne 0.34
Success testDetachAttach_ManyToOne_NewPM 0.25
Success testDetachAttach_OneToMany 0.52
Success testDetachAttach_OneToMany_NewPM 0.48
Success testDetachTransactionalField 0.02
Success testDetachCollectionWithNonPCElements 0.03
Success testAttachDetachNonTransactionalRead 0.45
Success testDetachAttach_OneToManyBidir 0.09
Success testDetachAttach_OneToManyFK 0.20
Success testDetachAttach_ManyToMany 0.19
Success testRelationManaging 0.10
Success testCircularDetach 0.02
Success testDetachAttach_OneToMany_RelationConsistency 0.09
Success testAttachDetachNonPCCollectionElements 0.05
Success testPersistWithDetachedRelative 0.06
Success testPersistWithDetachedRelativeInMap 0.31
Success testDetachOfNonPersistentPC 0.01
Success testDetachAttachOfSCODate 0.04
Success testAggregatedDetachAttachFieldMap 0.31
Success testDetachOnClose 0.07
Success testDetachAllOnCommit 0.11
Success testDetachAllOnCommitViaFetch 0.09
Success testDetachAllOnCommitViaFetchUnlimited 0.09
Success testDetachDuplicates 0.04
Success testMaxFetchDepth 0.12
Success testFetchRecurse 0.15
Failure testFetchDepthOnDetachCopyAll 0.10
Manager must be returned for maxFetchDepth of 1 : employee Dave has no manager
Success testDetachLoadUnloadFields 0.08
Success testAttachCleanCollectionWithNonPCElements 0.02
Success testAttachOneManyBidirFromNewManySide 0.02
Success testCopyOnAttachFalseOneToManyBidir 0.03
Success testCopyOnAttachFalseOneToOne 0.07
Success testCopyOnAttachFalseMultipleDetach 0.02
ManagedRelationshipTest
Success testOneToOneBidirPersist 0.38
Success testOneToOneBidirPersistInconsistent 0.02
Success testOneToOneBidirUpdateOwner 0.07
Success testOneToOneBidirUpdateNonOwner 0.06
Success testOneToManyFKBidirPersistCollection 0.14
Success testOneToManyFKBidirPersistInconsistent 0.01
Success testOneToManyFKBidirPersistElement 0.03
Success testOneToManyFKBidirPersistElement2 0.03
Success testOneToManyFKBidirUpdateElement 0.07
Success testOneToManyFKBidirDeleteElement 0.04
Success testOneToManyJoinBidirPersistCollection 0.10
Success testOneToManyJoinBidirPersistElement 0.02
Success testOneToManyJoinBidirUpdateElement 0.06
Success testOneToManyJoinBidirDeleteElement 0.04
Success testOneToManyJoinBidirPersistInconsistent 0.01
Success testManyToManyBidirPersist 0.06
ArrayTest
Success testBooleanArray 1.23
Success testByteArray 0.07
Success testCharArray 0.06
Success testDoubleArray 0.06
Success testFloatArray 0.05
Success testIntArray 0.05
Success testLongArray 0.05
Success testShortArray 0.06
Success testBooleanObjectArray 0.06
Success testByteObjectArray 0.05
Success testCharObjectArray 0.05
Success testDoubleObjectArray 0.05
Success testFloatObjectArray 0.05
Success testIntObjectArray 0.05
Success testLongObjectArray 0.05
Success testShortObjectArray 0.05
Success testBigDecimalArray 0.06
Success testBigIntegerArray 0.05
Success testDateArray 0.06
Success testLocaleArray 0.07
Success testStringArray 0.04
Success testInterfaceArray 0.09
Success testPersistableArray 0.09
Success testObjectArray 0.09
Success testJoinTableIntQueryArray 0.05
Success testJoinTableStringQueryArray 0.03
Success testJoinTablePCQueryArray 0.04
Success testJoinTableInterfaceQueryArray 0.03
JDOQLSingleStringParserTest
Success testImport 0.02
Success testVariableBeforeParameter 0.00
TypesMappingTest
Success testDB2DataLinkType 0.00
Success testMSSQLUniqueIdentifierType 0.00
MetaDataTest
Success testInh2 0.35
Success testUseOfObjectIdClass 0.11
Success testMetaDataManager 0.27
Success testMetaDataMultithreaded 2.61
Success testLoadingMetaDataForPackage 0.64
Success testLoadingMetaDataFileLocations 0.27
Success testMetaDataManagerI18N 0.42
Success testDatastoreIdentityMetadata 0.22
Success testFieldColumnMetadata 0.12
Success testFieldForeignKeyMetadata 0.12
Success testPrimaryKeyMetadata 0.14
Success testImplementsMetadata 0.23
Success testFieldDeclaredInSubClassMetadata 0.12
Success testDependent 0.12
Success testSerialization 0.31
Success testPersistentProperties 0.11
Success testPersistentPropertiesFieldPropertyClash 0.10
TransactionTest
Success testAutomaticRollback 0.67
Success testSqlExceptionIsAccessible 0.04
Success testRollbackOnly 0.37
Success testUpdateDuringBeforeCompletion 0.03
JPOXSQLQueryTest
Success testJPOXSQLQueryOfWidgets 0.70
Success testWithCandidateClass 0.19
Success testWithCandidateClassWithIdentifiers 0.03
Success testWithoutCandidateClassWithParameters 0.03
Success testWithoutCandidateClassWithResultClass 0.26
Success testNamedQueries 0.04
EmbeddedTest
Success testEmbeddedPCObject 0.34
Success testEmbeddedPCObjectNullValue 0.04
Success testEmbeddedObjectPersist 0.06
Success testEmbeddedPCObjectDetachAttach 0.03
Success testEmbeddedOnly 0.06
Success testNestedEmbeddedPCObjects 0.10
Success testEmbeddedOnlyWithQuery 0.02
Success testEmbeddedCollection 0.14
Success testEmbeddedCollectionQuery 0.03
Success testEmbeddedList 0.08
Success testEmbeddedMap 0.13
ClassLoaderTest
Success testNewInstance 0.00
Success testContextClassLoader 0.00
Success testNegativeContextClassLoader 0.00
Success testJPOXinClassloader2 0.00
Success testNewObjectInstance 0.00
Success testNewObjectInstance1 0.00
Success testNegativeJPOXinClassloader2 0.00
Success testClassNotPersistenceCapable 0.00
Success testDatastoreAdapterLoadingDatastoreMapping 0.00
Success testNotInitilizedClass 0.00
PersistenceManagerFactoryTest
Success testJDOHelperInstantiation 3.35
Success testClose 0.47
Success testServerTimeZoneID 0.36
BasicQueryTest
Error testQueryOnWidgets 1.20
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 DECIMALWIDGET SUBELEMENT0 ON SUBELEMENT0.DECIMALWIDGET_ID = THIS.WIDGET_ID LEFT OUTER JOIN ELEMENTWIDGET SUBELEMENT1 ON SUBELEMENT1.ELEMENTWIDGET_ID = THIS.WIDGET_ID LEFT OUTER JOIN SETWIDGET SUBELEMENT2 ON SUBELEMENT2.SETWIDGET_ID = THIS.WIDGET_ID LEFT OUTER JOIN HASHSETWIDGET SUBELEMENT3 ON SUBELEMENT3.HASHSETWIDGET_ID = THIS.WIDGET_ID LEFT OUTER JOIN DATEWIDGET SUBELEMENT4 ON SUBELEMENT4.DATEWIDGET_ID = THIS.WIDGET_ID LEFT OUTER JOIN STRINGBLOBWIDGET SUBELEMENT5 ON SUBELEMENT5.STRINGBLOBWIDGET_ID = THIS.WIDGET_ID LEFT OUTER JOIN STRINGWIDGET SUBELEMENT6 ON SUBELEMENT6.STRINGWIDGET_ID = THIS.WIDGET_ID LEFT OUTER JOIN STRINGCLOBWIDGET SUBELEMENT7 ON SUBELEMENT7.STRINGCLOBWIDGET_ID = THIS.WIDGET_ID LEFT OUTER JOIN FLOATWIDGET SUBELEMENT8 ON SUBELEMENT8.FLOATWIDGET_ID = THIS.WIDGET_ID WHERE SUBELEMENT0.DECIMALWIDGET_ID IS NULL AND SUBELEMENT1.ELEMENTWIDGET_ID IS NULL AND SUBELEMENT2.SETWIDGET_ID IS NULL AND SUBELEMENT3.HASHSETWIDGET_ID IS NULL AND SUBELEMENT4.DATEWIDGET_ID IS NULL AND SUBELEMENT5.STRINGBLOBWIDGET_ID IS NULL AND SUBELEMENT6.STRINGWIDGET_ID IS NULL AND SUBELEMENT7.STRINGCLOBWIDGET_ID IS NULL AND SUBELEMENT8.FLOATWIDGET_ID IS NULL AND 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.StringBlobWidget' 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 STRINGBLOBWIDGET "ELEMENT" ON "ELEMENT".STRINGBLOBWIDGET_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.StringClobWidget' 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 STRINGCLOBWIDGET "ELEMENT" ON "ELEMENT".STRINGCLOBWIDGET_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 DECIMALWIDGET SUBELEMENT0 ON SUBELEMENT0.DECIMALWIDGET_ID = THIS.WIDGET_ID LEFT OUTER JOIN ELEMENTWIDGET SUBELEMENT1 ON SUBELEMENT1.ELEMENTWIDGET_ID = THIS.WIDGET_ID LEFT OUTER JOIN SETWIDGET SUBELEMENT2 ON SUBELEMENT2.SETWIDGET_ID = THIS.WIDGET_ID LEFT OUTER JOIN HASHSETWIDGET SUBELEMENT3 ON SUBELEMENT3.HASHSETWIDGET_ID = THIS.WIDGET_ID LEFT OUTER JOIN DATEWIDGET SUBELEMENT4 ON SUBELEMENT4.DATEWIDGET_ID = THIS.WIDGET_ID LEFT OUTER JOIN STRINGBLOBWIDGET SUBELEMENT5 ON SUBELEMENT5.STRINGBLOBWIDGET_ID = THIS.WIDGET_ID LEFT OUTER JOIN STRINGWIDGET SUBELEMENT6 ON SUBELEMENT6.STRINGWIDGET_ID = THIS.WIDGET_ID LEFT OUTER JOIN STRINGCLOBWIDGET SUBELEMENT7 ON SUBELEMENT7.STRINGCLOBWIDGET_ID = THIS.WIDGET_ID LEFT OUTER JOIN FLOATWIDGET SUBELEMENT8 ON SUBELEMENT8.FLOATWIDGET_ID = THIS.WIDGET_ID WHERE SUBELEMENT0.DECIMALWIDGET_ID IS NULL AND SUBELEMENT1.ELEMENTWIDGET_ID IS NULL AND SUBELEMENT2.SETWIDGET_ID IS NULL AND SUBELEMENT3.HASHSETWIDGET_ID IS NULL AND SUBELEMENT4.DATEWIDGET_ID IS NULL AND SUBELEMENT5.STRINGBLOBWIDGET_ID IS NULL AND SUBELEMENT6.STRINGWIDGET_ID IS NULL AND SUBELEMENT7.STRINGCLOBWIDGET_ID IS NULL AND SUBELEMENT8.FLOATWIDGET_ID IS NULL AND 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 "EL