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
