Return-Path: Delivered-To: apmail-xml-cocoon-users-archive@xml.apache.org Received: (qmail 95682 invoked by uid 500); 27 Mar 2002 07:45:33 -0000 Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: list-post: Reply-To: cocoon-users@xml.apache.org Delivered-To: mailing list cocoon-users@xml.apache.org Received: (qmail 95667 invoked from network); 27 Mar 2002 07:45:30 -0000 From: "Sozonnik Andrew" To: Subject: RE: Database connection problem Date: Wed, 27 Mar 2002 09:42:46 +0200 Message-ID: <019903DB3641D411AABC0000B45A3F220FBB50@BD2C3> MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2616 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 In-Reply-To: <019903DB3641D411AABC0000B45A3F22403767@BD2C3> Importance: Normal Disposition-Notification-To: "Sozonnik Andrew" X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N Tell us, version of Cocoon and JDK. Have you compiled Cocoon by yourself and under what JDK ? -----Original Message----- From: Derek Hohls [mailto:DHohls@csir.co.za] Sent: Wednesday, March 27, 2002 8:39 AM To: cocoon-users@xml.apache.org Subject: Re: Database connection problem 1) The jdbc driver file is loaded under: WEB-INF/classes/.... 2) The xconf file contains:

true

jdbc:mysql://localhost:3306/mydbase foo bar

3) I am not sure what you mean by "access.log" - I only have cocoon.log and root.log in my WEB-INF/logs directory? The first enty in the cocoon.log has the line: FATAL_E (2002-03-26) 15:31.06:158 [cocoon ] (Unknown-URI) Unknown-thread/JdbcConnectionPool: Excalibur could not create any connections. Examine your settings to make sure they are correct. Make sure you can connect with the same settings on your machine. The root.log has no entries in it at all... Thanks for responding - any comments on the above?? Derek >>> demchenko@kyivstar.net 26/03/2002 05:11:18 >>> 1) You must have jdbc driver file in classpath 2) Check your cocoon.xconf for ... for pool configuration 3) See access.log for message like this DEBUG (2002-03-26) 17:04.45:713 [access] (Unknown-URI) Unknown-thread/Cocoon Servlet: Trying to load class: org.gjt.mm.mysql.Driver ----- Original Message ----- From: "Derek Hohls" To: Sent: Tuesday, March 26, 2002 4:43 PM Subject: Database connection problem > When trying to connect to a mySQL database, I get: > > Could not get the datasource java.sql.SQLException: There are no > connections in the pool, check your settings. > > I already have the setting for the driver in the web.xml; > > load-class > org.gjt.mm.mysql.Driver > > > I can also connect to, and 'see' the database with another, front-end > program. > > In fact, the connection AND database were working previously - does > anyone know if a mod_rewrite for the site in the Apache server would > affect this?? (seems strange, but thats the only major change that has > happened on the server that I know about) I have also checked the > connection without using the VirtualHost and get the same results... > > Any ideas as to what else to check? > > Thanks > Derek > > --------------------------------------------------------------------- > Please check that your question has not already been answered in the > FAQ before posting. > > To unsubscribe, e-mail: > For additional commands, e-mail: > > --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. To unsubscribe, e-mail: For additional commands, e-mail: --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. To unsubscribe, e-mail: For additional commands, e-mail: --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. To unsubscribe, e-mail: For additional commands, e-mail: