Hi, a criteria with path expressions like in the OJB queries reference guide example (http://db.apache.org/ojb/docu/guides/query.html#Query+by+Criteria) does not work for me with broker.deleteByQuery(q). Using Microsoft SQL Server, the resulting statement of the example
Criteria crit = new Criteria(); crit.addEqualTo("productGroup.groupName", "Liquors"); Query q = QueryFactory.newQuery(Article.class, crit); Collection results = broker.getCollectionByQuery(q); results in the correct JOIN in the SELECT statement, but using: broker.deleteByQuery(q); results in a statement, where the path expression ist not expanded but the statement executed is something like DELETE FROM Artikel WHERE KategorieName='Liquors' but I expected something like DELETE FROM Artikel WHERE Kategorie_Nr IN (SELECT Kategorie_Nr FROM Kategorien WHERE KategorieName='Liquors') Any hints? Mit freundlichen Grüßen i.A. Bernd Längerich -- www.actosoft.de - Key Solutions for Retail - ++++ ac news ++++ Marktgeflüster ++++ ac news ++++ Marktgeflüster ++++ Smarter Fashion - neue Geschäftsmodelle und integrierte Lösungen für die Fashion Value Chain +++ Das Seminar am 12.09.2006 im Zeughaus Neuss +++ Weitere Infos unter: www.microsoft.com/germany/events/fashion __________________________________________________________________________________________ act'o-soft GmbH Informationssysteme * Enger Str. 12 * D-33824 Werther (Westf.) Tel.: +49-5203-9744-40 * Fax: +49-5203-9744-41 * eMail: [EMAIL PROTECTED] Sitz der Gesellschaft ist Werther (Westf.) * Amtsgericht Gütersloh * HRB 5242 Geschäftsführer: Christian Malachowski * Dipl.-Ing. Michael Schramm ___________________________________________________________________________________________ ___________________________________________________________________________________________ This e-mail including any attachments may contain information that is legally privileged and confidential. It constitutes non-public information intended to be conveyed only to the designated recipient(s). If you are not an intended recipient please delete this e-mail and any attachments and do not read, copy, or retransmit it and please notify act'o-soft GmbH by return mail, e-mail or at +49/5203/974440. The unauthorized use, dissemination, distribution or reproduction of this e-mail, including attachments, is prohibited and may be unlawful. ___________________________________________________________________________________________ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]