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.
