RE: MySQL Drivers - Cocoon 1.8.2

[Marty McClelland <mm...@eduprise.com>]

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/ilumi
na
processor.xsp.pool.database.iluminaPool.username=mmarty
processor.xsp.pool.database.iluminaPool.password=**********
 
marty

-----Original Message-----
From: Colm O'Riordan [mailto:colmor@communicraft.com]
Sent: Friday, October 05, 2001 7:29 PM
To: cocoon-users@xml.apache.org
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?databas
e=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.