cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From annemarie.hartvig...@telenor.com
Subject RE: Connecting database and XML pages
Date Wed, 08 Aug 2001 11:07:40 GMT
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:olivier.jeulin@xml-ais.com]
Sent: 8. august 2001 11:24
To: 'cocoon-users@xml.apache.org'
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: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>

---------------------------------------------------------------------
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: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message