cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrew Timberlake <and...@timberlake.co.za>
Subject Re: esql connection error
Date Mon, 18 Aug 2003 16:02:48 GMT
Peter

The pool is defined for the connection, not the query.
ie:

<xsp:page language="java" xmlns:xsp="http://apache.org/xsp"
xmlns:esql="http://apache.org/cocoon/SQL/v2">

<records>
   <esql:connection>
      <esql:pool>directory-pool</esql:pool>
      <esql:execute-query>
         <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>

Andrew

Peter Choe wrote:
> 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
> 
> 


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


Mime
View raw message