DevForce Community Forum : How does IdeaBlade handle Identity columns http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce Classic : How does IdeaBlade handle Identity columns Sat, 11 Apr 2026 04:13:00 -700 Thu, 12 Jul 2007 15:48:23 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=212 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ How does IdeaBlade handle Identity columns : Identity columns pose a special... http://www.ideablade.com/forum/forum_posts.asp?TID=212&PID=465#465 Author: IdeaBlade
Subject: 212
Posted: 12-Jul-2007 at 3:48pm

Identity columns pose a special problem for IdeaBlade. When a business object that uses an identity column is first created, it is assigned a negative temporary id. Only when the business object gets saved to the database, does the database assign the business object its permanent id. The difficulty with this is that if the PersistenceManager wants to refetch the entity, it doesn't know what permanent id to use.

Devforce solves this problem with a clever approach. Rather than having the database assign the permanent id, we assign it ourselves. We do this be creating a "hole" in the id space. If the last number used by the id generator was 1356 (for example), we create a range of ids from 1357 to 1367 that we own and can't be used by any other user.

The Object Mapper is fully aware of Identity columns.

]]> Thu, 12 Jul 2007 15:48:23 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=212&PID=465#465 How does IdeaBlade handle Identity columns : I would just like to ask about... http://www.ideablade.com/forum/forum_posts.asp?TID=212&PID=464#464 Author: Customer
Subject: 212
Posted: 12-Jul-2007 at 3:47pm

I would just like to ask about how the IdeaBlade handles Identity columns (AutoGenerated Numbers) set on the DB Table?

Does the OR Mapper detect this?

]]> Thu, 12 Jul 2007 15:47:46 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=212&PID=464#464