Web + mysql - erro

1 resposta
L

Já inseri o jar de conexao e fiz a conexao mas esta dando esse erro, alguem sabe o que pode ser??

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: An exception occurred processing JSP page /login.jsp at line 63

60:

61:   <%

62: 		//1º Carregar o Driver

63: 		Class.forName(“com.mysql.jdbc.Driver”);

64: 		<a href="//out.println">//out.println</a>(“Conseguiu carregar o driver”);

65: 		

66: 		Connection con = DriverManager.getConnection(“jdbc:mysql://localhost:3306/both”,“root”,“root”);
Stacktrace:

org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510)

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:401)

org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)

org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)

javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

com.sun.faces.context.ExternalContextImpl.dispatch(ExternalContextImpl.java:322)

com.sun.faces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:130)

com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:87)

com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:200)

com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:117)

javax.faces.webapp.FacesServlet.service(FacesServlet.java:198)

root cause

javax.servlet.ServletException: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:862)

org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)

org.apache.jsp.login_jsp._jspService(login_jsp.java:191)

org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)

javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)

org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)

org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)

javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

com.sun.faces.context.ExternalContextImpl.dispatch(ExternalContextImpl.java:322)

com.sun.faces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:130)

com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:87)

com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:200)

com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:117)

javax.faces.webapp.FacesServlet.service(FacesServlet.java:198)

root cause

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1645)

org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1491)

org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:128)

org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:66)

java.lang.ClassLoader.loadClassInternal(Unknown Source)

java.lang.Class.forName0(Native Method)

java.lang.Class.forName(Unknown Source)

org.apache.jsp.login_jsp._jspService(login_jsp.java:146)

org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)

javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)

org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)

org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)

javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

com.sun.faces.context.ExternalContextImpl.dispatch(ExternalContextImpl.java:322)

com.sun.faces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:130)

com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:87)

com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:200)

com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:117)

javax.faces.webapp.FacesServlet.service(FacesServlet.java:198)

note The full stack trace of the root cause is available in the Apache Tomcat/6.0.29 logs.

1 Resposta

Diabo_Loiro

cara voce ele não esta encontrando o driver por isso ta dando class not found na hora de carregar a classe… adicione o jar no seu classpath ou na pasta web-inf/lib se tiver usando algum ide ja facilita por exemplo no eclipse se voce clicar com botão direito no projeto… ir em build path dai e so adicionar o jar la… em outras ide o processo é semelhante

Criado 19 de agosto de 2010
Ultima resposta 20 de ago. de 2010
Respostas 1
Participantes 2