You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Mark Peterson <ma...@worldnet.att.net> on 2002/02/08 00:03:32 UTC

JDBC Problem

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:   <ma...@jakarta.apache.org>
For additional commands: <ma...@jakarta.apache.org>
Troubles with the list: <ma...@jakarta.apache.org>


Re: JDBC Problem

Posted by "Karthikeyan.K.V" <ka...@attbi.com>.
Mark,
            Try to put the mysql-driver jar file  in the WEB-INF\lib
directory which will under tomcat\webapps\"Your application directory".This
maybe a classpath problem.

Karthik

----- Original Message -----
From: "Mark Peterson" <ma...@worldnet.att.net>
To: <to...@jakarta.apache.org>
Sent: Thursday, February 07, 2002 5:03 PM
Subject: JDBC Problem


> 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:   <ma...@jakarta.apache.org>
> For additional commands: <ma...@jakarta.apache.org>
> Troubles with the list: <ma...@jakarta.apache.org>
>
>


--
To unsubscribe:   <ma...@jakarta.apache.org>
For additional commands: <ma...@jakarta.apache.org>
Troubles with the list: <ma...@jakarta.apache.org>