Re: Sort fails on setPageSize

Tore Halset Wed, 07 Mar 2007 13:58:46 -0800

Hi,

Would it be possible to reissue the query and let the database do thesorting? Otherwise sorting does not make sense before you havefetched 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)

Re: Sort fails on setPageSize

Reply via email to