cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Peter Choe <choep...@mindspring.com>
Subject esql connection error
Date Mon, 18 Aug 2003 15:40:38 GMT
I am just starting out using cocoon and am trying to use esql database tags.

i have cocoon 2.0.4 running on tomcat 4.1.18 and postgresql 7.3.

i have configured the cocoonc.xconf with the following:

    <jdbc name="directory-pool">
      <pool-controller min="1" max="60" />
      <dburl>jdbc:postgresql://localhost/directory</dburl>
      <user>user_id</user>    
      <password>mypass</password>
    </jdbc>

and set-up the web.xml with:

    <init-param>
      <param-name>load-class</param-name>
      <param-value>
        <!-- For IBM WebSphere:
        com.ibm.servlet.classloader.Handler -->

        <!-- For Database Driver: -->
        org.hsqldb.jdbcDriver
        org.postgresql.Driver
        <!-- For parent ComponentManager sample:
        org.apache.cocoon.samples.parentcm.Configurator
        -->
      </param-value>

i have an xsp that should connect to the database and create an xml file:
<xsp:page language="java" xmlns:xsp="http://apache.org/xsp" 
xmlns:esql="http://apache.org/cocoon/SQL/v2">

<records>
   <esql:connection>
      <esql:execute-query>
         <esql:pool>directory-pool</esql:pool>
         <esql:query>SELECT * FROM department</esql:query>
         <esql:results>
            <esql:row-results>
               <record><esql:get-columns /></record>
            </esql:row-results>
         </esql:results>
         <esql:update-results />
         <esql:no-results />
         <esql:error-results />
      </esql:execute-query>
   </esql:connection>
</records>
</xsp:page>

but when i try to get the xml document, i get the following error in the 
access.log
ERROR   (2003-08-18) 11:34.19:920   [access] 
(/test/directory/directory.xml) Thread-8/CocoonServlet: Problem with 
Cocoon servlet
org.apache.cocoon.ProcessingException: Exception in 
ServerPagesGenerator.generate(): java.lang.RuntimeException: Error 
opening connection to dburl: : The user property is missing. It is 
mandatory.
        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.sitemap_xmap.matchN1007C(sitemap_xmap.java:878)
        at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:569)
        at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:415)
        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:260)
        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:170)
        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:432)
        at 
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:386)

as far as i can tell i have the user set up in the cocoon.xconf.

what user property is the error referring to and where should i add it?

Peter Choe





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


Mime
View raw message