Re: complex query vs performIteratedQuery vs Prefetching

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Wed Nov 11 2009 - 08:01:03 EST

  • Next message: Hans Pikkemaat: "Object Caching"

    You may have done that already in the previous messages, but could you
    give a snip of your SQLTemplate creation code here (just to make sure
    I understand all the settings used in this specific case). And also if
    possible, SQL generated in the console for the initial query, and then
    for the failing page query?

    Thanks,
    Andrus

    On Nov 11, 2009, at 2:51 PM, Hans Pikkemaat wrote:

    > Hi,
    >
    > I tried 3.0b but without effect.
    >
    > If I use an SQLTemplate in combination with setPageSize I also get
    > the exception mentioned earlier:
    >
    > Exception in thread "main"
    > org.apache.cayenne.CayenneRuntimeException: [v.3.0B1 Nov 09 2009
    > 09:53:47] Some ObjectIds are missing from the database. Expected
    > 100, fetched 85
    > at
    > org
    > .apache
    > .cayenne
    > .access
    > .IncrementalFaultList
    > .checkPageResultConsistency(IncrementalFaultList.java:364)
    > at
    > org
    > .apache
    > .cayenne
    > .access
    > .IncrementalFaultList.resolveInterval(IncrementalFaultList.java:301)
    > at
    > org
    > .apache
    > .cayenne.access.IncrementalFaultList.get(IncrementalFaultList.java:
    > 550)
    > at org.apache.cayenne.access.IncrementalFaultList
    > $1.next(IncrementalFaultList.java:467)
    > at
    > com
    > .traserv
    > .incrementalsupply
    > .integration.demo.CayenneDemo.doit1(CayenneDemo.java:136)
    > at
    > com
    > .traserv
    > .incrementalsupply
    > .integration.demo.CayenneDemo.main(CayenneDemo.java:183)
    >
    > If I use a SelectQuery it works oke. But this is not an option for
    > me because I cannot construct
    > my query using SelectQuery because of its complexity.
    >
    > Any ideas?
    >
    > tx
    >
    > Hans

    This archive was generated by hypermail 2.0.0 : Wed Nov 11 2009 - 08:01:35 EST