Dear Ruby,
Thank you very much for your earlier response! We have downloaded the
mm.mysql.jdbc driver as you have specified and placed it in the lib
directory of Tomcat server!
We tried placing the same in jdk and mysql lib directories too! Still we are
not able to connect it!
We are not clear as to where or in which lib directory we have to place
these jar files!
We are getting the following exception when we run our jsp file!
The driver registration code we have used is as follows:
Class.forName("org.gjt.mm.mysql.Driver");
Connection conn =
DriverManager.getConnection("jdbc:mysql://www.homeomiracles.com:8080/homoeo"
);
Error: 500
Location: /examples/jsp/num/Submit.jsp
Internal Servlet Error:
javax.servlet.ServletException: Unable to load class org.gjt.mm.mysql.Driver
at
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImp
l.java:459)
at
jsp.num._0002fjsp_0002fnum_0002fSubmit_0002ejspSubmit_jsp_16._jspService(_00
02fjsp_0002fnum_0002fSubmit_0002ejspSubmit_jsp_16.java:388)
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.ja
va: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:79
7)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
at
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpC
onnectionHandler.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)
