Tell us, version of Cocoon and JDK. Have you compiled Cocoon by yourself and under what JDK ?
-----Original Message----- From: Derek Hohls [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 8:39 AM To: [EMAIL PROTECTED] Subject: Re: Database connection problem 1) The jdbc driver file is loaded under: WEB-INF/classes/.... 2) The xconf file contains: <datasources> <jdbc name="my_connection"> <pool-controller min="5" max="10"/> <auto-commit>true</auto-commit> <dburl>jdbc:mysql://localhost:3306/mydbase</dburl> <user>foo</user> <password>bar</password> </jdbc> </datasources> 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 >>> [EMAIL PROTECTED] 26/03/2002 05:11:18 >>> 1) You must have jdbc driver file in classpath 2) Check your cocoon.xconf for <datasources>...</datasources> 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" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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; > <init-param> > <param-name>load-class</param-name> > <param-value>org.gjt.mm.mysql.Driver</param-value> > </init-param> > > 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. <http://xml.apache.org/cocoon/faqs.html> > > To unsubscribe, e-mail: <[EMAIL PROTECTED]> > For additional commands, e-mail: <[EMAIL PROTECTED]> > > --------------------------------------------------------------------- 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]> --------------------------------------------------------------------- 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]> --------------------------------------------------------------------- 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]>
