in

[Olivier Billard <ob...@rennes.jouve.fr>]

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

-- 
Olivier BILLARD