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 <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> To: <[email protected]> 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) > >
