I did as you said, but I still get the same error message.
The error message I get is referring to this section of cocoon.properties:
----
# Turbine DB Connection Pool
############################
# These are your database settings, look in the
# org.apache.turbine.util.db.pool.* package for more information.
# Inserted 01-08-2001:
processor.xsp.pool.database.annemarie.driver=org.gjt.mm.mysql.Driver
<---------
-----------------
Just to try something I changed the above line to:
-----------
processor.xsp.pool.database.annemarie.driver=DBMySQL
------------
and I got the error message
--------------
java.lang.RuntimeException: Error opening pooled connection: annemarie:
Database type DBMySQL not implemented.
(....)
---------------
So do you have any idea what I should do?
Note: I have always have been able to connect to the database using user ID
& pwd, regardless of the changes done.
/Anne Marie
-----Original Message-----
From: JEULIN Olivier [mailto:[EMAIL PROTECTED]]
Sent: 8. august 2001 11:24
To: '[EMAIL PROTECTED]'
Subject: RE: Connecting database and XML pages
> I tried to implement your example, but can't get the
> connection pooling to
> work (I guess). It _works_ when I _don't_ use pooling, so I
> can't understand
> what's wrong. The driver is mm.mysql 2.0.4 and is located in
> TOMCAT_HOME/lib.
>
> Below is the error message and cocoon.properties:
>
> ---------------------------------------
> Error found handling the request.
> java.lang.RuntimeException: Error opening pooled connection:
> annemarie:
> Database type org.gjt.mm.mysql.Driver not implemented.
(snip)
>
> ------------------
> From my cocoon.properties:
> ------------------------
>
> # Turbine DB Connection Pool
> ############################
(snip)
> # These are the supported jdbc-drivers and their adaptors.
> # These properties are used by the DBFactory.
>
> #Inserted 01-08-2001:
> processor.xsp.pool.database.adaptor=DBMM
> processor.xsp.pool.database.adaptor.DBMM=org.gjt.mm.mysql.Driver
oops, you define the driver twice ----^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> processor.xsp.pool.database.adaptor=DBWeblogic,DBOracle,DBInst
> antDB,DBPostgr
> es,DBSybase,DBInformix,DBMySQL
> processor.xsp.pool.database.adaptor.DBWeblogic=weblogic.jdbc.p
> ool.Driver
> processor.xsp.pool.database.adaptor.DBOracle=oracle.jdbc.drive
> r.OracleDriver
> processor.xsp.pool.database.adaptor.DBInstantDB=org.enhydra.in
> stantdb.jdbc.i
> dbDriver
> processor.xsp.pool.database.adaptor.DBPostgres=postgresql.Driver
> processor.xsp.pool.database.adaptor.DBInformix=com.informix.jd
> bc.IfxDriver
> processor.xsp.pool.database.adaptor.DBSybase=com.sybase.jdbc.SybDriver
> processor.xsp.pool.database.adaptor.DBMySQL=org.gjt.mm.mysql.Driver
oops, you define the driver twice ----^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
(and the last definition is taken into account)
you must have only one definition of the driver, so
rename DBMM to DBMySQL in
processor.xsp.pool.database.adaptor=DBMM
and delete the line
processor.xsp.pool.database.adaptor.DBMM=org.gjt.mm.mysql.Driver
(I'm *very* sorry for the trouble, I've renamed DBMySQL to DBMM and
suppressed the other drivers definitions for tests , and forgot to change it
back in my configuration)
Olivier
---------------------------------------------------------------------
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]>
---------------------------------------------------------------------
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]>
