I might be jumping in a little late, but we also have a data abstraction layer or schema. We have an abstract schema, which all other schemas inherit from. We have Abstract_Schema, SQL2000_Schema, Oracle_Schema, Access_Schema, QuerySim_Schema, etc. The reason we have specialized schemas inherit from the abstract schema, is to allow all our DAOs (which handle all calls to the schema), to be composed of a more generalized schema (Schema_Abstract) which makes for easy schema swapping.
The DAOs and Controller handle all business logic, validation, etc. All calls to the schemas require the same data (structs, or beans) so that the persisting logic, unique to each dB, is handled within their respective schema, hiding that processing from the application itself. UML Below <<...OLE_Obj...>> ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED]
