Development
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 "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 < ?)].
Success testQueryOnStringWidgets 0.30
Success testQueryOnDateWidgets 0.22
Success testQueryOnFloatWidgets 0.14
Success testQueryOnSetWidgets 4.89
Success testQueryOnHashSetWidgets 3.74
Error testQueryOnInterfaceFields 0.11
Cannot perform operation "cast to org.jpox.samples.widget.DateWidget" on ReferenceExpression "THIS.CLONEABLE_WIDGET_WIDGET_ID_EID"
Error testQueryOnObjectFields 0.08
Error executing JDOQL query "SELECT 'org.jpox.samples.widget.OwnerWidget' AS JPOXMETADATA,THIS.OWNERWIDGET_ID FROM OWNERWIDGET THIS LEFT OUTER JOIN DATEWIDGET THIS_DATEWIDGET ON THIS_DATEWIDGET.DATEWIDGET_ID = THIS.TEST_OBJECT WHERE (THIS_DATEWIDGET.DATE_FIELD) IS NOT NULL AND THIS_DATEWIDGET.DATE_FIELD > ?" : Wrong data type: For input string: "aced00057372001e6f72672e6a706f782e73616d706c65732e7769646765742e57696467657429bdfaa9a2501af103000c5a000c626f6f6c65616e4669656c64420009627974654669656c64430009636861724669656c64490008696e744669656c644a00096c6f6e674669656c6453000a73686f72744669656c644c000f626f6f6c65616e4f626a4669656c647400134c6a6176612f6c616e672f426f6f6c65616e3b4c000c627974654f626a4669656c647400104c6a6176612f6c616e672f427974653b4c000c636861724f626a4669656c647400154c6a6176612f6c616e672f4368617261637465723b4c000b696e744f626a4669656c647400134c6a6176612f6c616e672f496e74656765723b4c000c6c6f6e674f626a4669656c647400104c6a6176612f6c616e672f4c6f6e673b4c000d73686f72744f626a4669656c647400114c6a6176612f6c616e672f53686f72743b787001b7007b22b6790db3e0e57e1868360a7bb0707372000e6a6176612e6c616e672e427974659c4e6084ee50f51c02000142000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b02000078704b737200136a6176612e6c616e672e436861726163746572348b47d96b1a267802000143000576616c756578700067737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c75657871007e000941b15bdd7372000e6a6176612e6c616e672e4c6f6e673b8be490cc8f23df0200014a000576616c75657871007e0009734560694ba877657372000f6a6176612e6c616e672e53686f7274684d37133460da5202000153000576616c75657871007e00094cc778" in statement [SELECT 'org.jpox.samples.widget.OwnerWidget' AS JPOXMETADATA,THIS.OWNERWIDGET_ID FROM OWNERWIDGET THIS LEFT OUTER JOIN DATEWIDGET THIS_DATEWIDGET ON THIS_DATEWIDGET.DATEWIDGET_ID = THIS.TEST_OBJECT WHERE (THIS_DATEWIDGET.DATE_FIELD) IS NOT NULL AND THIS_DATEWIDGET.DATE_FIELD > ?].
Success testRelationalOperatorsWithConstantsAndExtentCandidate 1.37
Success testRelationalOperatorsWithConstantsAndNormalCollectionCandidate 1.47
Success testRelationalOperatorsWithConstantsAndInverseCollectionCandidate 1.23
ExtentTest
Success testRequiresExtent 0.28
Success testCloseAll 0.04
Success testExtentOfNewTable 0.10
Success testExtentOfSubclassTable 0.03
Success testExtentSubclasses 0.36
SequenceTest
Success testInvalidSequenceName 0.37
Success testContiguousSequence 0.03
Success testNontransactionalSequence 0.00
Success testFactorySequence 0.00
MemoryTest
Success testMemoryManagementNewPC 33.39
IdentifierFactoryTest
Success testJPOX 0.45
Success testJPA 0.00
ViewTest
Success testViewOfWidgets 0.55
Success testViewOfSetWidgets 1.42
Success testCreatingDependentFirst 0.06
Success testCreatingReliedOnFirst 0.01
Error testCircularViewDependencies 0.12
An exception was thrown while adding/validating class(es) : Table not found in statement [ SELECT WIDGET.WIDGET_ID, CIRCULARREFERENCEVIEW3.MY_INT FROM WIDGET INNER JOIN CIRCULARREFERENCEVIEW3] java.sql.SQLException: Table not found in statement [ SELECT WIDGET.WIDGET_ID, CIRCULARREFERENCEVIEW3.MY_INT FROM WIDGET INNER JOIN CIRCULARREFERENCEVIEW3] at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:194) at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:680) at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:636) at org.jpox.store.rdbms.table.AbstractTable.create(AbstractTable.java:347) at org.jpox.store.rdbms.table.AbstractTable.exists(AbstractTable.java:395) at org.jpox.store.rdbms.RDBMSManager$ClassAdder.performViewsValidation(RDBMSManager.java:3687) at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:3342) at org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2956) at org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.java:2835) at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:847) at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:814) at org.jpox.tests.JPOXPersistenceTestCase.addClassesToSchema(JPOXPersistenceTestCase.java:95) at org.jpox.tests.ViewTest.testCircularViewDependencies(ViewTest.java:409) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at junit.framework.TestCase.runTest(TestCase.java:154) at org.jpox.tests.ViewTest.runTest(ViewTest.java:104) at junit.framework.TestCase.runBare(TestCase.java:127) at junit.framework.TestResult$1.protect(TestResult.java:106) at junit.framework.TestResult.runProtected(TestResult.java:124) at junit.framework.TestResult.run(TestResult.java:109) at junit.framework.TestCase.run(TestCase.java:118) at junit.framework.TestSuite.runTest(TestSuite.java:208) at junit.framework.TestSuite.run(TestSuite.java:203) at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.run(JUnitTestRunner.java:325) at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.main(JUnitTestRunner.java:536)
TypeManagerTest
Success testIsSupportedType 0.01
Success testIsSupportedArrayType 0.00
Success testIsDefaultPersistentType 0.00
GeneralTest
Success testPersistenceAware 0.66
Success testInitializationOfFieldsInConstructor 0.35
Success testSelectWithSQLFunction 0.10
Success testInsertWithSQLFunction 0.02
Success testUpdateWithSQLFunction 0.02
JPOXJDOHelperTest
Success testObjectState 0.32
StateTransitionsTest
Success testStateTransitions 0.54
PersistenceManagerTest
Success testMakePersistent 0.37
Success testNontransactionalPersist 0.10
Success testNontransactionalUpdate 0.07
Success testNonTransactionalUpdateWithRollback 0.06
Success testNewObjectIdInstance 0.13
Success testGetObjectId 0.08
Success testGetObjectById 0.09
Success testEvict 0.07
Success testGetObjectByIdNonTransactional 1.33
Success testClose 0.04
Success testMakeCollectionFieldsPersistent 0.15
Success testUpdatePersistentFields 0.06
Success testUpdatePersistentFieldsExceptions 0.06
Success testMakeTransient 0.05
Success testMakeTransientAll 0.06
Success testMakeTransientExceptions 0.05
Success testMakeTransientOwnerAndElements 0.20
Success testMakeTransientOwnerAndElementsUsingFetchPlan 0.10
Success testRetrieve 0.09
Success testRefresh 0.04
Success testDeletePersistent 0.05
Success testDeletePersistentNonTransactional 0.04
Success testDeletePersistentExceptions 0.04
Success testInheritedFieldsPersisted 0.06
Success testPersistenceOfOneToOneRelations 0.06
Success testPCFieldAccess 0.04
Success testJavaIdentity 0.04
Success testNormalFCOCollectionFieldPersistence1 0.07
Success testNormalFCOCollectionFieldPersistence2 0.03
Success testNormalFCOCollectionFieldPersistence3 0.07
Success testNormalFCOCollectionFieldPersistence4 0.08
Success testFKCollectionFieldPersistenceByReachability1 0.06
Success testFKCollectionFieldPersistenceByReachability2 0.07
Success testElementDeletionRemovesFromFKCollection 0.06
Success testInverseFCOCollectionFieldPersistence4 0.06
Success testQueryPM 0.06
Success testLifecycleListenerForSimpleObjects 0.06
Success testLifecycleListenerForCollections 0.07
Success testLifecycleListenerRegisteredInPMFforAllClasses 0.04
Success testInstanceCallbacks 0.05
Success testInstanceCallbacksInSCO 0.08
Success testAttachDetachCallbacks 0.05
Success testJoinTableCollectionFieldPersistence1 0.09
Success testJDOConnection 0.03
Success testTransientObjectCollections 0.05
Success testGetServerDate 0.04
Success testNonTransactionReadNegative 0.09
Success testNonTransactionWriteNegative 0.03
Success testNewInstancePCClass 0.03
I18NTest
Success testISO8859_1 0.61
Success testISO8859_2 0.06
Success testUTF8 0.07
MultithreadTest
Success testMultipleTransitionRead 1.15
Success testMultipleNonTransactionalRead 0.26
Success testMultipleTransitionWrite 0.65
Success testEvictAllAndWrites 4.31
Success testMultipleNonTransitionWrite 0.47
Success testMultipleDetachCopy 0.93
Success testMultipleDetachCopyAndFetchPlanModification 0.55
FetchPlanImplTest
Success testAddGroup 0.00
Success testRemoveGroup 0.00
Success testClearGroups 0.00
Success testSetGroups 0.00
Success testGetGroups 0.00
Success testDetachmentRoots 0.00
Success testDetachmentRootsClasses 0.00
Success testFetchPlan 0.69
Success testPostLoad 0.20
Success testFetchPlanInheritance 0.36
Success testNestedFetchPlans 0.32
Success testNestedFetchGroupsAgain 0.14
Success testDynamicFetchPlan 0.21
ConcurrencyTest
Failure testBasicConcurrency 1.96
expected:<700> but was:<900>
Failure testBasicConcurrencyExtraPM 1.36
expected:<700> but was:<800>
Failure details
Failure testQueryCalendarAsTwoColumns
Unexpected exception thrown while querying Calendar : JPOX doesnt support querying of Calendar fields when stored as 2 columns
junit.framework.AssertionFailedError: Unexpected exception thrown while querying Calendar : JPOX doesnt support querying of Calendar fields when stored as 2 columns at org.jpox.tests.types.CalendarTest.testQueryCalendarAsTwoColumns(CalendarTest.java:435)
Failure testSetWidgets
inverseSet should not contain deleted object
junit.framework.AssertionFailedError: inverseSet should not contain deleted object at org.jpox.samples.widget.SetWidget.fillRandom(SetWidget.java:130) at org.jpox.samples.widget.SetWidget.fillRandom(SetWidget.java:101) at org.jpox.samples.widget.SetWidget.fillRandom(SetWidget.java:95) at org.jpox.tests.StorageTester.validateNewObjectRollback(StorageTester.java:560) at org.jpox.tests.StorageTester.runStorageTestForClass(StorageTester.java:82) at org.jpox.tests.TypeStorageTest.testSetWidgets(TypeStorageTest.java:292)
Failure testUpdate
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 ]
junit.framework.AssertionFailedError: 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 ] at org.jpox.tests.NondurableIdTest.testUpdate(NondurableIdTest.java:252)
Failure testDelete
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 ]
junit.framework.AssertionFailedError: 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 ] at org.jpox.tests.NondurableIdTest.testDelete(NondurableIdTest.java:350)
Failure testFetchDepthOnDetachCopyAll
Manager must be returned for maxFetchDepth of 1 : employee Dave has no manager
junit.framework.AssertionFailedError: Manager must be returned for maxFetchDepth of 1 : employee Dave has no manager at org.jpox.tests.AttachDetachTest.testFetchDepthOnDetachCopyAll(AttachDetachTest.java:4093)
Error testQueryOnWidgets
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 "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 < ?)].
javax.jdo.JDODataStoreException: 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 "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 < ?)]. at org.jpox.jdo.JPOXJDOHelper.getJDOExceptionForJPOXException(JPOXJDOHelper.java:289) at org.jpox.jdo.JDOQuery.execute(JDOQuery.java:210) at org.jpox.tests.BasicQueryTest.queryWidgetObjects(BasicQueryTest.java:564) at org.jpox.tests.BasicQueryTest.testQueryOnWidgets(BasicQueryTest.java:108) 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: 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 "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 < ?)] 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:94) at org.jpox.store.rdbms.query.JDOQLQuery.performExecute(JDOQLQuery.java:330) at org.jpox.store.query.Query.executeWithMap(Query.java:1037) at org.jpox.store.query.Query.executeWithArray(Query.java:986) at org.jpox.store.query.Query.execute(Query.java:908) at org.jpox.jdo.JDOQuery.execute(JDOQuery.java:205) at org.jpox.tests.BasicQueryTest.queryWidgetObjects(BasicQueryTest.java:564) at org.jpox.tests.BasicQueryTest.testQueryOnWidgets(BasicQueryTest.java:108)
Error testQueryOnInterfaceFields
Cannot perform operation "cast to org.jpox.samples.widget.DateWidget" on ReferenceExpression "THIS.CLONEABLE_WIDGET_WIDGET_ID_EID"
javax.jdo.JDOUserException: Cannot perform operation "cast to org.jpox.samples.widget.DateWidget" on ReferenceExpression "THIS.CLONEABLE_WIDGET_WIDGET_ID_EID" at org.jpox.jdo.JPOXJDOHelper.getJDOExceptionForJPOXException(JPOXJDOHelper.java:354) at org.jpox.jdo.JDOQuery.execute(JDOQuery.java:228) at org.jpox.tests.BasicQueryTest.queryOwnerWidgetInterfaces(BasicQueryTest.java:1907) at org.jpox.tests.BasicQueryTest.testQueryOnInterfaceFields(BasicQueryTest.java:208) 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 "cast to org.jpox.samples.widget.DateWidget" on ReferenceExpression "THIS.CLONEABLE_WIDGET_WIDGET_ID_EID" org.jpox.store.expression.ScalarExpression$IllegalOperationException: Cannot perform operation "cast to org.jpox.samples.widget.DateWidget" on ReferenceExpression "THIS.CLONEABLE_WIDGET_WIDGET_ID_EID" at org.jpox.store.expression.ScalarExpression.cast(ScalarExpression.java:641) at org.jpox.store.expression.ReferenceExpression.cast(ReferenceExpression.java:66) at org.jpox.store.rdbms.query.JDOQLQuery$Compiler.compileCastExpression(JDOQLQuery.java:1384) at org.jpox.store.rdbms.query.JDOQLQuery$Compiler.compileUnaryExpressionNotPlusMinus(JDOQLQuery.java:1368) at org.jpox.store.rdbms.query.JDOQLQuery$Compiler.compileUnaryExpression(JDOQLQuery.java:1351) at org.jpox.store.rdbms.query.JDOQLQuery$Compiler.compileMultiplicativeExpression(JDOQLQuery.java:1304) at org.jpox.store.rdbms.query.JDOQLQuery$Compiler.compileAdditiveExpression(JDOQLQuery.java:1281) at org.jpox.store.rdbms.query.JDOQLQuery$Compiler.compileRelationalExpression(JDOQLQuery.java:1241) at org.jpox.store.rdbms.query.JDOQLQuery$Compiler.compileEqualityExpression(JDOQLQuery.java:1213) at org.jpox.store.rdbms.query.JDOQLQuery$Compiler.compileAndExpression(JDOQLQuery.java:1201) at org.jpox.store.rdbms.query.JDOQLQuery$Compiler.compileExclusiveOrExpression(JDOQLQuery.java:1189) at org.jpox.store.rdbms.query.JDOQLQuery$Compiler.compileInclusiveOrExpression(JDOQLQuery.java:1177) at org.jpox.store.rdbms.query.JDOQLQuery$Compiler.compileConditionalAndExpression(JDOQLQuery.java:1165) at org.jpox.store.rdbms.query.JDOQLQuery$Compiler.compileConditionalOrExpression(JDOQLQuery.java:1147) at org.jpox.store.rdbms.query.JDOQLQuery$Compiler.compileExpression(JDOQLQuery.java:1124) at org.jpox.store.rdbms.query.JDOQLQuery$Compiler.compilePrimary(JDOQLQuery.java:1405) at org.jpox.store.rdbms.query.JDOQLQuery$Compiler.compileUnaryExpressionNotPlusMinus(JDOQLQuery.java:1370) at org.jpox.store.rdbms.query.JDOQLQuery$Compiler.compileUnaryExpression(JDOQLQuery.java:1351) at org.jpox.store.rdbms.query.JDOQLQuery$Compiler.compileMultiplicativeExpression(JDOQLQuery.java:1304) at org.jpox.store.rdbms.query.JDOQLQuery$Compiler.compileAdditiveExpression(JDOQLQuery.java:1281) at org.jpox.store.rdbms.query.JDOQLQuery$Compiler.compileRelationalExpression(JDOQLQuery.java:1241) at org.jpox.store.rdbms.query.JDOQLQuery$Compiler.compileEqualityExpression(JDOQLQuery.java:1213) at org.jpox.store.rdbms.query.JDOQLQuery$Compiler.compileAndExpression(JDOQLQuery.java:1201) at org.jpox.store.rdbms.query.JDOQLQuery$Compiler.compileExclusiveOrExpression(JDOQLQuery.java:1189) at org.jpox.store.rdbms.query.JDOQLQuery$Compiler.compileInclusiveOrExpression(JDOQLQuery.java:1177) at org.jpox.store.rdbms.query.JDOQLQuery$Compiler.compileConditionalAndExpression(JDOQLQuery.java:1165) at org.jpox.store.rdbms.query.JDOQLQuery$Compiler.compileConditionalOrExpression(JDOQLQuery.java:1147) at org.jpox.store.rdbms.query.JDOQLQuery$Compiler.compileExpression(JDOQLQuery.java:1124) at org.jpox.store.rdbms.query.JDOQLQuery$Compiler.compileExpressionFromString(JDOQLQuery.java:1085) at org.jpox.store.rdbms.query.JDOQLQuery$Compiler.compileFilter(JDOQLQuery.java:924) at org.jpox.store.rdbms.query.JDOQLQuery$Compiler.performCompile(JDOQLQuery.java:547) at org.jpox.store.rdbms.query.JDOQLQuery$Compiler.executionCompile(JDOQLQuery.java:520) at org.jpox.store.rdbms.query.JDOQLQuery.performExecute(JDOQLQuery.java:261) at org.jpox.store.query.Query.executeWithMap(Query.java:1037) at org.jpox.store.query.Query.executeWithArray(Query.java:986) at org.jpox.store.query.Query.execute(Query.java:921) at org.jpox.jdo.JDOQuery.execute(JDOQuery.java:223) at org.jpox.tests.BasicQueryTest.queryOwnerWidgetInterfaces(BasicQueryTest.java:1907) at org.jpox.tests.BasicQueryTest.testQueryOnInterfaceFields(BasicQueryTest.java:208)
Error testQueryOnObjectFields
Error executing JDOQL query "SELECT 'org.jpox.samples.widget.OwnerWidget' AS JPOXMETADATA,THIS.OWNERWIDGET_ID FROM OWNERWIDGET THIS LEFT OUTER JOIN DATEWIDGET THIS_DATEWIDGET ON THIS_DATEWIDGET.DATEWIDGET_ID = THIS.TEST_OBJECT WHERE (THIS_DATEWIDGET.DATE_FIELD) IS NOT NULL AND THIS_DATEWIDGET.DATE_FIELD > ?" : Wrong data type: For input string: "aced00057372001e6f72672e6a706f782e73616d706c65732e7769646765742e57696467657429bdfaa9a2501af103000c5a000c626f6f6c65616e4669656c64420009627974654669656c64430009636861724669656c64490008696e744669656c644a00096c6f6e674669656c6453000a73686f72744669656c644c000f626f6f6c65616e4f626a4669656c647400134c6a6176612f6c616e672f426f6f6c65616e3b4c000c627974654f626a4669656c647400104c6a6176612f6c616e672f427974653b4c000c636861724f626a4669656c647400154c6a6176612f6c616e672f4368617261637465723b4c000b696e744f626a4669656c647400134c6a6176612f6c616e672f496e74656765723b4c000c6c6f6e674f626a4669656c647400104c6a6176612f6c616e672f4c6f6e673b4c000d73686f72744f626a4669656c647400114c6a6176612f6c616e672f53686f72743b787001b7007b22b6790db3e0e57e1868360a7bb0707372000e6a6176612e6c616e672e427974659c4e6084ee50f51c02000142000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b02000078704b737200136a6176612e6c616e672e436861726163746572348b47d96b1a267802000143000576616c756578700067737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c75657871007e000941b15bdd7372000e6a6176612e6c616e672e4c6f6e673b8be490cc8f23df0200014a000576616c75657871007e0009734560694ba877657372000f6a6176612e6c616e672e53686f7274684d37133460da5202000153000576616c75657871007e00094cc778" in statement [SELECT 'org.jpox.samples.widget.OwnerWidget' AS JPOXMETADATA,THIS.OWNERWIDGET_ID FROM OWNERWIDGET THIS LEFT OUTER JOIN DATEWIDGET THIS_DATEWIDGET ON THIS_DATEWIDGET.DATEWIDGET_ID = THIS.TEST_OBJECT WHERE (THIS_DATEWIDGET.DATE_FIELD) IS NOT NULL AND THIS_DATEWIDGET.DATE_FIELD > ?].
javax.jdo.JDODataStoreException: Error executing JDOQL query "SELECT 'org.jpox.samples.widget.OwnerWidget' AS JPOXMETADATA,THIS.OWNERWIDGET_ID FROM OWNERWIDGET THIS LEFT OUTER JOIN DATEWIDGET THIS_DATEWIDGET ON THIS_DATEWIDGET.DATEWIDGET_ID = THIS.TEST_OBJECT WHERE (THIS_DATEWIDGET.DATE_FIELD) IS NOT NULL AND THIS_DATEWIDGET.DATE_FIELD > ?" : Wrong data type: For input string: "aced00057372001e6f72672e6a706f782e73616d706c65732e7769646765742e57696467657429bdfaa9a2501af103000c5a000c626f6f6c65616e4669656c64420009627974654669656c64430009636861724669656c64490008696e744669656c644a00096c6f6e674669656c6453000a73686f72744669656c644c000f626f6f6c65616e4f626a4669656c647400134c6a6176612f6c616e672f426f6f6c65616e3b4c000c627974654f626a4669656c647400104c6a6176612f6c616e672f427974653b4c000c636861724f626a4669656c647400154c6a6176612f6c616e672f4368617261637465723b4c000b696e744f626a4669656c647400134c6a6176612f6c616e672f496e74656765723b4c000c6c6f6e674f626a4669656c647400104c6a6176612f6c616e672f4c6f6e673b4c000d73686f72744f626a4669656c647400114c6a6176612f6c616e672f53686f72743b787001b7007b22b6790db3e0e57e1868360a7bb0707372000e6a6176612e6c616e672e427974659c4e6084ee50f51c02000142000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b02000078704b737200136a6176612e6c616e672e436861726163746572348b47d96b1a267802000143000576616c756578700067737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c75657871007e000941b15bdd7372000e6a6176612e6c616e672e4c6f6e673b8be490cc8f23df0200014a000576616c75657871007e0009734560694ba877657372000f6a6176612e6c616e672e53686f7274684d37133460da5202000153000576616c75657871007e00094cc778" in statement [SELECT 'org.jpox.samples.widget.OwnerWidget' AS JPOXMETADATA,THIS.OWNERWIDGET_ID FROM OWNERWIDGET THIS LEFT OUTER JOIN DATEWIDGET THIS_DATEWIDGET ON THIS_DATEWIDGET.DATEWIDGET_ID = THIS.TEST_OBJECT WHERE (THIS_DATEWIDGET.DATE_FIELD) IS NOT NULL AND THIS_DATEWIDGET.DATE_FIELD > ?]. at org.jpox.jdo.JPOXJDOHelper.getJDOExceptionForJPOXException(JPOXJDOHelper.java:289) at org.jpox.jdo.JDOQuery.execute(JDOQuery.java:228) at org.jpox.tests.BasicQueryTest.queryOwnerWidgetObjects(BasicQueryTest.java:1832) at org.jpox.tests.BasicQueryTest.testQueryOnObjectFields(BasicQueryTest.java:223) 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: Wrong data type: For input string: "aced00057372001e6f72672e6a706f782e73616d706c65732e7769646765742e57696467657429bdfaa9a2501af103000c5a000c626f6f6c65616e4669656c64420009627974654669656c64430009636861724669656c64490008696e744669656c644a00096c6f6e674669656c6453000a73686f72744669656c644c000f626f6f6c65616e4f626a4669656c647400134c6a6176612f6c616e672f426f6f6c65616e3b4c000c627974654f626a4669656c647400104c6a6176612f6c616e672f427974653b4c000c636861724f626a4669656c647400154c6a6176612f6c616e672f4368617261637465723b4c000b696e744f626a4669656c647400134c6a6176612f6c616e672f496e74656765723b4c000c6c6f6e674f626a4669656c647400104c6a6176612f6c616e672f4c6f6e673b4c000d73686f72744f626a4669656c647400114c6a6176612f6c616e672f53686f72743b787001b7007b22b6790db3e0e57e1868360a7bb0707372000e6a6176612e6c616e672e427974659c4e6084ee50f51c02000142000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b02000078704b737200136a6176612e6c616e672e436861726163746572348b47d96b1a267802000143000576616c756578700067737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c75657871007e000941b15bdd7372000e6a6176612e6c616e672e4c6f6e673b8be490cc8f23df0200014a000576616c75657871007e0009734560694ba877657372000f6a6176612e6c616e672e53686f7274684d37133460da5202000153000576616c75657871007e00094cc778" in statement [SELECT 'org.jpox.samples.widget.OwnerWidget' AS JPOXMETADATA,THIS.OWNERWIDGET_ID FROM OWNERWIDGET THIS LEFT OUTER JOIN DATEWIDGET THIS_DATEWIDGET ON THIS_DATEWIDGET.DATEWIDGET_ID = THIS.TEST_OBJECT WHERE (THIS_DATEWIDGET.DATE_FIELD) IS NOT NULL AND THIS_DATEWIDGET.DATE_FIELD > ?] at org.hsqldb.jdbc.Util.throwError(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.executeQuery(Unknown Source) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:91) at org.jpox.store.rdbms.ParamLoggingPreparedStatement.executeQuery(ParamLoggingPreparedStatement.java:345) at org.jpox.store.rdbms.SQLController.executeStatementQuery(SQLController.java:436) at org.jpox.store.rdbms.query.SQLEvaluator.evaluate(SQLEvaluator.java:114) at org.jpox.store.rdbms.query.JDOQLQuery.performExecute(JDOQLQuery.java:330) at org.jpox.store.query.Query.executeWithMap(Query.java:1037) at org.jpox.store.query.Query.executeWithArray(Query.java:986) at org.jpox.store.query.Query.execute(Query.java:921) at org.jpox.jdo.JDOQuery.execute(JDOQuery.java:223) at org.jpox.tests.BasicQueryTest.queryOwnerWidgetObjects(BasicQueryTest.java:1832) at org.jpox.tests.BasicQueryTest.testQueryOnObjectFields(BasicQueryTest.java:223)
Error testCircularViewDependencies
An exception was thrown while adding/validating class(es) : Table not found in statement [ SELECT WIDGET.WIDGET_ID, CIRCULARREFERENCEVIEW3.MY_INT FROM WIDGET INNER JOIN CIRCULARREFERENCEVIEW3] java.sql.SQLException: Table not found in statement [ SELECT WIDGET.WIDGET_ID, CIRCULARREFERENCEVIEW3.MY_INT FROM WIDGET INNER JOIN CIRCULARREFERENCEVIEW3] at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:194) at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:680) at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:636) at org.jpox.store.rdbms.table.AbstractTable.create(AbstractTable.java:347) at org.jpox.store.rdbms.table.AbstractTable.exists(AbstractTable.java:395) at org.jpox.store.rdbms.RDBMSManager$ClassAdder.performViewsValidation(RDBMSManager.java:3687) at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:3342) at org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2956) at org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.java:2835) at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:847) at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:814) at org.jpox.tests.JPOXPersistenceTestCase.addClassesToSchema(JPOXPersistenceTestCase.java:95) at org.jpox.tests.ViewTest.testCircularViewDependencies(ViewTest.java:409) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at junit.framework.TestCase.runTest(TestCase.java:154) at org.jpox.tests.ViewTest.runTest(ViewTest.java:104) at junit.framework.TestCase.runBare(TestCase.java:127) at junit.framework.TestResult$1.protect(TestResult.java:106) at junit.framework.TestResult.runProtected(TestResult.java:124) at junit.framework.TestResult.run(TestResult.java:109) at junit.framework.TestCase.run(TestCase.java:118) at junit.framework.TestSuite.runTest(TestSuite.java:208) at junit.framework.TestSuite.run(TestSuite.java:203) at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.run(JUnitTestRunner.java:325) at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.main(JUnitTestRunner.java:536)
An exception was thrown while adding/validating class(es) : Table not found in statement [ SELECT WIDGET.WIDGET_ID, CIRCULARREFERENCEVIEW3.MY_INT FROM WIDGET INNER JOIN CIRCULARREFERENCEVIEW3] java.sql.SQLException: Table not found in statement [ SELECT WIDGET.WIDGET_ID, CIRCULARREFERENCEVIEW3.MY_INT FROM WIDGET INNER JOIN CIRCULARREFERENCEVIEW3] at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:194) at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:680) at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:636) at org.jpox.store.rdbms.table.AbstractTable.create(AbstractTable.java:347) at org.jpox.store.rdbms.table.AbstractTable.exists(AbstractTable.java:395) at org.jpox.store.rdbms.RDBMSManager$ClassAdder.performViewsValidation(RDBMSManager.java:3687) at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:3342) at org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2956) at org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.java:2835) at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:847) at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:814) at org.jpox.tests.JPOXPersistenceTestCase.addClassesToSchema(JPOXPersistenceTestCase.java:95) at org.jpox.tests.ViewTest.testCircularViewDependencies(ViewTest.java:409) 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.tests.ViewTest.runTest(ViewTest.java:104) org.jpox.exceptions.JPOXDataStoreException: An exception was thrown while adding/validating class(es) : Table not found in statement [ SELECT WIDGET.WIDGET_ID, CIRCULARREFERENCEVIEW3.MY_INT FROM WIDGET INNER JOIN CIRCULARREFERENCEVIEW3] java.sql.SQLException: Table not found in statement [ SELECT WIDGET.WIDGET_ID, CIRCULARREFERENCEVIEW3.MY_INT FROM WIDGET INNER JOIN CIRCULARREFERENCEVIEW3] at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:194) at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:680) at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:636) at org.jpox.store.rdbms.table.AbstractTable.create(AbstractTable.java:347) at org.jpox.store.rdbms.table.AbstractTable.exists(AbstractTable.java:395) at org.jpox.store.rdbms.RDBMSManager$ClassAdder.performViewsValidation(RDBMSManager.java:3687) at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:3342) at org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2956) at org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.java:2835) at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:847) at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:814) at org.jpox.tests.JPOXPersistenceTestCase.addClassesToSchema(JPOXPersistenceTestCase.java:95) at org.jpox.tests.ViewTest.testCircularViewDependencies(ViewTest.java:409) 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.tests.ViewTest.runTest(ViewTest.java:104) at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:3356) at org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2956) at org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.java:2835) at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:847) at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:814) at org.jpox.tests.JPOXPersistenceTestCase.addClassesToSchema(JPOXPersistenceTestCase.java:95) at org.jpox.tests.ViewTest.testCircularViewDependencies(ViewTest.java:409) 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.tests.ViewTest.runTest(ViewTest.java:104) Caused by: java.sql.SQLException: Table not found in statement [ SELECT WIDGET.WIDGET_ID, CIRCULARREFERENCEVIEW3.MY_INT FROM WIDGET INNER JOIN CIRCULARREFERENCEVIEW3] at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:194) at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:680) at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:636) at org.jpox.store.rdbms.table.AbstractTable.create(AbstractTable.java:347) at org.jpox.store.rdbms.table.AbstractTable.exists(AbstractTable.java:395) at org.jpox.store.rdbms.RDBMSManager$ClassAdder.performViewsValidation(RDBMSManager.java:3687) at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:3342) ... 21 more Nested Throwables StackTrace: java.sql.SQLException: Table not found in statement [ SELECT WIDGET.WIDGET_ID, CIRCULARREFERENCEVIEW3.MY_INT FROM WIDGET INNER JOIN CIRCULARREFERENCEVIEW3] at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:194) at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:680) at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:636) at org.jpox.store.rdbms.table.AbstractTable.create(AbstractTable.java:347) at org.jpox.store.rdbms.table.AbstractTable.exists(AbstractTable.java:395) at org.jpox.store.rdbms.RDBMSManager$ClassAdder.performViewsValidation(RDBMSManager.java:3687) at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:3342) at org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2956) at org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.java:2835) at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:847) at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:814) at org.jpox.tests.JPOXPersistenceTestCase.addClassesToSchema(JPOXPersistenceTestCase.java:95) at org.jpox.tests.ViewTest.testCircularViewDependencies(ViewTest.java:409)
Failure testBasicConcurrency
expected:<700> but was:<900>
junit.framework.AssertionFailedError: expected:<700> but was:<900> at org.jpox.tests.ConcurrencyTest.testBasicConcurrency(ConcurrencyTest.java:96)
Failure testBasicConcurrencyExtraPM
expected:<700> but was:<800>
junit.framework.AssertionFailedError: expected:<700> but was:<800> at org.jpox.tests.ConcurrencyTest.testBasicConcurrencyExtraPM(ConcurrencyTest.java:149)