Hi, The WEB-INF/cocoon.xconf I use has the
<datasources> <jdbc name="HWITCD"> <driver>@database-driver@</driver> <pool-controller min="1" max="10"/> <!--auto-commit>false</auto-commit--> <dburl>@database-url@</dburl> <user>@database-user@</user> <password>@database-password@</password> </jdbc> </datasources> where in the database.properties database-driver=org.gjt.mm.mysql.Driver database-url=jdbc:mysql://localhost:3306/WITCD database-user=martin database-password=martin I'm using the http://www.worldserver.com/mm.mysql -> http://mmmysql.sourceforge.net/ JDBC driver. And using Tomcat v4.0-b7 but usually is not a problem. More later, -Roger ----- Original Message ----- From: "Arda Balci" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 10, 2002 12:37 AM Subject: Re: Try this Re: Can't connect to MySQL with Cocoon 2 > Hi Roger, > > I made a clean install and then did not be able to > connect to mysql server. These are the related lines. > What can be the reason of the error? > > This is the core.log error: > > WARN (2002-05-10) 07:24.46:708 > [core.datasources.mysql_pool](/cocoon/kolon.html) > HttpProcessor[8080][3]/LogKitLogger: Could not return > Connection > org.apache.avalon.excalibur.datasource.NoValidConnectionException: > No valid JdbcConnection class available > > I copied only the necessary line. It says no valid > connection, but in the DEBUG line the Classpath > contains "D:\Program Files\Apache Tomcat > 4.0\webapps\cocoon\WEB-INF\lib\mysql.jar;", which i > downloaded yesterday. > > This is the web.xml section as stated in the userdocs: > <init-param> > <param-name>load-class</param-name> > <param-value> > org.gjt.mm.mysql.Driver > </param-value> > </init-param> > > This is the cocoon.xconf: > <datasources> > <jdbc logger="core.datasources.mysql_pool" > name="mysql_pool"> > <pool-controller max="10" min="5"/> > <dburl>jdbc:mysql://localhost/test</dburl> > <user>arda</user> > <password>arda</password> > </jdbc> > </datasources> > > This is the sitemap: > <map:match pattern="kolon.html"> > <map:generate src="mysql/kolon.xml"/> > <map:transform type="sql"> > <map:parameter name="use-connection" > value="mysql_pool"/> > </map:transform> > <map:transform src="mysql/stylesheets/sql.xsl"/> > <map:serialize/> > </map:match> > > Thank you for your attention and your time. > Arda > > > __________________________________________________ > Do You Yahoo!? > Yahoo! Shopping - Mother's Day is May 12th! > http://shopping.yahoo.com > > --------------------------------------------------------------------- > 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]>
