cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dennis Riedel <dennis_rie...@web.de>
Subject Re: ESQL XSP Language Exception
Date Mon, 15 Aug 2005 06:45:54 GMT
Hello Carlos.

That`s it! Yes. I put all logic parts between the <svg /> element. Now 
it works. Thank you very much!

Conclusion:
-There must be a root non-xsp non-esql element wrapping all other stuff
-Also all xsp logic parts must be within this root element

Regards,
Dennis


Carlos Chávez wrote:

> Dennis Riedel wrote:
> Hi Dennis.
>
>> Hello
>>
>> I have the following XSP Page with ESQL Statements that produces a 
>> weird error (see Stacktrace).
>> I searched the archive, tried some ideas from 2003 but they didn`t help.
>>
>> Thanks for any suggestions.
>>
>> ###### XSP Page:
>> <?xml version="1.0" encoding="ISO-8859-1" ?>
>>
>> <xsp:page
>>    language="java"
>>    xmlns:xsp="http://apache.org/xsp"
>>    xmlns:esql="http://apache.org/cocoon/SQL/v2"
>>    xmlns:request="http://apache.org/xsp/request/2.0">
>>      <xsp:logic>
>>        Integer hall = new Integer(<request:get-parameter 
>> name="hallId" default="0"/>);
>>        StringBuffer sb=new StringBuffer();
>>    </xsp:logic>
>
>
>       another idea is try to move the xsp:logic block above into the 
> tags for <svg>, for me your page of example not compile until
>       i did that thing.
>        for example:
>      ......
>         <svg width="21cm" height="29,7cm">
>            <xsp:logic>
>                   Integer hall = new Integer(<request:get-parameter 
> name="hallId" default="0"/>);
>                   StringBuffer sb=new StringBuffer();
>            </xsp:logic>
>     ........
>
>       Cheers
>       Carlos Chávez.   
>
>>      <svg width="21cm" height="29,7cm">
>>      <esql:connection>
>>        <esql:pool>postgres-pool</esql:pool>
>>        <esql:autocommit>true</esql:autocommit>
>>        <esql:execute-query>
>>            <esql:query>
>>            SELECT a.ar_id, v.ve_x, v.ve_y FROM areas a LEFT JOIN 
>> vertices v ON a.ar_id = v.ar_id WHERE a.ha_id = 
>> '<xsp:expr>hall</xsp:expr>'
>>            </esql:query>
>>                      <esql:results>
>>                  <esql:row-results>
>>                    <esql:group group-on="a.ar_id">
>>                                          <xsp:logic>
>>                              sb.setLength(0);
>>                        </xsp:logic>
>>                                                  <polygon>
>>                                              <esql:member>
>>                            <xsp:logic>
>>                                   sb.append(<esql:get-string 
>> column="v.ve_x"/>+",");
>>                                   sb.append(<esql:get-string 
>> column="v.ve_y"/>+" ");
>>                            </xsp:logic>
>>                          </esql:member>
>>                                                <xsp:logic>
>>                               if (sb.length()>0)
>>                                  sb.setLength(sb.length()-1);
>>                        </xsp:logic>
>>                                              <xsp:attribute 
>> name="points"><xsp:expr>sb.toString()</xsp:expr></xsp:attribute>
>>                                        </polygon>
>>                                       </esql:group>
>>                </esql:row-results>
>>            </esql:results>
>>                  </esql:execute-query>
>>    </esql:connection>
>>      </svg>
>>   </xsp:page>
>>
>> ###### Stacktrace:
>>
>> org.apache.cocoon.ProcessingException: Language Exception: 
>> org.apache.cocoon.components.language.LanguageException: Error 
>> compiling svgdata_xsp:
>> ERROR 1 
>> (org\apache\cocoon\www\floorplan\documents\xsp\svgdata_xsp.java):
>> ...
>>    if (_esql_query != null) {
>>      _esql_queries.push(_esql_query);
>>    }
>>
>>
>> // start error (lines 321-321) "Unhandled exception type SQLException"
>>    _esql_query = _esql_connection.createQuery(
>>
>> // end error
>>             String.valueOf(""),
>>             String.valueOf(
>>      ""
>>     ...
>> ERROR 2 
>> (org\apache\cocoon\www\floorplan\documents\xsp\svgdata_xsp.java):
>> ...
>>            if (!_esql_connection.getAutoCommit()) {
>>              _esql_connection.rollback();
>>            }
>>          } catch (Exception _esql_exception_N1001F_2) {}
>>
>> // start error (lines 509-509) "Unhandled exception type SQLException"
>>          throw new RuntimeException("Error executing statement: " + 
>> _esql_query.getQueryString() + ": "+_esql_exception_N1001F);
>>
>> // end error
>>             } finally {
>>        _esql_query.cleanUp();
>>    }
>>
>> ...
>> Line 321, column 0: Unhandled exception type SQLException
>> Line 509, column 0: Unhandled exception type SQLException
>>     at 
>> org.apache.cocoon.components.language.generator.ProgramGeneratorImpl.loadProgram(ProgramGeneratorImpl.java:409)

>>
>>     at 
>> org.apache.cocoon.components.language.generator.ProgramGeneratorImpl.load(ProgramGeneratorImpl.java:280)

>>
>>     at 
>> org.apache.cocoon.generation.ServerPagesGenerator.setup(ServerPagesGenerator.java:170)

>>
>>     at 
>> org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.setupPipeline(AbstractProcessingPipeline.java:385)

>>
>>     at 
>> org.apache.cocoon.components.pipeline.impl.AbstractCachingProcessingPipeline.setupPipeline(AbstractCachingProcessingPipeline.java:620)

>>
>>     at 
>> org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.preparePipeline(AbstractProcessingPipeline.java:503)

>>
>>     at 
>> org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.process(AbstractProcessingPipeline.java:455)

>>
>>     at 
>> org.apache.cocoon.components.treeprocessor.sitemap.SerializeNode.invoke(SerializeNode.java:120)

>>
>>     at 
>> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:46)

>>
>>     at 
>> org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.invoke(PreparableMatchNode.java:130)

>>
>>     at 
>> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:68)

>>
>>     at 
>> org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(PipelineNode.java:138)

>>
>>     at 
>> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:68)

>>
>>     at 
>> org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(PipelinesNode.java:92)

>>
>>     at 
>> org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor.process(ConcreteTreeProcessor.java:234)

>>
>>     at 
>> org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor.process(ConcreteTreeProcessor.java:176)

>>
>>     at 
>> org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcessor.java:243)

>>
>>     at 
>> org.apache.cocoon.components.treeprocessor.sitemap.MountNode.invoke(MountNode.java:117)

>>
>>     at 
>> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:46)

>>
>>     at 
>> org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.invoke(PreparableMatchNode.java:130)

>>
>>     at 
>> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:68)

>>
>>     at 
>> org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(PipelineNode.java:138)

>>
>>     at 
>> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:68)

>>
>>     at 
>> org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(PipelinesNode.java:92)

>>
>>     at 
>> org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor.process(ConcreteTreeProcessor.java:234)

>>
>>     at 
>> org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor.process(ConcreteTreeProcessor.java:176)

>>
>>     at 
>> org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcessor.java:243)

>>
>>     at org.apache.cocoon.Cocoon.process(Cocoon.java:608)
>>     at 
>> org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:1123)
>>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>>     at 
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)

>>
>>     at 
>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)

>>
>>     at 
>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)

>>
>>     at 
>> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

>>
>>     at 
>> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) 
>>
>>     at 
>> org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)

>>
>>     at 
>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)

>>
>>     at 
>> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

>>
>>     at 
>> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) 
>>
>>     at 
>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) 
>>
>>     at 
>> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

>>
>>     at 
>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) 
>>
>>     at 
>> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)

>>
>>     at 
>> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) 
>>
>>     at 
>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

>>
>>     at 
>> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

>>
>>     at 
>> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) 
>>
>>     at 
>> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
>>     at 
>> org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
>>     at 
>> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) 
>>
>>     at 
>> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)

>>
>>     at 
>> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) 
>>
>>     at 
>> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)

>>
>>     at java.lang.Thread.run(Thread.java:534)
>> Caused by: org.apache.cocoon.components.language.LanguageException: 
>> Error compiling svgdata_xsp:
>> ERROR 1 
>> (org\apache\cocoon\www\floorplan\documents\xsp\svgdata_xsp.java):
>> ...
>>    if (_esql_query != null) {
>>      _esql_queries.push(_esql_query);
>>    }
>>
>>
>> // start error (lines 321-321) "Unhandled exception type SQLException"
>>    _esql_query = _esql_connection.createQuery(
>>
>> // end error
>>             String.valueOf(""),
>>             String.valueOf(
>>      ""
>>     ...
>> ERROR 2 
>> (org\apache\cocoon\www\floorplan\documents\xsp\svgdata_xsp.java):
>> ...
>>            if (!_esql_connection.getAutoCommit()) {
>>              _esql_connection.rollback();
>>            }
>>          } catch (Exception _esql_exception_N1001F_2) {}
>>
>> // start error (lines 509-509) "Unhandled exception type SQLException"
>>          throw new RuntimeException("Error executing statement: " + 
>> _esql_query.getQueryString() + ": "+_esql_exception_N1001F);
>>
>> // end error
>>             } finally {
>>        _esql_query.cleanUp();
>>    }
>>
>> ...
>> Line 321, column 0: Unhandled exception type SQLException
>> Line 509, column 0: Unhandled exception type SQLException
>>     at 
>> org.apache.cocoon.components.language.programming.java.JavaLanguage.compile(JavaLanguage.java:226)

>>
>>     at 
>> org.apache.cocoon.components.language.programming.CompiledProgrammingLanguage.load(CompiledProgrammingLanguage.java:173)

>>
>>     at 
>> org.apache.cocoon.components.language.generator.ProgramGeneratorImpl.loadProgram(ProgramGeneratorImpl.java:399)

>>
>>     ... 53 more
>> org.apache.cocoon.components.language.LanguageException: Error 
>> compiling svgdata_xsp:
>> ERROR 1 
>> (org\apache\cocoon\www\floorplan\documents\xsp\svgdata_xsp.java):
>> ...
>>    if (_esql_query != null) {
>>      _esql_queries.push(_esql_query);
>>    }
>>
>>
>> // start error (lines 321-321) "Unhandled exception type SQLException"
>>    _esql_query = _esql_connection.createQuery(
>>
>> // end error
>>             String.valueOf(""),
>>             String.valueOf(
>>      ""
>>     ...
>> ERROR 2 
>> (org\apache\cocoon\www\floorplan\documents\xsp\svgdata_xsp.java):
>> ...
>>            if (!_esql_connection.getAutoCommit()) {
>>              _esql_connection.rollback();
>>            }
>>          } catch (Exception _esql_exception_N1001F_2) {}
>>
>> // start error (lines 509-509) "Unhandled exception type SQLException"
>>          throw new RuntimeException("Error executing statement: " + 
>> _esql_query.getQueryString() + ": "+_esql_exception_N1001F);
>>
>> // end error
>>             } finally {
>>        _esql_query.cleanUp();
>>    }
>>
>> ...
>> Line 321, column 0: Unhandled exception type SQLException
>> Line 509, column 0: Unhandled exception type SQLException
>>     at 
>> org.apache.cocoon.components.language.programming.java.JavaLanguage.compile(JavaLanguage.java:226)

>>
>>     at 
>> org.apache.cocoon.components.language.programming.CompiledProgrammingLanguage.load(CompiledProgrammingLanguage.java:173)

>>
>>     at 
>> org.apache.cocoon.components.language.generator.ProgramGeneratorImpl.loadProgram(ProgramGeneratorImpl.java:399)

>>
>>     at 
>> org.apache.cocoon.components.language.generator.ProgramGeneratorImpl.load(ProgramGeneratorImpl.java:280)

>>
>>     at 
>> org.apache.cocoon.generation.ServerPagesGenerator.setup(ServerPagesGenerator.java:170)

>>
>>     at 
>> org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.setupPipeline(AbstractProcessingPipeline.java:385)

>>
>>     at 
>> org.apache.cocoon.components.pipeline.impl.AbstractCachingProcessingPipeline.setupPipeline(AbstractCachingProcessingPipeline.java:620)

>>
>>     at 
>> org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.preparePipeline(AbstractProcessingPipeline.java:503)

>>
>>     at 
>> org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.process(AbstractProcessingPipeline.java:455)

>>
>>     at 
>> org.apache.cocoon.components.treeprocessor.sitemap.SerializeNode.invoke(SerializeNode.java:120)

>>
>>     at 
>> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:46)

>>
>>     at 
>> org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.invoke(PreparableMatchNode.java:130)

>>
>>     at 
>> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:68)

>>
>>     at 
>> org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(PipelineNode.java:138)

>>
>>     at 
>> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:68)

>>
>>     at 
>> org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(PipelinesNode.java:92)

>>
>>     at 
>> org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor.process(ConcreteTreeProcessor.java:234)

>>
>>     at 
>> org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor.process(ConcreteTreeProcessor.java:176)

>>
>>     at 
>> org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcessor.java:243)

>>
>>     at 
>> org.apache.cocoon.components.treeprocessor.sitemap.MountNode.invoke(MountNode.java:117)

>>
>>     at 
>> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:46)

>>
>>     at 
>> org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.invoke(PreparableMatchNode.java:130)

>>
>>     at 
>> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:68)

>>
>>     at 
>> org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(PipelineNode.java:138)

>>
>>     at 
>> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:68)

>>
>>     at 
>> org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(PipelinesNode.java:92)

>>
>>     at 
>> org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor.process(ConcreteTreeProcessor.java:234)

>>
>>     at 
>> org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor.process(ConcreteTreeProcessor.java:176)

>>
>>     at 
>> org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcessor.java:243)

>>
>>     at org.apache.cocoon.Cocoon.process(Cocoon.java:608)
>>     at 
>> org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:1123)
>>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>>     at 
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)

>>
>>     at 
>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)

>>
>>     at 
>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)

>>
>>     at 
>> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

>>
>>     at 
>> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) 
>>
>>     at 
>> org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)

>>
>>     at 
>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)

>>
>>     at 
>> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

>>
>>     at 
>> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) 
>>
>>     at 
>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) 
>>
>>     at 
>> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

>>
>>     at 
>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) 
>>
>>     at 
>> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)

>>
>>     at 
>> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) 
>>
>>     at 
>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

>>
>>     at 
>> org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

>>
>>     at 
>> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) 
>>
>>     at 
>> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
>>     at 
>> org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
>>     at 
>> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) 
>>
>>     at 
>> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)

>>
>>     at 
>> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) 
>>
>>     at 
>> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)

>>
>>     at java.lang.Thread.run(Thread.java:534)
>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
>> For additional commands, e-mail: users-help@cocoon.apache.org
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
>
>


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org


Mime
View raw message