JDBC with Tomcat and Cocoon

[an...@telenor.com]

Hi all,

I have 
Linux RedHat
Apache 1.3.19
Tomcat 3.2.2
Cocoon 1.8.2
mySQL 3.23.40-1

I'm trying to connect my websites to the mysqldatabase. I cannot get my own
code to work. I cannot get the cocoon 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 downloaded mm.mysql-2.0.4-bin.jar and put it in /var/tomcat/lib/

Below is excerpts from /var/tomcat/bin/startup.sh and
/var/tomcat/webapps/cocoon/WEB-INF/cocoon.properties


(Another thing to note is that I made an XSP page that is supposed to return
# of times it has been requested, but it has only returned 0. Then it
suddenly returned 1 instead, and has done so ever since (I have not altered
the code - the code follows the example at
http://www.suranyami.com/XSPtutorial/ and the logic is simply 

...
static private int counter = 0;
private synchronized int count() {
return counter++;
}
</xsp:logic>
<page>
<p>I've been requested <xsp:expr>count()</xsp:expr> times.</p>
...

Any suggestions?)



OK, here are my file excerpts:

>From tomcat.sh:

---------------------------------------------------------------------------


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


----------------------------------------------------------------------------



>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