----------------------------------------------------------------
BEFORE YOU POST, search the faq at <http://java.apache.org/faq/>
WHEN YOU POST, include all relevant version numbers, log files,
and configuration files. Don't make us guess your problem!!!
----------------------------------------------------------------
I have found numerous posts in the newsgroup archives and FAQ's from
people with a similar problem to the one I describe here, but so far
have found no solutions, just a lot of follow-up questions and "try
this, try that" responses.
I want to develop servlets that access a MySQL database. On my system,
MySQL is up and running. Apache, the JDK, the JSDK, JServe, and the
JServe SSI module are all functioning nicely together (amazingly
enough); I can run "normal" servlets on this setup with no problems.
THE PROBLEM
The problem is the JDBC driver, or more specifically, JServe's ability
to locate the driver. When I run a servlet which makes use of the JDBC
driver, with the following from my Java code:
// Load the MySQL driver
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
I get a "Document contains no data" in my browser, and the following
message in my /var/log/httpd/error_log file:
Unable to find Driver.class.java.lang.ClassNotFoundException:
org.gjt.mm.mysql.Driver.class
at org.apache.java.lang.AdaptiveClassLoader.loadClass
(AdaptiveClassLoader.java:437)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java)
at RandomQuote.doGet(RandomQuote.java:19)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:270)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:309)
at org.apache.jserv.JServConnection.processRequest
(JServConnection.java:314)
at org.apache.jserv.JServConnection.run
(JServConnection.java:188)
at java.lang.Thread.run(Thread.java)
MY SETUP:
Red Hat Linux 6.0
Apache 1.3
JDK 1.1.7 v 3 (I didn't get 1.2 because Blackdown only has that in
pre-release)
JSDK 2.0
Apache JServ 1.1b2
Apache JServ SSI 1.1.2
MySQL 3.22.27
mm.mysql JDBC Driver 1.2b
mm.mysql is in a directory structure like this:
<root>
mm.mysql.jdbc-1.2b
mysql_comp.jar (compressed jar file)
mysql_uncomp.jar (uncompressed jar file)
org
gjt
mm
mysql
*.class files
*.java files
My /etc/httpd/conf/jserv.properties file contains the following:
wrapper.classpath=/usr/lib/apache/ApacheJServ.jar
wrapper.classpath=/home/httpd/classes/servlet-2.0.jar
wrapper.classpath=/mm.mysql.jdbc-1.2b/mysql_uncomp.jar
There is currently nothing from the mm.mysql JDBC drivers included in
any wrapper.path or repositories directive. (Should there be??? I have
seen posts suggesting trying this, and I have tried adding the path to
this driver to those parameters, but with no success.)
WHAT I'VE ALREADY TRIED
To save time, here is a list of things I found in the FAQ's to try that
I have already tried and have not solved the problem:
- I tried recompiling the mysql_uncomp.jar file (on the possibility it
may be corrupt).
- I tried moving the .jar file into the Java class directory (and
changing both the environment classpath and wrapper classpath
accordingly), on the possibility there may be some attribute of the
mm.mysql directory that was preventing JServe from "seeing" it.
- I tried (as mentioned above) adding the path to the jar file to the
wrapper classpath. (I left it that way, even when that didn't fix the
problem because I still think it should be there.)
- I tried adding the path to the jar file to the wrapper path, in
addition to adding it to the classpath.
- I tried adding the path to the JDBC class files to the servlet zone
repositories, in addition to having the jar file in the wrapper
classpath. It was something to try, anyway.
- I tried adding the path to the JDBC jar and class files to the wrapper
file path.
MY QUESTIONS (other than, "Why isn't it working?"):
Does, or does not, JServ use the environment variables CLASSPATH, PATH,
and/or JAVA_HOME? I've seen one post that says JServ ignores the
environment variables by default and uses its wrapper settings, and
another one which says you must set the environment variables for JServ
to be able to find all the classes and Java executables. Can someone
clarify this for me?
Is there any document or Howto that deals comprehensively with all the
things that must be done to get additional librarys to work with JServ
(all the parameters that need to be set, etc.)? The installation Howto
that came with JServ is good, but it only deals with getting JServ to
work. What are some of the principals we need to be aware of when
adding java libraries to work with it?
Is there anyone "out there" who is using JServ with mm.mysql
successfully? I'd love to hear from you.
Thanks,
Kate
--
--------------------------------------------------------------
Please read the FAQ! <http://java.apache.org/faq/>
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Archives and Other: <http://java.apache.org/main/mail.html>
Problems?: [EMAIL PROTECTED]
