We've requirement that the record in the table can't be deleted physically. I've implemented the business concept as CMP bean and I came across this new req.
Also, If I need to provide a "where" clause as part of my select, how would I do that with CMP ?
Thanks in advance,
where ever you want to do these logical delete operations, in your CMP, use the any of ejbCreate, ejbPostCreate, ejbLoad, etc methods. They are given for such kind of operations only. As such we dont touch them in CMP untill or unless required.