It seems to me that Orion does not yet support EJB-QL neither EJB 2.0 many-to-many relationships. However, if you are interested in EJB 2.0 and finders, you may have a look at http://www.orionsupport.com/. Giustino De Vincentiis -----Messaggio originale----- Da: Marc Rabil [mailto:[EMAIL PROTECTED]] Inviato: giovedì 15 febbraio 2001 16.08 A: Orion-Interest Oggetto: EJB 2.0 It's not clear looking through the documentation how much of EJB 2.0 Orion currently supports. Specifically, I am interested in using CMP and EJB QL to do advanced queries of a multi-table database. Best I can understand the current technology, I have 2 choices: 1) use findAll() a lot and combine the results in Java code or 2) bypass CMP and write my own SQL statements. Any help/insight will be greatly appreciated. Marc Rabil
