You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Olivier Billard <ob...@rennes.jouve.fr> on 2003/07/22 16:37:18 UTC
Problem : in
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
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: Problem : in
Posted by Olivier Billard <ob...@rennes.jouve.fr>.
Hi Geof !
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: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: Problem : in
Posted by Geoff Howard <co...@leverageweb.com>.
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: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org