cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From annemarie.hartvig...@telenor.com
Subject FW: database connection
Date Thu, 02 Aug 2001 11:06:10 GMT
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: 'cocoon-users@xml.apache.org'
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:lmorley@WPI.EDU]
Sent: 2. august 2001 09:57
To: cocoon-users@xml.apache.org
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 annemarie.hartvigsen@telenor.com 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: <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>

---------------------------------------------------------------------
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