cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tore Halset <hal...@pvv.ntnu.no>
Subject Re: Sort fails on setPageSize
Date Wed, 07 Mar 2007 21:59:06 GMT
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)


Mime
View raw message