RE: MySQL Drivers - Cocoon 1.8.2

[Marty McClelland]

Try making the change below to the cocoon properties file ( change DBMySQL to DBMM ).  This worked for me.

 

processor.xsp.pool.database.adaptor.DBMM=org.gjt.mm.mysql.Driver

 

 

here's how I defined the connection pool:

 

processor.xsp.pool.database.iluminaPool.driver=org.gjt.mm.mysql.Driver
processor.xsp.pool.database.iluminaPool.url=jdbc:mysql://localhost/ilumina
processor.xsp.pool.database.iluminaPool.username=mmarty
processor.xsp.pool.database.iluminaPool.password=**********

 

marty

-----Original Message-----
From: Colm O'Riordan [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 05, 2001 7:29 PM
To: [EMAIL PROTECTED]
Subject: MySQL Drivers - Cocoon 1.8.2

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:3306?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.