I thought I'd share with the group that it appears possible to use JOIN's in
the finder methods of CMP entity beans. This is a great time saver! The spec
indicates that in the deployment descriptor, the:
<jdbc-where-clause>
should just contain a WHERE clause, such as:
<jdbc-where-clause>where Customer = ?</jdbc-where-clause>
However, I have found that appending a comma following by a series of
tables, then a WHERE clause with join conditions, works fine! This is great!
<jdbc-where-clause>,Orders where Customers.ID = Orders.CustomerID and
Orders.Type = ?</jdbc-where-clause>
So, in case this is un-intentional, I'd like to ask the JOnAS team to please
NOT break this in any future releases, and consider documenting it. It's
very useful!
Bryan
----
To unsubscribe, send email to [EMAIL PROTECTED] and
include in the body of the message "unsubscribe jonas-users".
For general help, send email to [EMAIL PROTECTED] and
include in the body of the message "help".
