which the ant task comments out if it FAILS to detect jdbc3 present.
at org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerPagesGenerator.java:272)
at org.apache.cocoon.components.pipeline.CachingEventPipeline.process(CachingEventPipeline.java:251)
at org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingStreamPipeline.java:399)
at org.apache.cocoon.www.sitemap_xmap.matchN400552(X:\jakarta-tomcat-4.0.4b1\work\localhost\cocoon\cocoon-files\org/apache/cocoon/www\sitemap_xmap.java:6975)
at org.apache.cocoon.www.sitemap_xmap.process(X:\jakarta-tomcat-4.0.4b1\work\localhost\cocoon\cocoon-files\org/apache/cocoon/www\sitemap_xmap.java:3003)
at org.apache.cocoon.www.sitemap_xmap.process(X:\jakarta-tomcat-4.0.4b1\work\localhost\cocoon\cocoon-files\org/apache/cocoon/www\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)
From: von Schwerdtner, Thomas (GXS, FPI) [mailto:[EMAIL PROTECTED]]
Sent: 27 March 2002 18:45
To: '[EMAIL PROTECTED]'
Subject: RE: Cocoon 2.0.2 JDK1.4 Tomcat 4.0.4b1 JDBC Connection Pooling Doesn't Work (for me) - any ideas
I don't know about your compile problems, but I do know that JDBC connections are fairly problematic with jdk1.4 since they changed some things. I had no problems building the CVS a few weeks ago, but the ESQL samples didnt work for me and I could not get the PostgreSQL jdbc driver to work either (despite comments that it would work with 1.4). I had to switch back to 1.3 to get everything I needed to work.
HTH,
-Tom
> -----Original Message-----
> From: Christopher Watson [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 27, 2002 11:46 AM
> To: Cocoon-Users (E-mail)
> Subject: Cocoon 2.0.2 JDK1.4 Tomcat 4.0.4b1 JDBC Connection Pooling
> Doesn't Work (for me) - any ideas
>
>
> 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.NoValidConnectionExcept
> ion: 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\loc
> alhost\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(Ser
> verPagesGenera
> tor.java:260)
> at
> org.apache.cocoon.components.pipeline.CachingEventPipeline.pro
> cess(CachingEv
> entPipeline.java:251)
> at
> org.apache.cocoon.components.pipeline.CachingStreamPipeline.pr
> ocess(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\co
> coon\cocoon-fi
> les\org/apache/cocoon/www/file_/X_/jakarta_tomcat_4_0_4b1/weba
> pps/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/c
> ocoon\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/c
> ocoon\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(SitemapManage
> r.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]>
>
