Re[2]: Using mm.mysql.jdbc.

[Friedrich <ft...@frontwire.com>]

Thanks, it now talks to the database. However there was another line I also had to change, it was :

processor.xsp.pool.database.adaptor=DBWeblogic,DBOracle,DBInstantDB,DBPostgres,DBSybase,DBInformix,DBMM

in addition to:

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

Now it works. Thanks, Friedrich.

> I think this is this mistake in the cocoon.properties that shipped with 
> cocoon 1.8.2, which has now been fixed (many people reported  the same 
> problem). Try changing
> 
> processor.xsp.pool.database.adaptor.DBMySQL
> to processor.xsp.pool.database.adaptor.DBMM
> 
> that's the only difference I can see.
> 
> Friedrich <ft...@frontwire.com> wrote:
> >When I access the xml page with the database requests the following is
> >outputted :
> >
> >java.lang.RuntimeException: Error opening pooled connection: default: 
> >Database
> >type org.gjt.mm.mysql.Driver not implemented
> >
> >I modified the below file for the database:
> >
> >$TOMCAT_HOME/webapps/cocoon/WEB-INF/cocoon.properties
> >
> >here is the relevent portion of that file :
> >
> >processor.xsp.pool.database.default.driver=org.gjt.mm.mysql.Driver
> >processor.xsp.pool.database.default.url=jdbc:mysql://localhost:3306/test
> >processor.xsp.pool.database.default.username=myuser
> >processor.xsp.pool.database.default.password=mypassword
> >processor.xsp.pool.database.default.maxConnections=3
> >processor.xsp.pool.database.default.expiryTime=3600000
> >
> >processor.xsp.pool.database.adaptor.DBMySQL=org.gjt.mm.mysql.Driver
> >
> >The driver itself is :
> >
> >/usr/local/tomcat/lib/mm.mysql.jdbc.jar
> >
> >Do edited the $TOMCAT_HOME/conf/cocoon.properties as well but that has no
> >effect. When tomcat starts up it prints out my classpath and
> >mm.mysql.jdbc.jar is in it as :
> >
> >/usr/local/tomcat/lib/mm.mysql.jdbc.jar
> >
> >I cannot see what I am doing wrong and any help would be greatly 
> >appreciated.
> >
> >Thanks for your time, Friedrich.
> >
> >---------------------------------------------------------------------
> >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: <co...@xml.apache.org>
> >For additional commands, e-mail: <co...@xml.apache.org>
> >
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>