All you need to do is put mysql_comp.jar in lib/ext in the jre. The
extensions directory is automatically searched and need never be
declared as part of a classpath.
-- Rob
--On Friday, March 30, 2001 11:33:11 PM -0800 mahi
<[EMAIL PROTECTED]> wrote:
>
> Sir,
> Presently we are working to upload jsp files.we are doing this
> process through VPS,using apache tomcat server,mysql database and mm
> jdbc driver.
>
> we have included classpath in the tomcat.sh file as follows:
>
> CLASSPATH=${TOMCAT_HOME}/webserver.jar
> CLASSPATH=${CLASSPATH}:${TOMCAT_HOME}/lib/servlet.jar
> CLASSPATH=${CLASSPATH}:${TOMCAT_HOME}/lib/jasper.jar
> CLASSPATH=${CLASSPATH}:${TOMCAT_HOME}/lib/xml.jar
> CLASSPATH=${CLASSPATH}:${TOMCAT_HOME}/webapps/examples/WEB-INF/classes
> CLASSPATH=${CLASSPATH}:~usr/local/mysql/mm.mysql.jdbc-1.2c/mysql_comp
> .jar
>
> we have set the class path in tomcat.bat as follows:
>
> set CLASSPATH=%CLASSPATH%;%TOMCAT_HOME%mysql_comp.jar
>
>
> we have given the following line in the jsp file
>
> Class.forName("org.gjt.mm.mysql.Driver").newInstance();
> dbconn=DriverManager.getConnection("jdbc:mysql://localhost/uni?user=m
> ahi");
>
> we got the following error:
>
> Error: 500
>
> Internal Servlet Error:
>
> javax.servlet.ServletException: Unable to load class
> org.gjt.mm.mysql.Driver at
> org.apache.jasper.runtime.PageContextImpl.handlePageException(PageCo
> ntextImpl.java:459) at
> frimex._0002ffrimex_0002fsample_0002ejspsample_jsp_10._jspService(_0
> 002ffrimex_0002fsample_0002ejspsample_jsp_10.java:114) at
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
> org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspSe
> rvlet.java:177) at
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:
> 318) at
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:391) at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
> org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:
> 404) at org.apache.tomcat.core.Handler.service(Handler.java:286)
> at
> org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:37
> 2) at
> org.apache.tomcat.core.ContextManager.internalService(ContextManager
> .java:797) at
> org.apache.tomcat.core.ContextManager.service(ContextManager.java:74
> 3) at
> org.apache.tomcat.service.http.HttpConnectionHandler.processConnecti
> on(HttpConnectionHandler.java:210) at
> org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java
> :416) at
> org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.jav
> a:498) at java.lang.Thread.run(Thread.java:484)
>
>
> we need to know the correct path to install the mm-mysqldriver and to
> overcome this error. expecting help at the earliest.
>
> regards
>
> maheswari
>
>
>
> ---------------------------------
> Do You Yahoo!?
> Yahoo! Mail Personal Address - Get email at your own domain with
> Yahoo! Mail.
_ _ _ _ _ _ _ _ _ _
/\_\_\_\_\ /\_\ /\_\_\_\_\_\
/\/_/_/_/_/ /\/_/ \/_/_/_/_/_/ QUIDQUID LATINE DICTUM SIT,
/\/_/__\/_/ __ /\/_/ /\/_/ PROFUNDUM VIDITUR
/\/_/_/_/_/ /\_\ /\/_/ /\/_/
/\/_/ \/_/ /\/_/_/\/_/ /\/_/ (Whatever is said in Latin
\/_/ \/_/ \/_/_/_/_/ \/_/ appears profound)
Rob Tanner
McMinnville, Oregon
[EMAIL PROTECTED]