prefetch & many-to-many

From: Tore Halset (halse..vv.ntnu.no)
Date: Fri Nov 07 2003 - 04:31:12 EST

  • Next message: Tore Halset: "one app, two db types?"

    Hello!

    DB-relation:
    Group<-->>GroupHasElement<<-->Element

    OO-relation (flattened relationship):
    Group<<-->>Element

    I want to query for all groups and prefetch elements, but the prefetch
    does not happen

    SelectQuery query = new SelectQuery(Group.class);
    query.addPrefetch("elements");
    List groups = dataContext.performQuery(query);

    Result in one query on group and lots of queries on element. Am I doing
    anything wrong?

     - Tore.

    This archive was generated by hypermail 2.0.0 : Fri Nov 07 2003 - 04:31:15 EST