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:[EMAIL PROTECTED]]
Sent: Tuesday, October 16, 2001 12:21 PM
To: [EMAIL PROTECTED]
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:[EMAIL PROTECTED]
---------------------------------------------------------------------
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: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
---------------------------------------------------------------------
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: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
