I am using cocoon2.0.4 with tomcat 4.1 and j2sdk1.4.0 I am trying to set up a pooled connection with mysql using esql taglib. But Iam getting the following error. I tried connecting with both SQL server and mysql but the problem persists.
/*********************Error Message **************/ The org.apache.cocoon.www.file_.D_.Tomcat_4_1.webapps.cocoon.sitemap_xmap notifies that org.apache.cocoon.ProcessingException says: Exception in ServerPagesGenerator.generate() More precisely: org.apache.cocoon.ProcessingException: Exception in ServerPagesGenerator.generate(): java.lang.NullPointerException /**********************Stack trace************************/ org.apache.cocoon.ProcessingException: Exception in ServerPagesGenerator.generate(): java.lang.NullPointerException at org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerPagesGenerator.java:270) at org.apache.cocoon.components.pipeline.CachingEventPipeline.process(CachingEventPipeline.java:250) at org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingStreamPipeline.java:395) at org.apache.cocoon.www.file_.D_.Tomcat_4_1.webapps.cocoon.sitemap_xmap.matchN40080F(D:Tomcat 4.1workStandalonelocalhostcocooncocoon-filesorg/apache/cocoon/www/file_/D_/Tomcat_4_1/webapps/cocoonsitemap_xmap.java:10267) at org.apache.cocoon.www.file_.D_.Tomcat_4_1.webapps.cocoon.sitemap_xmap.process(D:Tomcat 4.1workStandalonelocalhostcocooncocoon-filesorg/apache/cocoon/www/file_/D_/Tomcat_4_1/webapps/cocoonsitemap_xmap.java:3844) at org.apache.cocoon.www.file_.D_.Tomcat_4_1.webapps.cocoon.sitemap_xmap.process(D:Tomcat 4.1workStandalonelocalhostcocooncocoon-filesorg/apache/cocoon/www/file_/D_/Tomcat_4_1/webapps/cocoonsitemap_xmap.java:3139) at org.apache.cocoon.sitemap.Handler.process(Handler.java:227) at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:173) at org.apache.cocoon.sitemap.SitemapManager.process(SitemapManager.java:152) at org.apache.cocoon.Cocoon.process(Cocoon.java:579) at org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:1043) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619) at java.lang.Thread.run(Thread.java:536) Caused by: java.lang.NullPointerException at org.apache.cocoon.components.language.markup.xsp.EsqlQuery.<init>(EsqlQuery.java:99) at org.apache.cocoon.www.file_.D_.Tomcat_4_1.webapps.cocoon.headlines.esql_xsp.generate(D:Tomcat 4.1workStandalonelocalhostcocooncocoon-filesorg/apache/cocoon/www/file_/D_/Tomcat_4_1/webapps/cocoon/headlinesesql_xsp.java:307) at org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerPagesGenerator.java:258) ... 40 more java.lang.NullPointerException at org.apache.cocoon.components.language.markup.xsp.EsqlQuery.<init>(EsqlQuery.java:99) at org.apache.cocoon.www.file_.D_.Tomcat_4_1.webapps.cocoon.headlines.esql_xsp.generate(D:Tomcat 4.1workStandalonelocalhostcocooncocoon-filesorg/apache/cocoon/www/file_/D_/Tomcat_4_1/webapps/cocoon/headlinesesql_xsp.java:307) at org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerPagesGenerator.java:258) at org.apache.cocoon.components.pipeline.CachingEventPipeline.process(CachingEventPipeline.java:250) at org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingStreamPipeline.java:395) at org.apache.cocoon.www.file_.D_.Tomcat_4_1.webapps.cocoon.sitemap_xmap.matchN40080F(D:Tomcat 4.1workStandalonelocalhostcocooncocoon-filesorg/apache/cocoon/www/file_/D_/Tomcat_4_1/webapps/cocoonsitemap_xmap.java:10267) at org.apache.cocoon.www.file_.D_.Tomcat_4_1.webapps.cocoon.sitemap_xmap.process(D:Tomcat 4.1workStandalonelocalhostcocooncocoon-filesorg/apache/cocoon/www/file_/D_/Tomcat_4_1/webapps/cocoonsitemap_xmap.java:3844) at org.apache.cocoon.www.file_.D_.Tomcat_4_1.webapps.cocoon.sitemap_xmap.process(D:Tomcat 4.1workStandalonelocalhostcocooncocoon-filesorg/apache/cocoon/www/file_/D_/Tomcat_4_1/webapps/cocoonsitemap_xmap.java:3139) at org.apache.cocoon.sitemap.Handler.process(Handler.java:227) at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:173) at org.apache.cocoon.sitemap.SitemapManager.process(SitemapManager.java:152) at org.apache.cocoon.Cocoon.process(Cocoon.java:579) at org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:1043) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619) at java.lang.Thread.run(Thread.java:536) /********************************My XSP Code*********************************/ <?xml version="1.0" encoding="ISO-8859-1"?> <xsp:page laguage="java" xmlns:xsp="http://apache.org/xsp"; xmlns:esql="http://apache.org/cocoon/SQL/v2";> <esql:connection> <esql:pool>headline_pool</esql:pool> <esql:execute-query> <esql:query>select * from crossword_details</esql:query> </esql:execute-query> </esql:connection> </xsp:page> /***************************cocoon.xconf entry**************************/ <jdbc name="headline_pool"> <pool-controller max="10" min="5"/> <auto-commit>true</auto-commit> <dburl>jdbc:mysql://10.1.1.164/sms</dburl> <user>sms</user> <password>sms123</password> </jdbc> /*************************sitemap entry********************************/ <map:match pattern="headlines/esql"> <map:generate src="headlines/esql.xsp" type="serverpages"/> <map:transform src="headlines/esql.xsl" /> <map:serialize/> </map:match> /**********************web.xml entry*********************************/ <init-param> <param-name>extra-classpath</param-name> <param-value>D:j2sdk1.4.0jrelibextmysql_comp.jar;D:j2sdk1.4.0jrelibextmysql_uncomp.jar</param-value> </init-param> <init-param> <param-name>load-class</param-name> <param-value> sun.jdbc.odbc.JdbcOdbcDriver org.gjt.mm.mysql.Driver </param-value> </init-param> ------------------------------------------------- Sify Mail - now with Anti-virus protection powered by Trend Micro, USA. Know more at http://mail.sify.com Sify Power mail- a Premium Service from Sify Mail! know more at http://mail.sify.com
