I didn't managed to solve this problem. I read the source of the helper, but it seemed correct.
My query was a select, joining few tables, and ordered.
I turned around this problem by requesting a "select count(*) from ..." before the real query and getting the number of results.
Anyway, this is how the helper gets the number of results, but in a "light" way.
-- Olivier
Geoff Howard wrote:
Did you ever get an answer on this? I thought that usually this was database specific problem that could be cleared up by (usually Chris Haul) adding some database specific logic to an esql helper class. But since it appears you're using Oracle, I'd find it hard to believe that it wasn't handled already.
Did you do anything special in your esql?
Geoff Howard
Olivier Billard wrote:
Hi all !
I've having some trouble with the esql taglib.
I read that Antonio Gallardo had also this trouble : http://marc.theaimsgroup.com/?l=xml-cocoon-users&m=103607342313325&w=4
but is this solved ? Is there some cases where It definitly won't work ?
Here is the error I met (in french for the style ;)) :
java.sql.SQLException: Op�ration non valide sur un ensemble de r�sultats de type forward-only : first java.sql.SQLException: Op�ration non valide sur un ensemble de r�sultats de type forward-only : first at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179) at oracle.jdbc.driver.BaseResultSet.first(BaseResultSet.java:84) at org.apache.cocoon.components.language.markup.xsp.AbstractEsqlQuery.getRowCount(AbstractEsqlQuery.java:204) at org.apache.cocoon.www.resources.resultats_xsp.generate(org.apache.cocoon.www.resources.resultats_xsp:645) at org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerPagesGenerator.java:260) at org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.processXMLPipeline(AbstractProcessingPipeline.java:531) at org.apache.cocoon.components.pipeline.impl.AbstractCachingProcessingPipeline.processXMLPipeline(AbstractCachingProcessingPipeline.java:229) at org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.process(AbstractProcessingPipeline.java:681) at org.apache.cocoon.components.source.impl.SitemapSource.toSAX(SitemapSource.java:433) at org.apache.cocoon.components.source.SourceUtil.parse(SourceUtil.java:193) at org.apache.cocoon.sitemap.ContentAggregator.generate(ContentAggregator.java:160) at org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.processXMLPipeline(AbstractProcessingPipeline.java:547) at org.apache.cocoon.components.pipeline.impl.AbstractCachingProcessingPipeline.processXMLPipeline(AbstractCachingProcessingPipeline.java:229) at org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.process(AbstractProcessingPipeline.java:491) at org.apache.cocoon.components.treeprocessor.sitemap.SerializeNode.invoke(SerializeNode.java:150) at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:108) at org.apache.cocoon.components.treeprocessor.ContainerNode.invoke(ContainerNode.java:66) at org.apache.cocoon.components.treeprocessor.sitemap.CallNode.invoke(CallNode.java:128) at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:84) at org.apache.cocoon.components.treeprocessor.sitemap.ActTypeNode.invoke(ActTypeNode.java:158) at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:84) at org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.invoke(PreparableMatchNode.java:164) at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:108) at org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(PipelineNode.java:164) at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:108) at org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(PipelinesNode.java:161) at org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcessor.java:325) at org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcessor.java:307) at org.apache.cocoon.Cocoon.process(Cocoon.java:621) at org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:1088) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:360) at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:294) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:558) at org.mortbay.http.HttpContext.handle(HttpContext.java:1714) at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:507) at org.mortbay.http.HttpContext.handle(HttpContext.java:1664) at org.mortbay.http.HttpServer.service(HttpServer.java:863) at org.mortbay.http.HttpConnection.service(HttpConnection.java:775) at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:939) at org.mortbay.http.HttpConnection.handle(HttpConnection.java:792) at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:201) at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:289) at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:455)
I'm just using a select query
Thanks in advance
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
