Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver

다른 pc에서 사용하던 프로젝트 그대로를 export 하여 새로운 pc에 import 하였고,

같은 tomcat 버전, oracle 버전을 사용했을 때 오류가 뿜음

아래 내용처럼 JDBC 드라이버를 찾을 수 없다고 오류가 나온다.

</경고: Unexpected exception resolving reference java.sql.SQLException: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver' at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createConnectionFactory(BasicDataSource.java:2138) at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2032) at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getLogWriter(BasicDataSource.java:1587) at org.apache.tomcat.dbcp.dbcp2.BasicDataSourceFactory.createDataSource(BasicDataSourceFactory.java:594) at org.apache.tomcat.dbcp.dbcp2.BasicDataSourceFactory.getObjectInstance(BasicDataSourceFactory.java:274) at org.apache.naming.factory.FactoryBase.getObjectInstance(FactoryBase.java:94) at javax.naming.spi.NamingManager.getObjectInstance(Unknown Source) at org.apache.naming.NamingContext.lookup(NamingContext.java:847) at org.apache.naming.NamingContext.lookup(NamingContext.java:158) at org.apache.naming.NamingContext.lookup(NamingContext.java:835) at org.apache.naming.NamingContext.lookup(NamingContext.java:172) at org.apache.catalina.core.NamingContextListener.addResource(NamingContextListener.java:1091) at org.apache.catalina.core.NamingContextListener.createNamingContext(NamingContextListener.java:670) at org.apache.catalina.core.NamingContextListener.lifecycleEvent(NamingContextListener.java:258) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:95) at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:90) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5213) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:145) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1407) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1397) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1333) at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1167) at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createConnectionFactory(BasicDataSource.java:2129) ... 23 more 11월 27, 2016 12:40:10 오전 org.apache.catalina.core.NamingContextListener addResource 경고: Failed to register in JMX: javax.naming.NamingException: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver' 11월 27, 2016 12:40:13 오전 org.apache.jasper.servlet.TldScanner scanJars 정보: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time. 11월 27, 2016 12:40:13 오전 org.apache.catalina.core.ApplicationContext log 정보: No Spring WebApplicationInitializer types detected on classpath 11월 27, 2016 12:40:13 오전 org.apache.catalina.core.ApplicationContext log 정보: Initializing Spring root WebApplicationContext INFO : org.springframework.web.context.ContextLoader - Root WebApplicationContext: initialization started INFO : org.springframework.web.context.support.XmlWebApplicationContext - Refreshing Root WebApplicationContext: startup date [Sun Nov 27 00:40:14 KST 2016]; root of context hierarchy INFO : org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from ServletContext resource [/WEB-INF/spring/root-context.xml] INFO : org.springframework.web.context.ContextLoader - Root WebApplicationContext: initialization completed in 609 ms 11월 27, 2016 12:40:14 오전 org.apache.catalina.core.ApplicationContext log 정보: Initializing Spring FrameworkServlet 'appServlet' INFO : org.springframework.web.servlet.DispatcherServlet - FrameworkServlet 'appServlet': initialization started INFO : org.springframework.web.context.support.XmlWebApplicationContext - Refreshing WebApplicationContext for namespace 'appServlet-servlet': startup date [Sun Nov 27 00:40:14 KST 2016]; parent: Root WebApplicationContext INFO : org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from ServletContext resource [/WEB-INF/spring/appServlet/servlet-context.xml] INFO : org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor - JSR-330 'javax.inject.Inject' annotation found and supported for autowiring INFO : org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - Mapped "{[/contents]}" onto public org.springframework.web.servlet.ModelAndView com.board.icia.BoardController.contents() INFO : org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - Mapped "{[/boardlist]}" onto public org.springframework.web.servlet.ModelAndView com.board.icia.BoardController.boardlist() INFO : org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - Mapped "{[/rest/replyInsert]}" onto public java.lang.String com.board.icia.BoardRestController.replyInsert() INFO : org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - Mapped "{[/access],methods=[POST]}" onto public org.springframework.web.servlet.ModelAndView com.board.icia.HomeController.access(com.board.icia.bean.Member) INFO : org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - Mapped "{[/],methods=[GET]}" onto public org.springframework.web.servlet.ModelAndView com.board.icia.HomeController.home() INFO : org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - Mapped "{[/logout]}" onto public org.springframework.web.servlet.ModelAndView com.board.icia.HomeController.logout(com.board.icia.bean.Member) INFO : org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - Mapped "{[/joinFrm]}" onto public org.springframework.web.servlet.ModelAndView com.board.icia.HomeController.joinFrm() INFO : org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - Mapped "{[/memberInsert]}" onto public org.springframework.web.servlet.ModelAndView com.board.icia.HomeController.memberInsert(com.board.icia.bean.Member) INFO : org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter - Looking for @ControllerAdvice: WebApplicationContext for namespace 'appServlet-servlet': startup date [Sun Nov 27 00:40:14 KST 2016]; parent: Root WebApplicationContext INFO : org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter - Looking for @ControllerAdvice: WebApplicationContext for namespace 'appServlet-servlet': startup date [Sun Nov 27 00:40:14 KST 2016]; parent: Root WebApplicationContext INFO : org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - Mapped URL path [/resources/**] onto handler 'org.springframework.web.servlet.resource.ResourceHttpRequestHandler#0' INFO : org.springframework.web.servlet.DispatcherServlet - FrameworkServlet 'appServlet': initialization completed in 2634 ms 11월 27, 2016 12:40:17 오전 org.apache.coyote.AbstractProtocol start 정보: Starting ProtocolHandler ["http-nio-80"] 11월 27, 2016 12:40:17 오전 org.apache.coyote.AbstractProtocol start 정보: Starting ProtocolHandler ["ajp-nio-8009"] 11월 27, 2016 12:40:17 오전 org.apache.catalina.startup.Catalina start 정보: Server startup in 7299 mstextarea>

해결 방법

C:\oraclexe\app\oracle\product\11.2.0\server\jdbc\lib

오라클 DB 가 설치된 경로로 들어가 ojdbc6.jar 를 복사한다.

C:\apache-tomcat-8.0.37\lib

톰캣이 설치된 경로안에 복사하여 넣어준 후 다시 서버를 실행시킨다.