Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cayenne.apache.org
Received-SPF: pass (herse.apache.org: domain of farocco@hotmail.com designates
 65.54.246.112 as permitted sender)
Message-ID: <BAY104-DAV15C33701577B95754ED385BA7A0@phx.gbl>
From: "Frank" <farocco@hotmail.com>
To: <user@cayenne.apache.org>
References: <BAY104-DAV138AA3CB471E5F34CFF11DBA7A0@phx.gbl>
 <C3A3651D-3D11-453C-93FE-B16104740606@pvv.ntnu.no>
 <BAY104-DAV568CE2370FF092B0E301EBA7A0@phx.gbl>
 <525d8e10703071408h777505b8o972b07b47d384eb@mail.gmail.com>
Subject: Re: Sort fails on setPageSize
Date: Wed, 7 Mar 2007 17:11:20 -0500
MIME-Version: 1.0
Content-Type: text/plain;
	format=flowed;
	charset="iso-8859-1";
	reply-type=response
Content-Transfer-Encoding: 7bit

Thanks Malcolm,
I did not realize you had an example that used cayenne.
Will the setPageSize solve my large database issue?

Frank
----- Original Message ----- 
From: "Malcolm Edgar" <malcolm.edgar@gmail.com>
To: <user@cayenne.apache.org>
Sent: Wednesday, March 07, 2007 5:08 PM
Subject: Re: Sort fails on setPageSize


> Hi Frank,
>
> for this scenario let the database do the ordering.
>
> Please see the click examples for a demonstration.
>
> regards Malcolm Edgar
>
> On 3/8/07, Frank <farocco@hotmail.com> wrote:
>> ok,
>>
>> I would need to look into what Click Framework is doing and see if I can
>> override this.
>>
>> Thanks
>>
>> Frank
>> ----- Original Message -----
>> From: "Tore Halset" <halset@pvv.ntnu.no>
>> To: <user@cayenne.apache.org>
>> Sent: Wednesday, March 07, 2007 4:59 PM
>> Subject: Re: Sort fails on setPageSize
>>
>>
>> > Hi,
>> >
>> > Would it be possible to reissue the query and let the database do the
>> > sorting? Otherwise sorting does not make sense before you have  fetched
>> > all of the data and then you do not need page size.
>> >
>> >  - Tore.
>> >
>> > On Mar 7, 2007, at 22:26, Frank wrote:
>> >
>> >> Hello,
>> >>
>> >> My sort works fine until I set the Page Size.
>> >>
>> >> I need to limit the records per page as I have 35000 in table.
>> >>
>> >> Thanks
>> >>
>> >> Frank
>> >>
>> >> query.setPageSize(50);
>> >>
>> >> causes this error:
>> >>
>> >> java.lang.UnsupportedOperationException: set operation not supported
>> >> at org.objectstyle.cayenne.access.IncrementalFaultList
>> >> $IncrementalListIterator.set(IncrementalFaultList.java:962)
>> >> at java.util.Collections.sort(Unknown Source)
>> >> at net.sf.click.control.Table.sortRowList(Table.java:1290)
>> >> at net.sf.click.control.Table.toString(Table.java:988)
>> >> at org.apache.velocity.runtime.parser.node.ASTReference.render
>> >> (ASTReference.java:336)
>> >> at org.apache.velocity.runtime.parser.node.SimpleNode.render
>> >> (SimpleNode.java:324)
>> >> at org.apache.velocity.runtime.directive.Parse.render(Parse.java:224)
>> >> at org.apache.velocity.runtime.parser.node.ASTDirective.render
>> >> (ASTDirective.java:136)
>> >> at org.apache.velocity.runtime.parser.node.SimpleNode.render
>> >> (SimpleNode.java:324)
>> >> at org.apache.velocity.Template.merge(Template.java:259)
>> >> at net.sf.click.ClickServlet.renderTemplate(ClickServlet.java:591)
>> >> at net.sf.click.ClickServlet.processPage(ClickServlet.java:535)
>> >> at net.sf.click.ClickServlet.handleRequest(ClickServlet.java:357)
>> >> at net.sf.click.ClickServlet.doGet(ClickServlet.java:280)
>> >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
>> >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>> >> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
>> >> (ApplicationFilterChain.java:252)
>> >> at org.apache.catalina.core.ApplicationFilterChain.doFilter
>> >> (ApplicationFilterChain.java:173)
>> >> at net.sf.click.extras.cayenne.DataContextFilter.doFilter
>> >> (DataContextFilter.java:125)
>> >> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
>> >> (ApplicationFilterChain.java:202)
>> >> at org.apache.catalina.core.ApplicationFilterChain.doFilter
>> >> (ApplicationFilterChain.java:173)
>> >> at org.apache.catalina.core.StandardWrapperValve.invoke
>> >> (StandardWrapperValvejava:213)
>> >> at org.apache.catalina.core.StandardContextValve.invoke
>> >> (StandardContextValvejava:178)
>> >> at org.apache.catalina.core.StandardHostValve.invoke
>> >> (StandardHostValve.java:126)
>> >> at org.apache.catalina.valves.ErrorReportValve.invoke
>> >> (ErrorReportValve.java:105)
>> >> at org.apache.catalina.core.StandardEngineValve.invoke
>> >> (StandardEngineValve.java:107)
>> >> at org.apache.catalina.connector.CoyoteAdapter.service
>> >> (CoyoteAdapter.java:148)
>> >> at org.apache.coyote.http11.Http11Processor.process
>> >> (Http11Processor.java:869)
>> >> at org.apache.coyote.http11.Http11BaseProtocol
>> >> $Http11ConnectionHandler.processConnection(Http11BaseProtocol.java: 
>> >> 664)
>> >> at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket
>> >> (PoolTcpEndpoint.java:527)
>> >> at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt
>> >> (LeaderFollowerWorkerThread.java:80)
>> >> at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run
>> >> (ThreadPool.java:684)
>> >> at java.lang.Thread.run(Unknown Source)
>> >
>> >
>>
>>
>