Re: esql connection defined in cocoon.properties [mm.mysql] and getting nullpointerException

[Matthias Brunner <mb...@blumenstrasse.vol.at>]

Pål Wester wrote:
> 
> # These are your database settings, look in the
> # org.apache.turbine.util.db.pool.* package for more information.
> processor.xsp.pool.database.quart.driver=org.gjt.mm.mysql.Driver
> processor.xsp.pool.database.quart.url=jdbc:mysql://localhost:3306/quart
> processor.xsp.pool.database.quart.username=quartuser
> processor.xsp.pool.database.quart.password=quartpasswd
> processor.xsp.pool.database.quart.maxConnections=10
> processor.xsp.pool.database.quart.expiryTime=3600000
> 
> # These are the supported jdbc-drivers and their adaptors.
> # These properties are used by the DBFactory.
> processor.xsp.pool.database.adaptor=DBMM
> processor.xsp.pool.database.adaptor.DBMM=org.gjt.mm.mysql.Driver
> 
> 1. would this work, does it look sane??
> 
> In all my xml pages I have:
> <esql:connection>
>         <esql:driver>org.gjt.mm.mysql.Driver</esql:driver>
>         <esql:dburl>jdbc:mysql://localhost:3306/quart</esql:dburl>
>         <esql:username>quartuser</esql:username>
>         <esql:password>quartpasswd</esql:password>
> 
> I've changed this to:
> <esql:connection>
>         <esql:pool>quart</esql:pool>

I can confirm similar to work in Coccon 1.8.2 (Apache Jserv 1.1.2,
mm.mysql-2.0.4, mySQL 3.23.27-beta, IBM JDK 1.3)

Maybe the pool log gives you more information, uncomment the
processor.xsp.pool.logfile directive in cocoon.properties.

Best regards!
-- 
Matthias Brunner <mb...@blumenstrasse.vol.at>
PGP FP 7862 32B3 3B75 292A F76F  5042 8587 21AB 5B89 D501
Check out http://blumenstrasse.vol.at/~mb/gpgkey.asc