JSP Database Connection

Asked

Viewed 178 times

0

Hey there, guys. My problem is this : I have a JSP project, which used the Oracle SQL database. However, it came in handy that I used Mysql and installed . Mysql jar and I changed the Connection class, all right, so much so that in the class I test the DAO everything goes right. The problem is when I load the page into Tomcat. I see these errors:

Type Exception report message Servlet Execution threw an Exception Description The server encountered an Internal error that prevented it from fulfilling this request. Exception javax.servlet.Servletexception: Servlet Execution threw an Exception org.apache.Tomcat.websocket.server.WsFilter.doFilter(Wsfilter.java:52) root cause java.lang.Noclassdeffounderror: com/mysql/jdbc/Driver lojavalemobi.util.Conexaobd.conecta(Conexaobd.java:25) lojavalemobi.DAO.ProdutoDAO.registrarItem(ProdutoDAO.java:33) br.com.plataforma.controller.Productocontrol.doPost(Productocontrol.java:51) javax.servlet.http.HttpServlet.service(Httpservlet.java:650) javax.servlet.http.HttpServlet.service(Httpservlet.java:731) org.apache.Tomcat.websocket.server.WsFilter.doFilter(Wsfilter.java:52) root cause java.lang.Classnotfoundexception: com.mysql.jdbc.Driver org.apache.Catalina.loader.Webappclassloaderbase.loadClass(Webappclassloaderbase.java:1892) org.apache.Catalina.loader.Webappclassloaderbase.loadClass(Webappclassloaderbase.java:1735) lojavalemobi.util.Conexaobd.conecta(Conexaobd.java:25) lojavalemobi.DAO.ProdutoDAO.registrarItem(ProdutoDAO.java:33) br.com.plataforma.controller.Productocontrol.doPost(Productocontrol.java:51) javax.servlet.http.HttpServlet.service(Httpservlet.java:650) javax.servlet.http.HttpServlet.service(Httpservlet.java:731) org.apache.Tomcat.websocket.server.WsFilter.doFilter(Wsfilter.java:52) note The full stack trace of the root cause is available in the Apache Tomcat/7.0.81 logs.

I wonder what I’m doing wrong?

mysql jsp tomcat

  • Already tried to restart has Tomcat?

  • The service? I’ll try...

  • Yeah, the service

  • I had put it manually. However, I started and restarted it to test, and it didn’t work. From what I understand is problem with socket, I saw once, but now I forgot...

1 answer

1

I solved, the problem was that I had not pulled the . jar to lib folder and given build path... silly error, but it took time

  • 1

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

Browser other questions tagged mysql jsp tomcat

You are not signed in. Login or sign up in order to post.