From cocoon-dev-return-20868-apmail-xml-cocoon-dev-archive=xml.apache.org@xml.apache.org Fri Jan 11 07:22:13 2002 Return-Path: Delivered-To: apmail-xml-cocoon-dev-archive@xml.apache.org Received: (qmail 2981 invoked by uid 500); 11 Jan 2002 07:22:12 -0000 Mailing-List: contact cocoon-dev-help@xml.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: list-post: Reply-To: cocoon-dev@xml.apache.org Delivered-To: mailing list cocoon-dev@xml.apache.org Received: (qmail 2954 invoked from network); 11 Jan 2002 07:22:09 -0000 Subject: Re: no connections in the pool To: cocoon-dev@xml.apache.org X-Mailer: Lotus Notes Release 5.0.4 June 8, 2000 Message-ID: From: "ANKUR SHAH" Date: Fri, 11 Jan 2002 12:35:27 +0530 X-MIMETrack: Serialize by Router on APP_SVR/LAUREN SOFTWARE PVT. LTD.(Release 5.0.5 |September 22, 2000) at 01/11/2002 12:35:28 PM MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii X-Server: VPOP3 V1.4.0e - Registered to: Lauren Information Technologies Private Limited X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N I have also been trying to connect to mysql database , and am experiencing the same problems as stated below. If any of you guys find the solution please do not forget to post it !! It is obvious that the internal mapping of the drivers is , somehow , not working as the declaring the & inside the XSP works fine...... org.gjt.mm.mysql.Driver jdbc:mysql://ip-address/database select f1 from test Is anyone else testing database driven web content with the latest cvs cocoon HEAD? It is starting to frustrate me that what was fairly easy to get up and running before is now making me struggle. > Roger I Martin PhD wrote: > > > The current cvs of Cocoon2 produces the exception > > > > > > > > Original exception : java.lang.RuntimeException: Could not get the > > datasource > > org.apache.avalon.excalibur.datasource.NoAvailableConnectionException: > > There are no connections in the pool, check your settings. > > > > is your Driver loaded? > After firing up tomcat and the webapp the mm.mysql-2.0.4-bin.jar is not possible to delete because it is in use. I have tried hsqldb and M$ Access databases and get the same exception. I've looked at the table of contents of the mm.mysql-2.0.4-bin.jar and the driver is there. > Are you using the oracle.jdbc.driver.OracleDriver tag > in the configuration? Is the driver jar in the WEB-INF/lib directory? > Does the jar have a ".jar" extension? > The deployed cocoon.xconf has the following datasources defined. org.gjt.mm.mysql.Driver jdbc:mysql:///WITCD user password and the M$ Access version is sun.jdbc.odbc.JdbcOdbcDriver jdbc:odbc:Materials when I deploy with it. The stack trace starts with: Original exception : java.lang.RuntimeException: Could not get the datasource org.apache.avalon.excalibur.datasource.NoAvailableConnectionException: There are no connections in the pool, check your settings. at org.apache.cocoon.www.dba.material_xsp.generate(material_xsp.java:281) at org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerPagesGenerator.java:229) at org.apache.cocoon.components.pipeline.CachingEventPipeline.process(CachingEventPipeline.java:210) at org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingStreamPipeline.java:358) at org.apache.cocoon.www.sitemap_xmap.wildcardMatchN103F1(sitemap_xmap.java:6218) at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:2850) at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:2411) at org.apache.cocoon.sitemap.Handler.process(Handler.java:171) at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:115) at org.apache.cocoon.sitemap.SitemapManager.process(SitemapManager.java:144) at org.apache.cocoon.Cocoon.process(Cocoon.java:605) at org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:795) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) ... The java source is generated in the tomcat work directory and compiles successfully. > The most common cause for this is that the server is not finding the > class. Some Servlet Containers do not load jars that do not have the > ".jar" interface. You either need to place the driver jar in the > WEB-INF/lib directory or in $JAVA_HOME/jre/lib/ext directory. You cannot > ever assume that classes loaded by the server are accessible by the webapps. > I've cvs'ed a brand new xml-cocoon2 everyday over the last few weeks and excalibur was changing and the logkit had some bugs so I am inclined to think there is a bug occuring in excalibur too. When a driver is not suitable(not loaded) then java.sql will catch a stack like this: java.sql.SQLException: No suitable driver at java.sql.DriverManager.getConnection(DriverManager.java:535) at java.sql.DriverManager.getConnection(DriverManager.java:174) ... which is more meaningful than the above excalibur NoAvailableConnectionException. Does this excalibur exception encompass more than one possible action that can throw it? Regards, Ankur. --------------------------------------------------------------------- To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org For additional commands, email: cocoon-dev-help@xml.apache.org