Hopefully someone can help me ?

Followed the advice in cocoon-2.0.2\docs\installing\index.html, i.e.
created the endorsed directory, copied xerces xalan and xml-apis

Build clean then build installwar

Compile falls over EsqlConnection, saying it should be declared abstract due
to missing methods.
Discovered some commented-out methods which seem to implement the missing
methods - e.g. setSavePoint, setHoldability
Uncommented those lines
Also noticed a line which read /*  */ between setLimitMetod and
createStatement - wondered about this, whether I should comment out some
lines as well as uncommenting those I just mentioned, but could see clearly
what I should do so I left it ??!!

Build installwar now worked
Tomcat now runs cocoon mostly OK, but ESQL example doesn't work.

Specifically it's POOLING that doesn't work !

http://localhost:8080/cocoon/xsp/esql results in

java.lang.RuntimeException: Could not get the datasource
org.apache.avalon.excalibur.datasource.NoValidConnectionException: No valid
JdbcConnection class available
at
org.apache.cocoon.www.file_.X_.jakarta_tomcat_4_0_4b1.webapps.cocoon.docs.sa
mples.xsp.esql_xsp.generate(X:\jakarta-tomcat-4.0.4b1\work\localhost\cocoon\
cocoon-files\org/apache/cocoon/www/file_/X_/jakarta_tomcat_4_0_4b1/webapps/c
ocoon/docs/samples/xsp\esql_xsp.java:341)
at
org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerPagesGenera
tor.java:260)
at
org.apache.cocoon.components.pipeline.CachingEventPipeline.process(CachingEv
entPipeline.java:251)
at
org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingS
treamPipeline.java:399)
at
org.apache.cocoon.www.file_.X_.jakarta_tomcat_4_0_4b1.webapps.cocoon.sitemap
_xmap.matchN400552(X:\jakarta-tomcat-4.0.4b1\work\localhost\cocoon\cocoon-fi
les\org/apache/cocoon/www/file_/X_/jakarta_tomcat_4_0_4b1/webapps/cocoon\sit
emap_xmap.java:6975)
at
org.apache.cocoon.www.file_.X_.jakarta_tomcat_4_0_4b1.webapps.cocoon.sitemap
_xmap.process(X:\jakarta-tomcat-4.0.4b1\work\localhost\cocoon\cocoon-files\o
rg/apache/cocoon/www/file_/X_/jakarta_tomcat_4_0_4b1/webapps/cocoon\sitemap_
xmap.java:3003)
at
org.apache.cocoon.www.file_.X_.jakarta_tomcat_4_0_4b1.webapps.cocoon.sitemap
_xmap.process(X:\jakarta-tomcat-4.0.4b1\work\localhost\cocoon\cocoon-files\o
rg/apache/cocoon/www/file_/X_/jakarta_tomcat_4_0_4b1/webapps/cocoon\sitemap_
xmap.java:2489)
at org.apache.cocoon.sitemap.Handler.process(Handler.java:222)
at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:179)
at org.apache.cocoon.sitemap.SitemapManager.process(SitemapManager.java:154)
at org.apache.cocoon.Cocoon.process(Cocoon.java:575)
at org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:998)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

etc

If I replace the <esql:pool> with ...

<!--     <esql:pool>personnel</esql:pool>-->
<esql:driver>org.hsqldb.jdbcDriver</esql:driver>
<esql:dburl>jdbc:hsqldb:hsql://localhost:9002</esql:dburl>
<esql:username>sa</esql:username>
<esql:password></esql:password>

... then the example works.

Can anyone help me to get pooing to work ?

Is it something I did/didn't do to EsqlConnection.java ?? Something to do
with the limitMethod stuff ??

Thanks,

Christopher


---------------------------------------------------------------------
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]>

Reply via email to