cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "von Schwerdtner, Thomas (GXS, FPI)" <Thomas.vonSchwerdt...@gxs.ge.com>
Subject RE: Cocoon 2.0.2 JDK1.4 Tomcat 4.0.4b1 JDBC Connection Pooling Do esn't Work (for me) - any ideas
Date Wed, 27 Mar 2002 18:44:35 GMT
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:cwatson@taraserv.demon.co.uk]
> 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: <cocoon-users-unsubscribe@xml.apache.org>
> For additional commands, e-mail: <cocoon-users-help@xml.apache.org>
> 

Mime
View raw message