向lib添加了mysql jar，但仍然无法通过本地tomcat通过intelliJ在本地部署上遇到类异常? [英] Added mysql jar to lib but still facing class not found exception on local deployment to tomcat working through intelliJ?
问题描述
在我的整个应用程序中，我想在用户注册并通过servlet2.java单击注册"时单击用户名和密码，但是在本地tomcat部署而不是将数据添加到数据库class not found exception时，我有已经将mysql jar添加到lib中，但仍然没有任何好处.这是指向我的项目的可下载链接.如果有人可以，请帮助解决此问题.
Throughout my application I want to add the username and password to database when a user registers and clicks on "sign up" through servlet2.java but on local tomcat deployment instead of adding data to database class not found exception is thrown, I have already added mysql jar to lib but still no benefit. Here is the downloadable link to my project. If anybody can please help correcting the issue.
这是完整的堆栈跟踪.
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1363)
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1186)
at java.base/java.lang.Class.forName0(Native Method)
at java.base/java.lang.Class.forName(Class.java:315)
at source.servlet2.database(servlet2.java:23)
at source.servlet2.doPost(servlet2.java:16)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:834)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:834)
22-May-2019 19:22:52.550 INFO [Catalina-utility-2] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [D:\apache-tomcat-9.0.17\webapps\manager]
22-May-2019 19:22:52.735 INFO [Catalina-utility-2] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [D:\apache-tomcat-9.0.17\webapps\manager] has finished in [185] ms
推荐答案
您具有jdbc驱动程序jar的provided范围.在这种情况下，它不会复制到您部署到tomcat的工件中.您需要将其指定为compile范围.
You have the provided scope for the jdbc driver jar. In this cases it is not copied into the artifact that you deploy to tomcat. You need to specify it as a compile scope.
您还可以按照以下 https://stackoverflow.com/a/7198049/2000323中所述将其添加到tomcat类路径jar中. a>适用于所有应用程序.然后，您必须将范围指定为provided，以使同一jar不会被部署两次.
You can also add the to tomcat classpath jar as described here https://stackoverflow.com/a/7198049/2000323 for all applications. Then you must specify the scope as provided so that the same jar would not be deployed twice.
这篇关于向lib添加了mysql jar，但仍然无法通过本地tomcat通过intelliJ在本地部署上遇到类异常?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
