You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Nalini T <na...@sify.com> on 2003/06/13 10:59:15 UTC
[Pls help! urgent] Apache Cocoon: ESQL Taglib db connection failure
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
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org