2 Replies Latest reply on Mar 27, 2006 2:17 AM by Gregor Grambow

    Mass Data Association Mapping / Finding

    Gregor Grambow Newbie

      Hello again!

      I hava a problem with two tables in my database: they are connected via primary/foreign key. (its a warehouse with warehouse stock) i mapped it with the @onetomany Annotation in the warehouse.
      now i load one warehouse into memory (LAZY, far too many items in the stock table). but now i have to search one of these items. i cannot go through the whole collection because of the number of the items. and i cannot search for the item with ejbql because with the association mapping the dont have the warehouse ID mapped in.
      how could i do this?
      please help me!