You installed the driver in:
/usr/local/mysql/mm.mysql.jdbc-1.2c/mysql_comp.jar
right?
Then why does your classpath path hav:
CLASSPATH=${CLASSPATH}:~usr/local...
Should it not read:
CLASSPATH=${CLASSPATH}:/usr/local...
Replace the tilde with a slash.
It seems that you are using Linux or *nix. Therefore tomcat.bat
is not used.
Match
mahi 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=mahi");
>
> 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(PageContextImpl.java:459)
> at
>
>frimex._0002ffrimex_0002fsample_0002ejspsample_jsp_10._jspService(_0002ffrimex_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(JspServlet.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:372)
> at
> org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)
> at
> org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
> at
>
>org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:210)
> at
> org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
> at
> org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java: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.
