You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Marco Spinetti <m....@pisa.iol.it> on 2001/07/03 13:51:19 UTC

ESQL Error!

Hi all, 
my application was ok with cocoon 1.8.2: last week I passed to cocoon2 and then I tried to convert my application for cocoon2. When I tried it I obtain this esql error:

      Error creating the resource 
     Failed to execute pipeline. 
      details 
      from  
      source org.apache.cocoon.ProcessingException 
      description org.apache.cocoon.ProcessingException: Failed to execute pipeline.:org.apache.cocoon.ResourceNotFoundException: Language Exception:org.apache.cocoon.ProcessingException: Language Exception:org.apache.cocoon.components.language.LanguageException: Error compiling risposta_elenco_xsp: Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:1317: Invalid expression statement. (_esql_query.resultset.getInt(1)) ^ Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:3081: Invalid expression statement. (_esql_query.resultset.getInt(1)) ^ Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:4814: Invalid expression statement. (_esql_query.resultset.getInt(1)) ^  
      extra info 
     org.apache.cocoon.ResourceNotFoundException: Language Exception:org.apache.cocoon.ProcessingException: Language Exception:org.apache.cocoon.components.language.LanguageException: Error compiling risposta_elenco_xsp:
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:1317: Invalid expression statement.
                    (_esql_query.resultset.getInt(1))
                    ^
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:3081: Invalid expression statement.
                  (_esql_query.resultset.getInt(1))
                  ^
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:4814: Invalid expression statement.
                (_esql_query.resultset.getInt(1))
                ^

     
     org.apache.cocoon.ResourceNotFoundException: Language Exception:org.apache.cocoon.ProcessingException: Language Exception:org.apache.cocoon.components.language.LanguageException: Error compiling risposta_elenco_xsp:
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:1317: Invalid expression statement.
                    (_esql_query.resultset.getInt(1))
                    ^
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:3081: Invalid expression statement.
                  (_esql_query.resultset.getInt(1))
                  ^
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:4814: Invalid expression statement.
                (_esql_query.resultset.getInt(1))
                ^

	at org.apache.avalon.framework.CascadingException.<init>(CascadingException.java:40)
	at org.apache.cocoon.ProcessingException.<init>(ProcessingException.java:36)
	at org.apache.cocoon.ResourceNotFoundException.<init>(ResourceNotFoundException.java:31)
	at org.apache.cocoon.generation.ServerPagesGenerator.setup(ServerPagesGenerator.java:156)
	at org.apache.cocoon.components.pipeline.AbstractEventPipeline.setupPipeline(AbstractEventPipeline.java:164)
	at org.apache.cocoon.components.pipeline.CachingEventPipeline.setup(CachingEventPipeline.java:255)
	at org.apache.cocoon.components.pipeline.CachingEventPipeline.generateKey(CachingEventPipeline.java:110)
	at org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingStreamPipeline.java:273)
	at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:4411)
	at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:1390)
	at org.apache.cocoon.sitemap.Handler.process(Handler.java:175)
	at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:94)
	at org.apache.cocoon.Cocoon.process(Cocoon.java:293)
	at org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:471)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
	at org.apache.tomcat.core.Handler.service(Handler.java:287)
	at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
	at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)
	at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
	at org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection(Ajp12ConnectionHandler.java:166)
	at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
	at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
	at java.lang.Thread.run(Thread.java:498)
org.apache.cocoon.ProcessingException: Language Exception:org.apache.cocoon.components.language.LanguageException: Error compiling risposta_elenco_xsp:
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:1317: Invalid expression statement.
                    (_esql_query.resultset.getInt(1))
                    ^
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:3081: Invalid expression statement.
                  (_esql_query.resultset.getInt(1))
                  ^
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:4814: Invalid expression statement.
                (_esql_query.resultset.getInt(1))
                ^

	at org.apache.avalon.framework.CascadingException.<init>(CascadingException.java:40)
	at org.apache.cocoon.ProcessingException.<init>(ProcessingException.java:36)
	at org.apache.cocoon.components.language.generator.ProgramGeneratorImpl.load(ProgramGeneratorImpl.java:161)
	at org.apache.cocoon.generation.ServerPagesGenerator.setup(ServerPagesGenerator.java:153)
	at org.apache.cocoon.components.pipeline.AbstractEventPipeline.setupPipeline(AbstractEventPipeline.java:164)
	at org.apache.cocoon.components.pipeline.CachingEventPipeline.setup(CachingEventPipeline.java:255)
	at org.apache.cocoon.components.pipeline.CachingEventPipeline.generateKey(CachingEventPipeline.java:110)
	at org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingStreamPipeline.java:273)
	at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:4411)
	at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:1390)
	at org.apache.cocoon.sitemap.Handler.process(Handler.java:175)
	at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:94)
	at org.apache.cocoon.Cocoon.process(Cocoon.java:293)
	at org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:471)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
	at org.apache.tomcat.core.Handler.service(Handler.java:287)
	at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
	at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)
	at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
	at org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection(Ajp12ConnectionHandler.java:166)
	at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
	at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
	at java.lang.Thread.run(Thread.java:498)
org.apache.cocoon.components.language.LanguageException: Error compiling risposta_elenco_xsp:
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:1317: Invalid expression statement.
                    (_esql_query.resultset.getInt(1))
                    ^
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:3081: Invalid expression statement.
                  (_esql_query.resultset.getInt(1))
                  ^
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:4814: Invalid expression statement.
                (_esql_query.resultset.getInt(1))
                ^

	at org.apache.cocoon.components.language.LanguageException.<init>(LanguageException.java:21)
	at org.apache.cocoon.components.language.programming.java.JavaLanguage.compile(JavaLanguage.java:203)
	at org.apache.cocoon.components.language.programming.CompiledProgrammingLanguage.load(CompiledProgrammingLanguage.java:131)
	at org.apache.cocoon.components.language.generator.ProgramGeneratorImpl.generateResource(ProgramGeneratorImpl.java:243)
	at org.apache.cocoon.components.language.generator.ProgramGeneratorImpl.load(ProgramGeneratorImpl.java:158)
	at org.apache.cocoon.generation.ServerPagesGenerator.setup(ServerPagesGenerator.java:153)
	at org.apache.cocoon.components.pipeline.AbstractEventPipeline.setupPipeline(AbstractEventPipeline.java:164)
	at org.apache.cocoon.components.pipeline.CachingEventPipeline.setup(CachingEventPipeline.java:255)
	at org.apache.cocoon.components.pipeline.CachingEventPipeline.generateKey(CachingEventPipeline.java:110)
	at org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingStreamPipeline.java:273)
	at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:4411)
	at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:1390)
	at org.apache.cocoon.sitemap.Handler.process(Handler.java:175)
	at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:94)
	at org.apache.cocoon.Cocoon.process(Cocoon.java:293)
	at org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:471)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
	at org.apache.tomcat.core.Handler.service(Handler.java:287)
	at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
	at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)
	at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
	at org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection(Ajp12ConnectionHandler.java:166)
	at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
	at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
	at java.lang.Thread.run(Thread.java:498)

     
     org.apache.cocoon.ProcessingException: Failed to execute pipeline.:org.apache.cocoon.ResourceNotFoundException: Language Exception:org.apache.cocoon.ProcessingException: Language Exception:org.apache.cocoon.components.language.LanguageException: Error compiling risposta_elenco_xsp:
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:1317: Invalid expression statement.
                    (_esql_query.resultset.getInt(1))
                    ^
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:3081: Invalid expression statement.
                  (_esql_query.resultset.getInt(1))
                  ^
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:4814: Invalid expression statement.
                (_esql_query.resultset.getInt(1))
                ^

     
     org.apache.cocoon.ProcessingException: Failed to execute pipeline.:org.apache.cocoon.ResourceNotFoundException: Language Exception:org.apache.cocoon.ProcessingException: Language Exception:org.apache.cocoon.components.language.LanguageException: Error compiling risposta_elenco_xsp:
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:1317: Invalid expression statement.
                    (_esql_query.resultset.getInt(1))
                    ^
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:3081: Invalid expression statement.
                  (_esql_query.resultset.getInt(1))
                  ^
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:4814: Invalid expression statement.
                (_esql_query.resultset.getInt(1))
                ^

	at org.apache.avalon.framework.CascadingException.<init>(CascadingException.java:40)
	at org.apache.cocoon.ProcessingException.<init>(ProcessingException.java:36)
	at org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingStreamPipeline.java:359)
	at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:4411)
	at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:1390)
	at org.apache.cocoon.sitemap.Handler.process(Handler.java:175)
	at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:94)
	at org.apache.cocoon.Cocoon.process(Cocoon.java:293)
	at org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:471)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
	at org.apache.tomcat.core.Handler.service(Handler.java:287)
	at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
	at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)
	at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
	at org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection(Ajp12ConnectionHandler.java:166)
	at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
	at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
	at java.lang.Thread.run(Thread.java:498)
org.apache.cocoon.ResourceNotFoundException: Language Exception:org.apache.cocoon.ProcessingException: Language Exception:org.apache.cocoon.components.language.LanguageException: Error compiling risposta_elenco_xsp:
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:1317: Invalid expression statement.
                    (_esql_query.resultset.getInt(1))
                    ^
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:3081: Invalid expression statement.
                  (_esql_query.resultset.getInt(1))
                  ^
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:4814: Invalid expression statement.
                (_esql_query.resultset.getInt(1))
                ^

	at org.apache.avalon.framework.CascadingException.<init>(CascadingException.java:40)
	at org.apache.cocoon.ProcessingException.<init>(ProcessingException.java:36)
	at org.apache.cocoon.ResourceNotFoundException.<init>(ResourceNotFoundException.java:31)
	at org.apache.cocoon.generation.ServerPagesGenerator.setup(ServerPagesGenerator.java:156)
	at org.apache.cocoon.components.pipeline.AbstractEventPipeline.setupPipeline(AbstractEventPipeline.java:164)
	at org.apache.cocoon.components.pipeline.CachingEventPipeline.setup(CachingEventPipeline.java:255)
	at org.apache.cocoon.components.pipeline.CachingEventPipeline.generateKey(CachingEventPipeline.java:110)
	at org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingStreamPipeline.java:273)
	at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:4411)
	at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:1390)
	at org.apache.cocoon.sitemap.Handler.process(Handler.java:175)
	at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:94)
	at org.apache.cocoon.Cocoon.process(Cocoon.java:293)
	at org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:471)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
	at org.apache.tomcat.core.Handler.service(Handler.java:287)
	at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
	at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)
	at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
	at org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection(Ajp12ConnectionHandler.java:166)
	at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
	at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
	at java.lang.Thread.run(Thread.java:498)
org.apache.cocoon.ProcessingException: Language Exception:org.apache.cocoon.components.language.LanguageException: Error compiling risposta_elenco_xsp:
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:1317: Invalid expression statement.
                    (_esql_query.resultset.getInt(1))
                    ^
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:3081: Invalid expression statement.
                  (_esql_query.resultset.getInt(1))
                  ^
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:4814: Invalid expression statement.
                (_esql_query.resultset.getInt(1))
                ^

	at org.apache.avalon.framework.CascadingException.<init>(CascadingException.java:40)
	at org.apache.cocoon.ProcessingException.<init>(ProcessingException.java:36)
	at org.apache.cocoon.components.language.generator.ProgramGeneratorImpl.load(ProgramGeneratorImpl.java:161)
	at org.apache.cocoon.generation.ServerPagesGenerator.setup(ServerPagesGenerator.java:153)
	at org.apache.cocoon.components.pipeline.AbstractEventPipeline.setupPipeline(AbstractEventPipeline.java:164)
	at org.apache.cocoon.components.pipeline.CachingEventPipeline.setup(CachingEventPipeline.java:255)
	at org.apache.cocoon.components.pipeline.CachingEventPipeline.generateKey(CachingEventPipeline.java:110)
	at org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingStreamPipeline.java:273)
	at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:4411)
	at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:1390)
	at org.apache.cocoon.sitemap.Handler.process(Handler.java:175)
	at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:94)
	at org.apache.cocoon.Cocoon.process(Cocoon.java:293)
	at org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:471)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
	at org.apache.tomcat.core.Handler.service(Handler.java:287)
	at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
	at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)
	at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
	at org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection(Ajp12ConnectionHandler.java:166)
	at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
	at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
	at java.lang.Thread.run(Thread.java:498)
org.apache.cocoon.components.language.LanguageException: Error compiling risposta_elenco_xsp:
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:1317: Invalid expression statement.
                    (_esql_query.resultset.getInt(1))
                    ^
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:3081: Invalid expression statement.
                  (_esql_query.resultset.getInt(1))
                  ^
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:4814: Invalid expression statement.
                (_esql_query.resultset.getInt(1))
                ^

	at org.apache.cocoon.components.language.LanguageException.<init>(LanguageException.java:21)
	at org.apache.cocoon.components.language.programming.java.JavaLanguage.compile(JavaLanguage.java:203)
	at org.apache.cocoon.components.language.programming.CompiledProgrammingLanguage.load(CompiledProgrammingLanguage.java:131)
	at org.apache.cocoon.components.language.generator.ProgramGeneratorImpl.generateResource(ProgramGeneratorImpl.java:243)
	at org.apache.cocoon.components.language.generator.ProgramGeneratorImpl.load(ProgramGeneratorImpl.java:158)
	at org.apache.cocoon.generation.ServerPagesGenerator.setup(ServerPagesGenerator.java:153)
	at org.apache.cocoon.components.pipeline.AbstractEventPipeline.setupPipeline(AbstractEventPipeline.java:164)
	at org.apache.cocoon.components.pipeline.CachingEventPipeline.setup(CachingEventPipeline.java:255)
	at org.apache.cocoon.components.pipeline.CachingEventPipeline.generateKey(CachingEventPipeline.java:110)
	at org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingStreamPipeline.java:273)
	at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:4411)
	at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:1390)
	at org.apache.cocoon.sitemap.Handler.process(Handler.java:175)
	at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:94)
	at org.apache.cocoon.Cocoon.process(Cocoon.java:293)
	at org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:471)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
	at org.apache.tomcat.core.Handler.service(Handler.java:287)
	at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
	at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)
	at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
	at org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection(Ajp12ConnectionHandler.java:166)
	at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
	at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
	at java.lang.Thread.run(Thread.java:498)
     


I think that the error is when I use
 
<esql:get-int column="1"/>

after query = "select count(*) from .........".
Where is the error?
Can someone help me?
Thanks
Marco


R: ESQL Error!

Posted by Marco Spinetti <m....@pisa.iol.it>.
Hi all,
I tried it but the error is the same: what do you think?

      Error creating the resource 
     Failed to execute pipeline. 
      details 
      from  
      source org.apache.cocoon.ProcessingException 
      description org.apache.cocoon.ProcessingException: Failed to execute pipeline.:org.apache.cocoon.ResourceNotFoundException: Language Exception:org.apache.cocoon.ProcessingException: Language Exception:org.apache.cocoon.components.language.LanguageException: Error compiling risposta_elenco_xsp: Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:1317: Invalid expression statement. (_esql_query.resultset.getInt("count")) ^ Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:3081: Invalid expression statement. (_esql_query.resultset.getInt("count")) ^ Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:4814: Invalid expression statement. (_esql_query.resultset.getInt("count")) ^  
      extra info 
     org.apache.cocoon.ResourceNotFoundException: Language Exception:org.apache.cocoon.ProcessingException: Language Exception:org.apache.cocoon.components.language.LanguageException: Error compiling risposta_elenco_xsp:
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:1317: Invalid expression statement.
                    (_esql_query.resultset.getInt("count"))
                    ^
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:3081: Invalid expression statement.
                  (_esql_query.resultset.getInt("count"))
                  ^
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:4814: Invalid expression statement.
                (_esql_query.resultset.getInt("count"))
                ^

     
     org.apache.cocoon.ResourceNotFoundException: Language Exception:org.apache.cocoon.ProcessingException: Language Exception:org.apache.cocoon.components.language.LanguageException: Error compiling risposta_elenco_xsp:
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:1317: Invalid expression statement.
                    (_esql_query.resultset.getInt("count"))
                    ^
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:3081: Invalid expression statement.
                  (_esql_query.resultset.getInt("count"))
                  ^
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:4814: Invalid expression statement.
                (_esql_query.resultset.getInt("count"))
                ^

	at org.apache.avalon.framework.CascadingException.<init>(CascadingException.java:40)
	at org.apache.cocoon.ProcessingException.<init>(ProcessingException.java:36)
	at org.apache.cocoon.ResourceNotFoundException.<init>(ResourceNotFoundException.java:31)
	at org.apache.cocoon.generation.ServerPagesGenerator.setup(ServerPagesGenerator.java:156)
	at org.apache.cocoon.components.pipeline.AbstractEventPipeline.setupPipeline(AbstractEventPipeline.java:164)
	at org.apache.cocoon.components.pipeline.CachingEventPipeline.setup(CachingEventPipeline.java:255)
	at org.apache.cocoon.components.pipeline.CachingEventPipeline.generateKey(CachingEventPipeline.java:110)
	at org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingStreamPipeline.java:273)
	at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:4411)
	at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:1390)
	at org.apache.cocoon.sitemap.Handler.process(Handler.java:175)
	at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:94)
	at org.apache.cocoon.Cocoon.process(Cocoon.java:293)
	at org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:471)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
	at org.apache.tomcat.core.Handler.service(Handler.java:287)
	at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
	at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)
	at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
	at org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection(Ajp12ConnectionHandler.java:166)
	at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
	at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
	at java.lang.Thread.run(Thread.java:498)
org.apache.cocoon.ProcessingException: Language Exception:org.apache.cocoon.components.language.LanguageException: Error compiling risposta_elenco_xsp:
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:1317: Invalid expression statement.
                    (_esql_query.resultset.getInt("count"))
                    ^
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:3081: Invalid expression statement.
                  (_esql_query.resultset.getInt("count"))
                  ^
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:4814: Invalid expression statement.
                (_esql_query.resultset.getInt("count"))
                ^

	at org.apache.avalon.framework.CascadingException.<init>(CascadingException.java:40)
	at org.apache.cocoon.ProcessingException.<init>(ProcessingException.java:36)
	at org.apache.cocoon.components.language.generator.ProgramGeneratorImpl.load(ProgramGeneratorImpl.java:161)
	at org.apache.cocoon.generation.ServerPagesGenerator.setup(ServerPagesGenerator.java:153)
	at org.apache.cocoon.components.pipeline.AbstractEventPipeline.setupPipeline(AbstractEventPipeline.java:164)
	at org.apache.cocoon.components.pipeline.CachingEventPipeline.setup(CachingEventPipeline.java:255)
	at org.apache.cocoon.components.pipeline.CachingEventPipeline.generateKey(CachingEventPipeline.java:110)
	at org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingStreamPipeline.java:273)
	at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:4411)
	at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:1390)
	at org.apache.cocoon.sitemap.Handler.process(Handler.java:175)
	at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:94)
	at org.apache.cocoon.Cocoon.process(Cocoon.java:293)
	at org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:471)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
	at org.apache.tomcat.core.Handler.service(Handler.java:287)
	at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
	at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)
	at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
	at org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection(Ajp12ConnectionHandler.java:166)
	at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
	at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
	at java.lang.Thread.run(Thread.java:498)
org.apache.cocoon.components.language.LanguageException: Error compiling risposta_elenco_xsp:
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:1317: Invalid expression statement.
                    (_esql_query.resultset.getInt("count"))
                    ^
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:3081: Invalid expression statement.
                  (_esql_query.resultset.getInt("count"))
                  ^
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:4814: Invalid expression statement.
                (_esql_query.resultset.getInt("count"))
                ^

	at org.apache.cocoon.components.language.LanguageException.<init>(LanguageException.java:21)
	at org.apache.cocoon.components.language.programming.java.JavaLanguage.compile(JavaLanguage.java:203)
	at org.apache.cocoon.components.language.programming.CompiledProgrammingLanguage.load(CompiledProgrammingLanguage.java:131)
	at org.apache.cocoon.components.language.generator.ProgramGeneratorImpl.generateResource(ProgramGeneratorImpl.java:243)
	at org.apache.cocoon.components.language.generator.ProgramGeneratorImpl.load(ProgramGeneratorImpl.java:158)
	at org.apache.cocoon.generation.ServerPagesGenerator.setup(ServerPagesGenerator.java:153)
	at org.apache.cocoon.components.pipeline.AbstractEventPipeline.setupPipeline(AbstractEventPipeline.java:164)
	at org.apache.cocoon.components.pipeline.CachingEventPipeline.setup(CachingEventPipeline.java:255)
	at org.apache.cocoon.components.pipeline.CachingEventPipeline.generateKey(CachingEventPipeline.java:110)
	at org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingStreamPipeline.java:273)
	at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:4411)
	at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:1390)
	at org.apache.cocoon.sitemap.Handler.process(Handler.java:175)
	at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:94)
	at org.apache.cocoon.Cocoon.process(Cocoon.java:293)
	at org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:471)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
	at org.apache.tomcat.core.Handler.service(Handler.java:287)
	at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
	at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)
	at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
	at org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection(Ajp12ConnectionHandler.java:166)
	at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
	at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
	at java.lang.Thread.run(Thread.java:498)

     
     org.apache.cocoon.ProcessingException: Failed to execute pipeline.:org.apache.cocoon.ResourceNotFoundException: Language Exception:org.apache.cocoon.ProcessingException: Language Exception:org.apache.cocoon.components.language.LanguageException: Error compiling risposta_elenco_xsp:
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:1317: Invalid expression statement.
                    (_esql_query.resultset.getInt("count"))
                    ^
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:3081: Invalid expression statement.
                  (_esql_query.resultset.getInt("count"))
                  ^
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:4814: Invalid expression statement.
                (_esql_query.resultset.getInt("count"))
                ^

     

     org.apache.cocoon.ProcessingException: Failed to execute pipeline.:org.apache.cocoon.ResourceNotFoundException: Language Exception:org.apache.cocoon.ProcessingException: Language Exception:org.apache.cocoon.components.language.LanguageException: Error compiling risposta_elenco_xsp:
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:1317: Invalid expression statement.
                    (_esql_query.resultset.getInt("count"))
                    ^
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:3081: Invalid expression statement.
                  (_esql_query.resultset.getInt("count"))
                  ^
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:4814: Invalid expression statement.
                (_esql_query.resultset.getInt("count"))
                ^

	at org.apache.avalon.framework.CascadingException.<init>(CascadingException.java:40)
	at org.apache.cocoon.ProcessingException.<init>(ProcessingException.java:36)
	at org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingStreamPipeline.java:359)
	at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:4411)
	at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:1390)
	at org.apache.cocoon.sitemap.Handler.process(Handler.java:175)
	at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:94)
	at org.apache.cocoon.Cocoon.process(Cocoon.java:293)
	at org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:471)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
	at org.apache.tomcat.core.Handler.service(Handler.java:287)
	at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
	at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)
	at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
	at org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection(Ajp12ConnectionHandler.java:166)
	at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
	at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
	at java.lang.Thread.run(Thread.java:498)
org.apache.cocoon.ResourceNotFoundException: Language Exception:org.apache.cocoon.ProcessingException: Language Exception:org.apache.cocoon.components.language.LanguageException: Error compiling risposta_elenco_xsp:
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:1317: Invalid expression statement.
                    (_esql_query.resultset.getInt("count"))
                    ^
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:3081: Invalid expression statement.
                  (_esql_query.resultset.getInt("count"))
                  ^
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:4814: Invalid expression statement.
                (_esql_query.resultset.getInt("count"))
                ^

	at org.apache.avalon.framework.CascadingException.<init>(CascadingException.java:40)
	at org.apache.cocoon.ProcessingException.<init>(ProcessingException.java:36)
	at org.apache.cocoon.ResourceNotFoundException.<init>(ResourceNotFoundException.java:31)
	at org.apache.cocoon.generation.ServerPagesGenerator.setup(ServerPagesGenerator.java:156)
	at org.apache.cocoon.components.pipeline.AbstractEventPipeline.setupPipeline(AbstractEventPipeline.java:164)
	at org.apache.cocoon.components.pipeline.CachingEventPipeline.setup(CachingEventPipeline.java:255)
	at org.apache.cocoon.components.pipeline.CachingEventPipeline.generateKey(CachingEventPipeline.java:110)
	at org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingStreamPipeline.java:273)
	at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:4411)
	at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:1390)
	at org.apache.cocoon.sitemap.Handler.process(Handler.java:175)
	at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:94)
	at org.apache.cocoon.Cocoon.process(Cocoon.java:293)
	at org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:471)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
	at org.apache.tomcat.core.Handler.service(Handler.java:287)
	at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
	at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)
	at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
	at org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection(Ajp12ConnectionHandler.java:166)
	at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
	at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
	at java.lang.Thread.run(Thread.java:498)
org.apache.cocoon.ProcessingException: Language Exception:org.apache.cocoon.components.language.LanguageException: Error compiling risposta_elenco_xsp:
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:1317: Invalid expression statement.
                    (_esql_query.resultset.getInt("count"))
                    ^
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:3081: Invalid expression statement.
                  (_esql_query.resultset.getInt("count"))
                  ^
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:4814: Invalid expression statement.
                (_esql_query.resultset.getInt("count"))
                ^

	at org.apache.avalon.framework.CascadingException.<init>(CascadingException.java:40)
	at org.apache.cocoon.ProcessingException.<init>(ProcessingException.java:36)
	at org.apache.cocoon.components.language.generator.ProgramGeneratorImpl.load(ProgramGeneratorImpl.java:161)
	at org.apache.cocoon.generation.ServerPagesGenerator.setup(ServerPagesGenerator.java:153)
	at org.apache.cocoon.components.pipeline.AbstractEventPipeline.setupPipeline(AbstractEventPipeline.java:164)
	at org.apache.cocoon.components.pipeline.CachingEventPipeline.setup(CachingEventPipeline.java:255)
	at org.apache.cocoon.components.pipeline.CachingEventPipeline.generateKey(CachingEventPipeline.java:110)
	at org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingStreamPipeline.java:273)
	at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:4411)
	at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:1390)
	at org.apache.cocoon.sitemap.Handler.process(Handler.java:175)
	at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:94)
	at org.apache.cocoon.Cocoon.process(Cocoon.java:293)
	at org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:471)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
	at org.apache.tomcat.core.Handler.service(Handler.java:287)
	at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
	at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)
	at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
	at org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection(Ajp12ConnectionHandler.java:166)
	at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
	at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
	at java.lang.Thread.run(Thread.java:498)
org.apache.cocoon.components.language.LanguageException: Error compiling risposta_elenco_xsp:
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:1317: Invalid expression statement.
                    (_esql_query.resultset.getInt("count"))
                    ^
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:3081: Invalid expression statement.
                  (_esql_query.resultset.getInt("count"))
                  ^
Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/risposta_elenco_xsp.java:4814: Invalid expression statement.
                (_esql_query.resultset.getInt("count"))
                ^

	at org.apache.cocoon.components.language.LanguageException.<init>(LanguageException.java:21)
	at org.apache.cocoon.components.language.programming.java.JavaLanguage.compile(JavaLanguage.java:203)
	at org.apache.cocoon.components.language.programming.CompiledProgrammingLanguage.load(CompiledProgrammingLanguage.java:131)
	at org.apache.cocoon.components.language.generator.ProgramGeneratorImpl.generateResource(ProgramGeneratorImpl.java:243)
	at org.apache.cocoon.components.language.generator.ProgramGeneratorImpl.load(ProgramGeneratorImpl.java:158)
	at org.apache.cocoon.generation.ServerPagesGenerator.setup(ServerPagesGenerator.java:153)
	at org.apache.cocoon.components.pipeline.AbstractEventPipeline.setupPipeline(AbstractEventPipeline.java:164)
	at org.apache.cocoon.components.pipeline.CachingEventPipeline.setup(CachingEventPipeline.java:255)
	at org.apache.cocoon.components.pipeline.CachingEventPipeline.generateKey(CachingEventPipeline.java:110)
	at org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingStreamPipeline.java:273)
	at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:4411)
	at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:1390)
	at org.apache.cocoon.sitemap.Handler.process(Handler.java:175)
	at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:94)
	at org.apache.cocoon.Cocoon.process(Cocoon.java:293)
	at org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:471)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
	at org.apache.tomcat.core.Handler.service(Handler.java:287)
	at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
	at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)
	at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
	at org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection(Ajp12ConnectionHandler.java:166)
	at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
	at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
	at java.lang.Thread.run(Thread.java:498)
     


Is there some problem to use 
<esql:get-int column="1"/>
after query = "select count(*) from ........." ?
What's the mean of the error "Invalid expression statement" that cocoon2 gives me?
Thanks for your help

Marco

  ----- Original Message ----- 
  From: Adrian Geissel 
  To: cocoon-users@xml.apache.org 
  Sent: Tuesday, July 03, 2001 2:17 PM
  Subject: Re: ESQL Error!


  Use <esql:get-int column="count"/> instead
  Adrian
    I think that the error is when I use
     
    <esql:get-int column="1"/>

    after query = "select count(*) from .........".
    Where is the error?
    Can someone help me?
    Thanks
    Marco


Re: ESQL Error!

Posted by Adrian Geissel <ag...@zenark.com>.
Use <esql:get-int column="count"/> instead
Adrian
  I think that the error is when I use
   
  <esql:get-int column="1"/>

  after query = "select count(*) from .........".
  Where is the error?
  Can someone help me?
  Thanks
  Marco