Re: Re: SQLTemplate and setPageSize()

2008-08-07 Thread Jens Mayer
additional information which is lost after setting the root. > Care to log a bug report in Jira? never done that before, but I'll do my very best... ;-) Jens Original-Nachricht ---- Betreff: Re: SQLTemplate and setPageSize() Datum: Wed, 6 Aug 2008 11:26:00 -0400 Von:

Re: SQLTemplate and setPageSize()

2008-08-06 Thread Andrus Adamchik
On Aug 6, 2008, at 11:26 AM, Andrus Adamchik wrote: Not quite sure why the root is null. Actually I have a few suspicions why this is happenning, and this may be a bug. Care to log a bug report in Jira? https://issues.apache.org/cayenne/ In the meantime you can use a workaround:

Re: SQLTemplate and setPageSize()

2008-08-06 Thread Andrus Adamchik
Hi Jens, Not quite sure why the root is null. So is named query mapped via the Modeler or do you add it in the code? As an aside (this may have nothing to do with your problem), all mapped queries are shared across DataContexts, so you may have a race condition when you attempt to modify

SQLTemplate and setPageSize()

2008-08-06 Thread Jens Mayer
Hi, i'm using Cayenne 2.0.4 with Oracle 10 and JDK 1.5. Please have a short look at this code: ... dataCtx, myID are set... SQLTemplate rawQuery = (SQLTemplate)dataCtx.getEntityResolver().lookupQuery("myQuery"); Map params = new HashMap(); params.put("processID", myID); rawQuery.setParameters