Re: C1: ESQL: Pooling with mySQL?

[Derek Hohls]

I made changes, restarted Apache/Tomcat and now have :   processor.xsp.pool.database.adaptor=DBWeblogic,DBOracle,DBInstantDB,DBPostgres,DBSybase,DBInformix,DBMM processor.xsp.pool.database.adaptor.DBWeblogic=weblogic.jdbc.pool.Driver processor.xsp.pool.database.adaptor.DBOracle=oracle.jdbc.driver.OracleDriver processor.xsp.pool.database.adaptor.DBInstantDB=org.enhydra.instantdb.jdbc.idbDriver processor.xsp.pool.database.adaptor.DBPostgres=postgresql.Driver processor.xsp.pool.database.adaptor.DBInformix=com.informix.jdbc.IfxDriver processor.xsp.pool.database.adaptor.DBSybase=com.sybase.jdbc.SybDriver processor.xsp.pool.database.adaptor.DBMM=org.gjt.mm.mysql.Driver   and the error has changed to:   java.lang.RuntimeException: Error opening pooled connection: indicators: No suitable driver (I also tried DBMySQL with out success...)   >>> [EMAIL PROTECTED] 30/08/2001 01:44:47 >>> You need to add a line in your cocoon.properties file. Check this and compare with your cocoon.properties file # These are the supported jdbc-drivers and their adaptors. # These properties are used by the DBFactory. processor.xsp.pool.database.adaptor=DBWeblogic,DBOracle,DBInstantDB,DBPostgres,DBSybase,DBInformix,DBMM processor.xsp.pool.database.adaptor.DBWeblogic=weblogic.jdbc.pool.Driver processor.xsp.pool.database.adaptor.DBOracle=oracle.jdbc.driver.OracleDriver processor.xsp.pool.database.adaptor.DBInstantDB=org.enhydra.instantdb.jdbc.idbDriver processor.xsp.pool.database.adaptor.DBPostgres=postgresql.Driver processor.xsp.pool.database.adaptor.DBInformix=com.informix.jdbc.IfxDriver processor.xsp.pool.database.adaptor.DBSybase=com.sybase.jdbc.SybDriver processor.xsp.pool.database.adaptor.DBMM=org.gjt.mm.mysql.Driver > When I try to use connection pooling rather than "in page" logic, I > get an error. > >  > > I had: > >   <esql:driver>org.gjt.mm.mysql.Driver</esql:driver> >   <esql:dburl><xsp:expr>DBName</xsp:expr></esql:dburl> >   <esql:username><xsp:expr>DBUser</xsp:expr></esql:username> >   <esql:password><xsp:expr>DBPass</xsp:expr></esql:password> > > which worked fine... > >  > > and now have changed to: > >  > > <esql:pool>mydb</esql:pool> > >  > > where mydb is specified in the cocoon.properties file as: > >  > > processor.xsp.pool.database.mydb.driver=org.gjt.mm.mysql.Driver > processor.xsp.pool.database.mydb.url=jdbc:mysql:localhost/mydb > processor.xsp.pool.database.mydb.username=user > processor.xsp.pool.database.mydb.password=pass > processor.xsp.pool.database.mydb.maxConnections=10 > processor.xsp.pool.database.mydb.expiryTime=3600000 > >  > > The error I get is : > >  > > java.lang.RuntimeException: > > Error opening pooled connection: mydb: > > Database type org.gjt.mm.mysql.Driver not implemented. > > What do I need to do?? > >  > > Thanks > > Derek > --------------------------------------------------------------------- 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: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>