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