You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Achim Friedland <ac...@in.stud.tu-ilmenau.de> on 2000/08/20 23:44:00 UTC

MM.MySql

I'm trying to use the mm.mysql driver but it's not working
properly... What do I wrong?

My Classpath:
subspace:/usr/src/jakarta-tomcat/bin# ./startup.sh
Using classpath: .:/usr/src/jakarta-tomcat/lib/ant.jar:/usr/src/jakarta-tomcat/lib/
jasper.jar:/usr/src/jakarta-tomcat/lib/org:/usr/src/jakarta-tomcat
/lib/servlet.jar:/usr/src/jakarta-tomcat/lib/test:/usr/src/jakarta
-tomcat/lib/webserver.jar:/usr/src/jakarta-tomcat/lib/xml.jar:/usr
/src/jdk1.2.2/lib/tools.jar:/usr/src/jakarta-tomcat/lib/servlet.ja
r:/usr/src/mysql-jdbc/mysql_comp.jar

But all I get is:
Error: 500
javax.servlet.ServletException:
  Unable to load class org.gjt.mm.mysql.driver

Can it be so hard setting up mm.mysql?!

achim

--

mail: ahzf@fem-net.de
Demokratie beruht auf drei Prinzipien: auf der Freiheit des Gewissens,
auf der Freiheit der Rede und auf der Klugheit, keine der beiden
in Anspruch zu nehmen. [ Mark Twain ]
PGP: DCBF 6A6B 87A8 741C FBF8  27AC 2DBA 62D2 7A57 6D88

Can't run hello world

Posted by "Michael P. McCutcheon" <mi...@value.net>.
I've made a simple hello world type of servlet.  I've added a mike
directory, and in it a WEB_INF directory.  In that directory, I have a
web.xml file:

<?xml version="1.0" encoding="ISO-8859-1"?>

<!DOCTYPE web-app
    PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.2//EN"
    "http://java.sun.com/j2ee/dtds/web-app_2_2.dtd">

<web-app>
 <servlet>
  <servlet-name>MikeTest</servlet-name>
  <servlet-class>Test1</servlet-class>
 </servlet>
 <servlet-mapping>
  <servlet-name>MikeTest</servlet-name>
  <url-pattern>/test</url-pattern>
 </servlet-mapping>
</web-app>

and a classes directory which has a compiled version of:

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class Test1 extends HttpServlet {
 public void doGet(HttpServletRequest req, HttpServletResponse res) throws
ServletException, IOException {
  res.setContentType("text/html");
  PrintWriter out = res.getWriter();

  out.println("<html>");
  out.println("<head>");
  out.println("<title>");
  out.println("Test1 Servlet");
  out.println("</title>");
  out.println("</head>");
  out.println("<body>");
  out.println("Hello World!");
  out.println("</body>");
  out.println("</html>");

 }
}

I have also changed the server.xml file and added the following:

      <Context path="/mike"
                  docBase="webapps/mike"
                  debug="0"
                  reloadable="true" >
      </Context>

When I goto:

http://localhost:8080/mike/servlet/test

I keep getting a:

404 error.

Why is this?

What must I do to get my simple servlet to work?

Thanks,

Mike

Re: MM.MySql

Posted by Kai Müller <km...@mediadom.de>.
Hallo Achim,

maybe this code fragment can help you. Put the database in the var folder of mysql and
the driver in  the WEB-INF/lib folder of your Tomcat context.

Viele Grüße

Kai Müller

---------------
try {
         Class.forName("org.gjt.mm.mysql.Driver").newInstance();
       }
catch (Exception E) {
         System.err.println("Unable to load driver.");
        }

java.sql.Connection db =
   java.sql.DriverManager.getConnection (
   "jdbc:mysql:///databasename?user=dbuser&password=dbuserpassword");
---------------


Achim Friedland wrote:

> I'm trying to use the mm.mysql driver but it's not working
> properly... What do I wrong?
>
> My Classpath:
> subspace:/usr/src/jakarta-tomcat/bin# ./startup.sh
> Using classpath: .:/usr/src/jakarta-tomcat/lib/ant.jar:/usr/src/jakarta-tomcat/lib/
> jasper.jar:/usr/src/jakarta-tomcat/lib/org:/usr/src/jakarta-tomcat
> /lib/servlet.jar:/usr/src/jakarta-tomcat/lib/test:/usr/src/jakarta
> -tomcat/lib/webserver.jar:/usr/src/jakarta-tomcat/lib/xml.jar:/usr
> /src/jdk1.2.2/lib/tools.jar:/usr/src/jakarta-tomcat/lib/servlet.ja
> r:/usr/src/mysql-jdbc/mysql_comp.jar
>
> But all I get is:
> Error: 500
> javax.servlet.ServletException:
>   Unable to load class org.gjt.mm.mysql.driver
>
> Can it be so hard setting up mm.mysql?!
>
> achim
>
> --
>
> mail: ahzf@fem-net.de
> Demokratie beruht auf drei Prinzipien: auf der Freiheit des Gewissens,
> auf der Freiheit der Rede und auf der Klugheit, keine der beiden
> in Anspruch zu nehmen. [ Mark Twain ]
> PGP: DCBF 6A6B 87A8 741C FBF8  27AC 2DBA 62D2 7A57 6D88

--

Mediadom audiovisuelle Medien GmbH
Merheimer Str. 151
D-50733 Koeln

Tel.: 0221 / 917 11 80
Fax: 0221 / 917 11 81

Internet: http://www.mediadom.de