cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nalini T <nalini_th...@sify.com>
Subject [Pls help! urgent] Apache Cocoon: ESQL Taglib db connection failure
Date Fri, 13 Jun 2003 08:59:15 GMT
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

Mime
View raw message