On May 23, 2012, at 6:53 PM, Adam Heath wrote: >> >> 1) modify the sql to use SequenceValueItem or another entity declared in the >> same component (or, less ideally, another framework component like "commons") > > DBCPConnectionFactory is in framework/entity; having it require a > framework/entity/entitymodel seems the safest approach.
I agree; what if we use: select count(testing_type_id) from testing_type where testing_type_id = 'ABC' ? that should always return one row with the 0 count; the entity is empty ootb (it is only used for automated tests) but the constraint on the pk should add an additional protection for efficiency. Jacopo