Okay. Looks like the AccessStack is trying to use the pk auto table, but
because the map is configured to use the default pk strategy, the pg adapter
is looking to use the sequence. If this is in fact the case, Andrus, I'm
not sure why you aren't having any problems. Unless you had a DB from the
past. If you destroy you recreate your PG database, do the tests run for
you?
-- KevinOn Sun, Nov 23, 2008 at 8:24 PM, Kevin Menard <nirvdru..mail.com> wrote:
> Following up, it looks like some of the PK sequences are not being > generated for PostgreSQL. Still digging in. > -- > Kevin > > > > On Sun, Nov 23, 2008 at 7:48 PM, Kevin Menard <nirvdru..mail.com> wrote: > >> I'm still a bit early on in my testing. Apparently I let my hard drive >> get up 100%, so that was a lot of fun. >> Testing thus far: >> >> MacOS X 10.5.5 (Intel) >> >> HSQLDB: >> - No problems >> >> MySQL (5.0.67): >> Failed tests: >> test(org.apache.cayenne.merge.SetNotNullToDbTest) >> test(org.apache.cayenne.merge.SetAllowNullToDbTest) >> >> (Same as Andrus) >> >> PostgreSQL (8.3.1): >> 1 failure >> 83 errors >> >> Andrus, what version were you running? I'm getting a bunch of errors >> about particular relations not existing. The ones that are actually >> problems are: >> >> Failed tests: >> warning(junit.framework.TestSuite$1) >> >> Tests in error: >> testMultiDBUpdate(org.apache.cayenne.access.DataContextCrossDBTest) >> testQualifyOnToMany(org.apache.cayenne.unit.jira.CAY_194Test) >> testQualifyOnToOne(org.apache.cayenne.unit.jira.CAY_194Test) >> testUnregisterThenRegister(org.apache.cayenne.access.ObjectStoreTest) >> >> testRollbackRelationshipModification(org.apache.cayenne.remote.RemoteRollbackTest) >> testRollbackDeletedObject(org.apache.cayenne.remote.RemoteRollbackTest) >> testRollbackModifiedObject(org.apache.cayenne.remote.RemoteRollbackTest) >> >> testDeepMergeExistingSubclass(org.apache.cayenne.util.DeepMergeOperationInheritanceTest) >> >> testDeepMergeNonExistentSubclass(org.apache.cayenne.util.DeepMergeOperationInheritanceTest) >> testSave(org.apache.cayenne.access.InheritanceTest) >> testInsertSingle(org.apache.cayenne.GenericMappingTest) >> testInsertRelated(org.apache.cayenne.GenericMappingTest) >> testUpdateRelated(org.apache.cayenne.GenericMappingTest) >> >> testReturnDiffInPrePersist(org.apache.cayenne.remote.ClientChannelServerDiffsTest) >> >> testReturnDiffClientArcChanges(org.apache.cayenne.remote.ClientChannelServerDiffsTest) >> testReturnIdDiff(org.apache.cayenne.remote.ClientChannelServerDiffsTest) >> testCAY_207Save(org.apache.cayenne.unit.jira.CAY_207Test) >> testNullify(org.apache.cayenne.remote.RelationshipChangeTest) >> testChange(org.apache.cayenne.remote.RelationshipChangeTest) >> >> testPerformGeneratedQuery(org.apache.cayenne.gen.ClientDataMapGeneratedQueryRunTest) >> testFailLockingOnToOne(org.apache.cayenne.access.OptimisticLockingTest) >> testAddToMany(org.apache.cayenne.CDOMapRelationshipTest) >> testAddToManyViaReverse(org.apache.cayenne.CDOMapRelationshipTest) >> testInsert(org.apache.cayenne.access.EmbeddingTest) >> testAddToMany(org.apache.cayenne.CayenneContextMapRelationshipTest) >> testNullifyToOne(org.apache.cayenne.CayenneContextDeleteRulesTest) >> testCascadeToOne(org.apache.cayenne.CayenneContextDeleteRulesTest) >> testDenyToOne(org.apache.cayenne.CayenneContextDeleteRulesTest) >> >> testCascadeToOneNewObject(org.apache.cayenne.CayenneContextDeleteRulesTest) >> testDenyToOne(org.apache.cayenne.access.DeleteRulesTest) >> testNoActionToOne(org.apache.cayenne.access.DeleteRulesTest) >> testNoActionToMany(org.apache.cayenne.access.DeleteRulesTest) >> testNoActionFlattened(org.apache.cayenne.access.DeleteRulesTest) >> >> testNoActionFlattenedNoReverse(org.apache.cayenne.access.DeleteRulesTest) >> testCascadeFlattened(org.apache.cayenne.access.DeleteRulesTest) >> testCascadeFlattenedNoReverse(org.apache.cayenne.access.DeleteRulesTest) >> testNullifyFlattened(org.apache.cayenne.access.DeleteRulesTest) >> testNullifyFlattenedNoReverse(org.apache.cayenne.access.DeleteRulesTest) >> testDenyFlattened(org.apache.cayenne.access.DeleteRulesTest) >> testDenyFlattenedNoReverse(org.apache.cayenne.access.DeleteRulesTest) >> >> testMultipleSimpleProperties(org.apache.cayenne.CayenneContextGraphDiffCompressorTest) >> >> testComplimentaryArcs(org.apache.cayenne.CayenneContextGraphDiffCompressorTest) >> testDeletion(org.apache.cayenne.remote.CayenneContextDeletionTest) >> testOutParams(org.apache.cayenne.access.DataContextProcedureQueryTest) >> >> testCompareToNull(org.apache.cayenne.access.DataContextEJBQLIsNullTest) >> testValidate(org.apache.cayenne.CayenneContextValidationTest) >> >> testReturnDiffInPrePersist(org.apache.cayenne.CayenneContextServerDiffsTest) >> >> testReturnDiffInPreUpdate(org.apache.cayenne.CayenneContextServerDiffsTest) >> >> testReturnDiffClientArcChanges(org.apache.cayenne.CayenneContextServerDiffsTest) >> >> testReturnDiffServerArcChanges(org.apache.cayenne.CayenneContextServerDiffsTest) >> testReadRelationship(org.apache.cayenne.CDOOneToManyFKTest) >> testAddToMany(org.apache.cayenne.CDOSetRelationshipTest) >> testAddToManyViaReverse(org.apache.cayenne.CDOSetRelationshipTest) >> testCollectionMemberOfId(org.apache.cayenne.access.DataContextEJBQLConditionsPeopleTest) >> >> testCollectionNotMemberOfId(org.apache.cayenne.access.DataContextEJBQLConditionsPeopleTest) >> >> testCollectionNotMemberOfToOne(org.apache.cayenne.access.DataContextEJBQLConditionsPeopleTest) >> testInsertJoinWithPK(org.apache.cayenne.FlattenedRelationshipsTest) >> >> testQualifyOnToManyFlattened(org.apache.cayenne.FlattenedRelationshipsTest) >> >> testToOneSeriesFlattenedRel(org.apache.cayenne.FlattenedRelationshipsTest) >> testSynchronizeCommit(org.apache.cayenne.access.ClientServerChannelTest) >> >> testRollbackChanges(org.apache.cayenne.CayenneContextWithDataContextTest) >> >> testSelectPrimitives(org.apache.cayenne.CayenneContextWithDataContextTest) >> >> testCommitChangesPrimitives(org.apache.cayenne.CayenneContextWithDataContextTest) >> >> testPrePersistCallback(org.apache.cayenne.CayenneContextWithDataContextTest) >> >> testPrePersistOnObjectCallback(org.apache.cayenne.CayenneContextWithDataContextTest) >> >> testPreRemoveCallback(org.apache.cayenne.CayenneContextWithDataContextTest) >> testCAY830(org.apache.cayenne.CayenneContextWithDataContextTest) >> >> testOIDQueryInterception(org.apache.cayenne.CayenneContextWithDataContextTest) >> testAddToMany(org.apache.cayenne.CDOCollectionRelationshipTest) >> >> testAddToManyViaReverse(org.apache.cayenne.CDOCollectionRelationshipTest) >> testDelete(org.apache.cayenne.CDOOneToOneFKTest) >> testReadRelationship(org.apache.cayenne.CDOOneToOneFKTest) >> testNewAdd(org.apache.cayenne.CDOOneToOneFKTest) >> test2Null(org.apache.cayenne.CDOOneToOneFKTest) >> >> testTakeObjectSnapshotDependentFault(org.apache.cayenne.CDOOneToOneFKTest) >> testReplaceNull1(org.apache.cayenne.CDOOneToOneFKTest) >> testReplaceNull2(org.apache.cayenne.CDOOneToOneFKTest) >> >> testSyncNewObject(org.apache.cayenne.CayenneContextClientChannelEventsTest) >> >> testSyncNewDeletedObject(org.apache.cayenne.CayenneContextClientChannelEventsTest) >> >> testSyncNewObjectIntoDirtyContext(org.apache.cayenne.CayenneContextClientChannelEventsTest) >> >> testSyncToManyRelationship(org.apache.cayenne.CayenneContextClientChannelEventsTest) >> >> testSyncToManyRelationship1(org.apache.cayenne.CayenneContextClientChannelEventsTest) >> >> testSyncManyToManyRelationship1(org.apache.cayenne.CayenneContextClientChannelEventsTest) >> >> -- >> Kevin >> >> -- >> Kevin >> >> >> >> On Sat, Nov 22, 2008 at 10:51 AM, Andrus Adamchik <andru..bjectstyle.org >> > wrote: >> >>> >>> On Nov 21, 2008, at 3:27 PM, Andrus Adamchik wrote: >>> >>> * Saturday / Sunday - testing of the tagged code; committing fixes if >>>> needed. >>>> >>> >>> I'm done with this part on my end. Here is the test results (in short, a >>> few new cross-DB bugs introduced since M4 are fixed) : >>> >>> >>> hsqldb >>> (no failures) >>> >>> h2 >>> (no failures) >>> >>> derby >>> Tests in error: >>> >>> testDifferentEntity(org.apache.cayenne.access.DataContextEJBQLSubqueryTest) >>> testExists(org.apache.cayenne.access.DataContextEJBQLSubqueryTest) >>> testAddTable(org.apache.cayenne.merge.CreateTableToModelTest) >>> >>> >>> postgresql >>> Tests in error: >>> (CAY-1139) >>> testCompareToNull(org.apache.cayenne.access.DataContextEJBQLIsNullTest) >>> >>> mysql >>> Failed tests: >>> test(org.apache.cayenne.merge.SetNotNullToDbTest) >>> test(org.apache.cayenne.merge.SetAllowNullToDbTest) >>> >>> oracle >>> Failed tests: >>> test(org.apache.cayenne.merge.SetNotNullToDbTest) >>> testAddAndDropColumnToDb(org.apache.cayenne.merge.MergerFactoryTest) >>> testChangeVarcharSizeToDb(org.apache.cayenne.merge.MergerFactoryTest) >>> testMultipleTokensToDb(org.apache.cayenne.merge.MergerFactoryTest) >>> test(org.apache.cayenne.merge.SetAllowNullToDbTest) >>> >>> sqlserver >>> (no failures) >>> >>> >>> >> >
This archive was generated by hypermail 2.0.0 : Mon Nov 24 2008 - 21:46:30 EST