DevForce Community Forum : Default PersistenceOrder wrong http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce Classic : Default PersistenceOrder wrong Wed, 13 May 2026 18:03:57 -700 Sun, 08 Jun 2008 09:43:04 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=832 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Default PersistenceOrder wrong : Do you have the relationships... http://www.ideablade.com/forum/forum_posts.asp?TID=832&PID=3047#3047 Author: davidklitzke
Subject: 832
Posted: 08-Jun-2008 at 9:43am

Do you have the relationships between tables from the two differenves databases defined in the Object Mapper.  That could explain your problem.  If you only have the relationships defined for tables in the same database, the DevForce Framework can't possibly get the Persistence Order correct.  Look at the Advanced Tutorial on "Working with Multiple Databases" for an example.

 

]]> Sun, 08 Jun 2008 09:43:04 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=832&PID=3047#3047 Default PersistenceOrder wrong : Could it be because we are using... http://www.ideablade.com/forum/forum_posts.asp?TID=832&PID=3046#3046 Author: lokheed
Subject: 832
Posted: 08-Jun-2008 at 8:55am

Could it be because we are using two different databases (both are on the same server)? 

The majority of the application uses something like PrimaryDB but the business objects I am having trouble with are all in CustomModuleDB.  So CustomModuleDB.dbo.Foo.BarID is a fk constraint to PrimaryDB.dbo.Bar.BarID, and then then there are several tables in CustomModuleDB that have foreign key constraints to CustomModuleDB.dbo.Foo.FooID.  What I am seeing is that all of the business objects generated from PrimaryDB are sorted properly, it's the business objects from CustomModuleDB that tend to get out of order. I don't have the option to migrate the tables from CustomModuleDB into PrimaryModuleDB.

What I will try is to run a topological sort on just the business objects from CustomModuleDB within the list, leaving all of the business objects from PrimaryDB in their relative order.
]]> Sun, 08 Jun 2008 08:55:35 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=832&PID=3046#3046 Default PersistenceOrder wrong : DevForceuses a Reverse Topological... http://www.ideablade.com/forum/forum_posts.asp?TID=832&PID=3045#3045 Author: davidklitzke
Subject: 832
Posted: 08-Jun-2008 at 8:23am

DevForce  uses a Reverse Topological sort to calculate a default Persistence Order.  Occasionally, we hear complaints that the order is not always correct.  After an in-depth analysis of these cases, we have found a couple of contributing causes:  

(1)  There are too many relationships and/or some contradictory relationships and  the problem cannot really be solved.  Simplifying the relationships and reducing the number of relationships can sometimes help.

(2) There are too few and/or missing relationships.  A good example occurs with grandparent-parent-child relationships.  Sometimes the relationship between grandparent and child is not declared and the missing relationship shows up as an apparent persistence order problem. 

In most cases, we find that subtracting relationships or adding missing relationships can solve the problem.  .

I am not saying that there is a better solution to your problem, but we might be able to help you if you could give us a specific example.

 

]]> Sun, 08 Jun 2008 08:23:08 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=832&PID=3045#3045 Default PersistenceOrder wrong : In our installation, when persisting... http://www.ideablade.com/forum/forum_posts.asp?TID=832&PID=3044#3044 Author: lokheed
Subject: 832
Posted: 07-Jun-2008 at 6:46am

In our installation, when persisting new objects to the db in which there are foreign key constraints, it seems that regularly the PersistenceManager.DefaultSaveOptions.PersistenceOrder is not taking those foreign key constraints into consideration when creating the list.  This means that I have had to create a method that casts the PersistenceOrder into a Type array, manually sort the items in that array to take those constraints into account, and then call PersistenceManager.DefaultSaveOptions.SetPersistenceOrder() with the corrected Type array.

My question is, should I really have to do that?  Is there some step or setting I am missing that is causing the persistence manager to not automatically notice those constraints?
]]> Sat, 07 Jun 2008 06:46:20 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=832&PID=3044#3044