cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mark S. Kent" <mark.k...@vistyx.com>
Subject RE: C2.0: connection pool/ datasource problem [interbase]
Date Fri, 19 Oct 2001 16:41:16 GMT
I'm having a similar problem with pooling setup for Interbase.  I've used
the Cocoon2 sample for ESQL to edit my page, sitemap, etc. but it still
won't work.

I've defined the datasource "cl" (that's C and L -- not C and ONE) and in
cocoon.xconf as:
  <datasources>
    <jdbc name="cl">
      <pool-controller min="5" max="10"/>

<dburl>jdbc:interbase://localhost/d:/www/interbase/data/dev01.gdb</dburl>
      <user>user</user>
      <password>pass</password>
    </jdbc>
  </datasources>

and left the "default" cocoon2 datasource of "personnel" (so the C2 samples
still work):
  <datasources>
    <jdbc name="personnel">
      <pool-controller min="5" max="10"/>
      <dburl>jdbc:hsqldb:hsql://localhost:9002</dburl>
      <user>sa</user>
      <password></password>
    </jdbc>
  </datasources>

In my XSP page I have:
<?xml version="1.0" encoding="ISO-8859-1"?>
<xsp:page
    language="java"
    xmlns:xsp="http://apache.org/xsp"
    xmlns:esql="http://apache.org/cocoon/SQL/v2"
>
    <page>
        <pagetitle>Employees Working Report</pagetitle>
    <esql:connection>
        <esql:pool>cl</esql:pool>
        <esql:execute-query>
            <esql:query>select * from employee</esql:query>
            <esql:results>
                <esql:row-results>
                    <employee>
                        <lastname><esql:get-string
column="last_name"/></lastname>
                        <firstname><esql:get-string
column="first_name"/></firstname>
                        <empid><esql:get-string
column="employee_id"/></empid>
                        <esql:no-results>
                            <user>No one is working</user>
                        </esql:no-results>
                    </employee>
                </esql:row-results>
            </esql:results>
      </esql:execute-query>
    </esql:connection>
    </page>
</xsp:page>

I am getting this error in my cocoon.log file when my XSP page tries to use
the pool:
ExcaliburComponentSelector: datasources: ComponentSelector could not find
the component for hint: cl
working4_xsp: Could not get the datasource
org.apache.avalon.framework.component.ComponentException: datasources:
ComponentSelector could not find the component for hint: cl

If I change the XSP page to use these lines in place of the "esql:pool"
lines, it works:
        <esql:driver>interbase.interclient.Driver</esql:driver>

<esql:dburl>jdbc:interbase://localhost/d:/www/interbase/data/dev01.gdb</esql
:dburl>
        <esql:username>user</esql:username>
        <esql:password>pass</esql:password>

Russell, did you get yours to work?

Thanks!
Mark

-----Original Message-----
From: Russell Castagnaro [mailto:russell@castagnaro.com]
Sent: Tuesday, October 16, 2001 12:21 PM
To: cocoon-users@xml.apache.org
Subject: C2.0: connection pool/ datasource problem


Aloha folks,

I'm having a strange problem with C2 for All db connections

I've tried using mysql and oracle and they both have the same
problem..

I'm preloading the driver classes and I've tested my db connections.
The error I get when using the esql taglib is:

org.apache.cocoon.ProcessingException: Exception in
ServerPagesGenerator.generate():
java.lang.RuntimeException: Could not get the datasource
java.sql.SQLException:
There are no connections in the pool, check your settings.
at
org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerPagesGenera
tor.java:187)
at
org.apache.cocoon.components.pipeline.CachingEventPipeline.process(CachingEv
entPipeline.java:214)
at
org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingS
treamPipeline.java:364)
at
org.apache.cocoon.www.sitemap_xmap.wildcardMatchN40043E(sitemap_xmap.java:57
40)
at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:2593)
at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:2205)
at org.apache.cocoon.sitemap.Handler.process(Handler.java:163)

Why wouldn't any connections be available?

I'm using:

  <datasources>
    <jdbc name="fun">
      <pool-controller min="5" max="10" oradb="true"/>
      <dburl>jdbc:oracle:thin:@localhost:1521:ORCL</dburl>
      <user>scott</user>
      <password>tiger</password>
    </jdbc>

    and
<?xml version="1.0" encoding="ISO-8859-1"?>

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

  <page>
   <title>A Database Driven XSP Page</title>
   <content>

   <esql:connection>
     <esql:pool>fun</esql:pool>
     <esql:execute-query>
       <esql:query>Select * from EMP</esql:query>
       <esql:results>
         <esql:row-results>
           <para><esql:get-string column="ename"/></para>
           <esql:get-columns/>
         </esql:row-results>
       </esql:results>
     </esql:execute-query>
   </esql:connection>

   </content>
  </page>
</xsp:page>
</xsp:page>

any ideas??





--
Best regards,
 Russell                          mailto:russell@castagnaro.com


---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>

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


---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>

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


Mime
View raw message