> All these "solutions" would be like a DBA telling people that they can't > issue a query against database, but can only do query through pre-defined > database views. Sorry, but this is ridiculous.
Whilst I've never been in this situation, I've heard many ppl say they've worked at places where thats exactly what happens - the DBA writes some PL/SQL, and the developer calls that. Isn't that exactly what finders are trying to replace? > What about the query statement? Should that be in EQL? Does EJB container > know how to map EQL to target DB during runtime? If not EQL, wouldn't the > application be not portable? How would you do this in something other than EJB? you'd basically have a way of constructing the SQL dynamically yes - like the findByStatement. > How would findByStatement work under CMP? the same as BMP as I understand it. THere's nothing to stop you writing your own finder method, all you need to do is return allt he primary keys found - rely on the container to do read-ahead optimization etc, and you have all the flexibility you need... cheers dim =========================================================================== To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff EJB-INTEREST". For general help, send email to [EMAIL PROTECTED] and include in the body of the message "help".
