jsp 공부중 오류

Question

jsp, apache tomcat, mariadb 이용합니다 오류가나서 질문합니다. tomcat 8.5버전 마리아 디비 2.6.1버전. 초보자라 상세하게 답변 부탁드릴게요.java.lang.ClassNotFoundException: org.mariadb.jdbc.Driverat org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1420)at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1228)at java.base/java.lang.Class.forName0(Native Method)at java.base/java.lang.Class.forName(Class.java:375)at user.UserDAO.<init>(UserDAO.java:22)at org.apache.jsp.loginAction_jsp._jspService(loginAction_jsp.java:141)at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)at javax.servlet.http.HttpServlet.service(HttpServlet.java:583)at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:465)at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:383)at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:331)at javax.servlet.http.HttpServlet.service(HttpServlet.java:583)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:212)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:156)at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:181)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:156)at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:483)at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:679)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:617)at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:932)at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1694)at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)at java.base/java.lang.Thread.run(Thread.java:833)java.lang.NullPointerException: Cannot invoke &#34;java.sql.Connection.prepareStatement(String)&#34; because &#34;this.conn&#34; is nullat user.UserDAO.login(UserDAO.java:33)at org.apache.jsp.loginAction_jsp._jspService(loginAction_jsp.java:142)at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)at javax.servlet.http.HttpServlet.service(HttpServlet.java:583)at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:465)at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:383)at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:331)at javax.servlet.http.HttpServlet.service(HttpServlet.java:583)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:212)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:156)at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:181)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:156)at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:483)at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:679)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:617)at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:932)at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1694)at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)at java.base/java.lang.Thread.run(Thread.java:833)

Kakakakakakaka. · Answer

저도 잘 모흐지먼연동 오류같은데...Properties> Deployment Assembly > add => Java Build Path Entries 에서 JDBC Driver를 추가해주면 될거같습니다.

꼬끼꼬꼬개발자 · Answer

넣으신 jar에 org.mariadb.jdbc.Driver 이게 존재하는게 확실한가요?그게 중요합니다.한번 코드에서 접근해보심이 좋을듯 합니다.그리고 레거시땜에 JSP를 공부하시는게 아니라면...뉴비시라면 JSP는 추천하지 않습니다.

jsp 공부중 오류

2개의 답변

Q&A 목록