JDBC Problem

[Mark Peterson]

I am experiencing a JDBC problem.

I am attempting to execute the Java servlet from chapter 13 of the book
entitled “JSP, Servlets, and MySQL” by David Harms; ISBN: 0764547879.

But in Tomcat I get error message “org.gjt.mm.mysql.Driver” which is the
name of the mm jdbc driver.

The following steps have been completed:

- Confirmed that Tomcat and MySQL were installed and configured.
- Edited the server.XML file so the mm driver will be used.
-     Set the CLASSPATH variable to the following: c:\tomcat\lib
- Copied the “mm.mysql-2.0.6.1.jar” file to the following path:
“c:\tomcat\lib”

The following software has been installed and configured:

Tomcat 3.2.3
MySQL 3.23.47
Windows NT Server 4.0 (Service Pack 6)
JDBC driver: mm.mysql-2.0.6.1

Here's a portion of the server.XML file:

<RequestInterceptor
            className="org.apache.tomcat.request.AccessInterceptor"
            debug="0" />

        <!-- Check permissions using the simple xml file. You can
             plug more advanced authentication modules.
        -->
        <RequestInterceptor
            className="org.apache.tomcat.request.SimpleRealm"
            debug="0" />

       <!-- UnComment the following and comment out the
            above to get a JDBC realm.
            Other options for driverName:
              driverName="oracle.jdbc.driver.OracleDriver"
              connectionURL="jdbc:oracle:thin:@ntserver:1521:ORCL"
              connectionName="scott"
              connectionPassword="tiger"
        -->
              driverName="org.gjt.mm.mysql.Driver"
              connectionURL="jdbc:mysql://localhost/authority"

              connectionName="test"
              connectionPassword="test"
        <!--
            "connectionName" and "connectionPassword" are optional.
        -->

Any help would be appreciated.

Thanks,

Mark Peterson


--
To unsubscribe:   <mailto:[EMAIL PROTECTED]>
For additional commands: <mailto:[EMAIL PROTECTED]>
Troubles with the list: <mailto:[EMAIL PROTECTED]>