RE: Locking records in DB2

["Paul Holm" <pholm@xxxxxxxxxxxxxxxxx>]

Joe,  

 

You are right, we have wondered off the thread of concurrency into OO
application design so I’ll stop with these thoughts.  

 

I think you may have made some premature assumptions.  Multi table Rows can
be updatable.   A JoinedRow has fields from multiple tables and the same
process applies for each table.  We require primary keys for all files be
present in the JoinedRow.  

 

Validation typically falls into generic and custom validation.  Generic
validation is done automatically and custom validation  (multi table cross
validation) is accomplished using subclassing and overriding the Row’s
validate method as is commonly done in frameworks.  This frees the
programmer of all the reoccurring validation and they only need to code for
custom validation.  This has been a huge time savings for us and scales from
small simple applications to large complex applications.  

 

I agree performance needs to be designed in as well.  In addition,
internally and also from a customer point of view, time is money, so we have
to develop with designs that yield high productivity, perhaps that is where
our opinions differ.  We will take productivity and flexibility and good
performance over a cycle here or there.  

 

Anyway my .02 

Paul Holm
Senior Web Architect
PlanetJ Corp. 

WOW, Web Applications In Under 5 Minutes
HYPERLINK "http://www.gotWebData.net"; \nhttp://www.gotWebData.net