Sorry, the info from tomcat.sh is of course:
-----------------------------------------------
oldCP=$CLASSPATH
unset CLASSPATH
CLASSPATH=.
CLASSPATH=${CLASSPATH}:${TOMCAT_HOME}/lib/sax-bugfix.jar
CLASSPATH=${CLASSPATH}:${TOMCAT_HOME}/lib/xerces_1_2.jar
CLASSPATH=${CLASSPATH}:${TOMCAT_HOME}/lib/xalan_1_2_D02.jar
CLASSPATH=${CLASSPATH}:${TOMCAT_HOME}/lib/fop_0_15_0.jar
CLASSPATH=${CLASSPATH}:${TOMCAT_HOME}/lib/cocoon.jar
CLASSPATH=${CLASSPATH}:${TOMCAT_HOME}/lib/w3c.jar
CLASSPATH=${CLASSPATH}:${TOMCAT_HOME}/lib/turbine-pool.jar
CLASSPATH=${CLASSPATH}:${TOMCAT_HOME}/lib/mm.mysql-2.0.4-bin.jar
for i in ${TOMCAT_HOME}/lib/* ; do
if [ "$CLASSPATH" != "" ]; then
CLASSPATH=${CLASSPATH}:$i
else
CLASSPATH=$i
fi
done
-----------------------------------------------
Sorry about that!!
/AM
-----Original Message-----
From: Hartvigsen Anne Marie (FoU)
Sent: 2. august 2001 10:34
To: '[EMAIL PROTECTED]'
Subject: RE: database connection
Hi,
I downloaded mm.mysql-2.0.4-bin.jar and put it in /var/tomcat/lib/
I have tried to set the path, but I'm not sure it's working. Is there a way
I can set the path when booting instead of when starting tomcat?
Anyway, here's what I did:
----------------------------------------------------------------------------
-
>From 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
processor.xsp.pool.database.annemarie.url=jdbc:mysql://localhost:3306/mysql/
annemarie
processor.xsp.pool.database.annemarie.username=root
processor.xsp.pool.database.annemarie.password=
processor.xsp.pool.database.annemarie.maxConnections=5
processor.xsp.pool.database.annemarie.expiryTime=3600000
processor.xsp.pool.database.default.driver=oracle.jdbc.driver.OracleDriver
processor.xsp.pool.database.default.url=jdbc:oracle:thin:@localhost:1521:ORC
L
processor.xsp.pool.database.default.username=dbUser
processor.xsp.pool.database.default.password=dbPass
processor.xsp.pool.database.default.maxConnections=3
processor.xsp.pool.database.default.expiryTime=3600000
# 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
processor.xsp.pool.database.adaptor=DBWeblogic,DBOracle,DBInstantDB,DBPostgr
es,DBSybase,DBInformix,DBMySQL
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.i
dbDriver
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.DBMySQL=org.gjt.mm.mysql.Driver
----------------------------------------------------------------------------
------
Thank's for your time!
/Anne Marie
-----Original Message-----
From: Liam Morley [mailto:[EMAIL PROTECTED]]
Sent: 2. august 2001 09:57
To: [EMAIL PROTECTED]
Subject: Re: database connection
It would be helpful to know if you have downloaded a MySQL database
driver, and if so, if it's included in your path.
-------
Liam Morley
"light the deep, and bring silence to the world.
light the world, and bring depth to the silence."
On Thu, 2 Aug 2001 [EMAIL PROTECTED] wrote:
> Hi all,
>
> sorry for posting this again, but I have the feeling my mistake is pretty
> trivial...
>
> I'm trying to connect my websites to a mysqldatabase. I'm using cocoon
> 1.8.2. I cannot get my own code to work. I cannot get the example codes to
> work (in cocoon/samples/sql). The error message I get every time is
>
> -------------------------------------------------------------
>
> Error found handling the request.
>
> java.lang.ClassNotFoundException:
> _var._tomcat._webapps._cocoon._vt._first_sql.
> _first_sql
> at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
> at java.security.AccessController.doPrivileged(Native Method)
> at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
> at java.lang.ClassLoader.loadClass(ClassLoader.java:297)
> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:286)
> at java.lang.ClassLoader.loadClass(ClassLoader.java:253)
> at
> org.apache.cocoon.processor.xsp.language.java.XSPClassLoader.loadCla
> ss(XSPClassLoader.java:87)
> at java.lang.ClassLoader.loadClass(ClassLoader.java:253)
> at
> org.apache.cocoon.processor.xsp.language.java.XSPJavaProcessor.load(
> XSPJavaProcessor.java:169)
> at
> org.apache.cocoon.processor.xsp.XSPProcessor.loadPage(XSPProcessor.j
> ava:542)
> at
> org.apache.cocoon.processor.xsp.XSPProcessor.process(XSPProcessor.ja
> va:523)
> at org.apache.cocoon.Engine.handle(Engine.java:384)
> at org.apache.cocoon.Cocoon.service(Cocoon.java:183)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:865)
> at
> org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:
> 405)
> at org.apache.tomcat.core.Handler.service(Handler.java:287)
> at
> org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:37
> 2)
> at
> org.apache.tomcat.core.ContextManager.internalService(ContextManager
> .java:797)
> at
> org.apache.tomcat.core.ContextManager.service(ContextManager.java:74
> 3)
> at
> org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processCo
> nnection(Ajp12ConnectionHandler.java:166)
> at
> org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java
> :416)
> at
> org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.jav
> a:501)
> at java.lang.Thread.run(Thread.java:484)
>
> ------------------------------------------------------------
>
> Any ideas what could be wrong? I know I haven't included any info. about
my
> configuration etc., but I don't know what's relevant. Please let me know!
>
> Thanx! /Anne Marie
>
>
>
> ---------------------------------------------------------------------
> 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]>
---------------------------------------------------------------------
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]>
