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>