cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Frank" <faro...@hotmail.com>
Subject Re: Sort fails on setPageSize
Date Wed, 07 Mar 2007 22:01:39 GMT
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)
>
> 


Mime
View raw message