We're just starting to use JBoss and are trying to determine how to handle the O/R layer. I was happy to see that JBoss can handle the N+1 query problem with 'eager load' field set in deployment descriptor. We'd like to avoid using BMP and instead use CMP. For many relationships, we can use CMP. But can any of the vendors support the following (or, does the 2.0 spec provide any help)? I have the following: Table A columns: a, b, c, d, e (a is primary key) Table B columns: a, w, x, y (a is foreign key) select a, b, c, d, e, w, x, y from A, B where A.a = B.a and A.b IN (...) The problem is: I would like to specify a variable-sized collection of Strings as the argument to my ejbFind() method and have each one substituted in the IN clause (because the collection is variable length, I can't specify the exact number of parms). I can't specify this in the query in the deployment descriptor, right? Can cocobase or toplink or javlin handle this (I have yet to look into these products)? Thanks, Bill Leonard =========================================================================== 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".
