Return-Path: Delivered-To: apmail-xml-cocoon-users-archive@xml.apache.org Received: (qmail 72267 invoked by uid 500); 10 Oct 2001 16:41:55 -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 72240 invoked from network); 10 Oct 2001 16:41:54 -0000 Message-ID: <3BC4CE9C.4E44E473@communicraft.com> Date: Wed, 10 Oct 2001 17:41:32 -0500 From: Colm O'Riordan Reply-To: colmor@communicraft.com Organization: Communicraft X-Mailer: Mozilla 4.73 [en] (WinNT; I) X-Accept-Language: en MIME-Version: 1.0 To: cocoon-users@xml.apache.org Subject: Re: MySQL Drivers - Cocoon 1.8.2 References: <937B9574F4A2A344812CB180F5B5D25E18A72F@corpmail.eduprise.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N Problem Solved. I had implemented that fix for version2.0.1of the driver and it had'nt worked, because I had neglected to switch the top line of the DBadapter part to include DBMM instead of DBMySql (ie. I had altered the line to read : processor.xsp.pool.database.adaptor.DBMM=org.gjt.mm.mysql.Driver - but messed up by not editing the top line which references each of the adapters - processor.xsp.pool.database.adaptor=DBWeblogic,DBOracle,DBMySql - where I should have also replaced DBMySql with DBMM. This was a bit of a "doh!" on my part. A note however - this bug is reported as fixed for versions 2.0.2 and up, but still the fix needed to be implemented for version 2.0.4 - so just to give a general heads up on that. Thanks for all the helpful suggestions. I will send out the url of the site when it goes live ! ColmOR. Marty McClelland wrote: > Hello Colm - > > I am currently running Cocoon1.8.2 and MySQL on linux, windows 98, and > windows nt. > > Did you make the change in the properties file I suggested last week? > To put in the Cocoon.properties file: > processor.xsp.pool.database.adaptor.DBMM=org.gjt.mm.mysql.Driver > > This is a documented bug in the cocoon.properties file for mysql. > > marty > > > -----Original Message----- > > From: Colm O'Riordan [mailto:colmor@communicraft.com] > > Sent: Monday, October 08, 2001 8:19 PM > > To: cocoon-users@xml.apache.org > > Subject: Re: MySQL Drivers - Cocoon 1.8.2 > > > > > > Hi Adam, > > > > Unfortunately I am beginning to think my problem is more > > serious. I have tried setting > > the classpath several places using the driver you pointed me to. > > I even tried unpacking the jar at the same locations, and > > passing the jar into the > > jre/lib/ext directory but no results. > > I will continue to retrace my tracks and let you know the outcome. > > As I say I am relatively new to Linux so it could be > > something outside of Cocoon that > > is causing the problem. > > In the meantime, if anyone could suggest an alternative JDBC > > driver for mysql that > > would be great. > > > > Cheers, > > Colm. > > > > > > Parc Place wrote: > > > > > Hi Colm, > > > > > > I've only been using C2, but the MySQL drivers are not > > included with C2, > > > I had to download and install them manually. Maybe they are provided > > > with C1, you could check the library folder and see if they > > are there. > > > If not, you can find them at http://mmmysql.sourceforge.net/ > > > > > > Adam > > > > > > Colm O'Riordan wrote: > > > > > > > Hi All, > > > > > > > > I am using Cocoon, running on Linux with the MySQL > > database and have > > > > set up my own connection pool in Cocoon.properties. > > > > > > > > I point to the MySQL Driver as follows: > > > > > > > > *processor.xsp.pool.database.power.driver=org.gjt.mm.mysql.Driver* > > > > > > *processor.xsp.pool.database.power.url=jdbc:mysql:@localhost:3 > > 306?database=power* > > > > > > > > This driver location I copied from Cocoon's own properties, ie ... > > > > > > > > > > *processor.xsp.pool.database.adaptor.DBMySQL=org.gjt.mm.mysql.Driver* > > > > > > > > I am relatively new to configuring Linux boxes so I may be missing > > > > something blatantly obvious here. > > > > It is throwing the following error upon trying to display > > an XML with > > > > database calls : > > > > > > > > Error found handling the request. > > > > java.lang.RuntimeException: Error opening pooled > > connection: power: > > > > Database type org.gjt.mm.mysql.Driver not implemented. > > > > > > > > I had been assuming that if Cocoon references this Driver > > in its own > > > > properties file under the heading : > > > > *# These are the supported jdbc-drivers and their adaptors.* > > > > then pointing to these drivers in my own connection pool > > would be enough. > > > > > > > > Is there something else I should be doing ? > > > > > > > > Any help hugely appreciated at this stage ! > > > > > > > > Thanks, > > > > > > > > ColmOR. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > 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: