maven을 이용하여 ojdbc8 JDBC 추가 (set ojdbc8 jdbc library on pom.xml through maven)

스프링 부트를 사용해서 oracle DB 와 JPA 연동하고자 했는데,

ojdbc8 추가할 때 에러가 발생하여 해결법을 공유합니다.

[최초 pom.xml]

<?xml version="1.0" encoding="UTF-8"?>

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

           xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">

           <modelVersion>4.0.0</modelVersion>

 

           <groupId>ojc.asia</groupId>

           <artifactId>jpaboard</artifactId>

           <version>1.0-SNAPSHOT</version>

           <packaging>jar</packaging>

 

           <name>jpaboard</name>

           <description>Spring Data JPA Board</description>

 

           <parent>

                     <groupId>org.springframework.boot</groupId>

                     <artifactId>spring-boot-starter-parent</artifactId>

                     <version>1.3.3.RELEASE</version>

                     <relativePath/> <!-- lookup parent from repository -->

           </parent>

 

           <properties>

                     <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>

                     <java.version>1.8</java.version>

           </properties>

 

           <dependencies>

                     <dependency>

                                <groupId>org.springframework.boot</groupId>

                                <artifactId>spring-boot-starter-data-jpa</artifactId>

                     </dependency>

                     <dependency>

                                <groupId>org.springframework.boot</groupId>

                                <artifactId>spring-boot-starter-web</artifactId>

                     </dependency>

                    

                     <dependency>

                                <groupId>org.springframework.boot</groupId>

                                <artifactId>spring-boot-starter-test</artifactId>

                                <scope>test</scope>

                     </dependency>

 

<!--  JSP, JSTL 사용위해 -->

                     <dependency>

                                <groupId>javax.servlet</groupId>

                                <artifactId>jstl</artifactId>

                     </dependency>

                     <dependency>

                                <groupId>org.apache.tomcat.embed</groupId>

                                <artifactId>tomcat-embed-jasper</artifactId>

                                <scope>provided</scope>

                     </dependency>

                    

                     <!-- DriverSpy -->

                     <dependency>

                                <groupId>org.bgee.log4jdbc-log4j2</groupId>

                                <artifactId>log4jdbc-log4j2-jdbc4.1</artifactId>

                                <version>1.16</version>

                     </dependency>

                    

                     <!-- for oracle -->

                     <dependency>

                                <groupId>com.oracle</groupId>

                                <artifactId>ojdbc6</artifactId>

                                <version>11.1.0.7.0</version>

                     </dependency>            

                    

           </dependencies>          

           <build>

                     <plugins>

                                <plugin>

                                          <groupId>org.springframework.boot</groupId>

                                          <artifactId>spring-boot-maven-plugin</artifactId>

                                </plugin>

                     </plugins>

           </build>

           <repositories>

                     <repository>

                                <id>oracle</id>

                                <name>ORACLE JDBC Repository</name>

                                <url>https://maven.oracle.com</url>

                     </repository>

           </repositories> 

</project>

[해결]

http://javabycode.com/build-tools/maven/add-oracle-jdbc-driver-maven.html

1. 위 사이트처럼 오라클 홈페이지에서 ojdbc8.jar 파일을 다운받고,

2. maven local repository 에 ojdbc8.jar 을 추가 (아래 박스 참고)

mvn install:install-file -Dfile={Path/to/your/ojdbc8.jar}

      -DgroupId=com.oracle -DartifactId=ojdbc8 -Dversion=12.2.0.1 -Dpackaging=jar

3. pom.xml 을 변경

<?xml version="1.0" encoding="UTF-8"?>

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">

<modelVersion>4.0.0</modelVersion>

<groupId>ojc.asia</groupId>

<artifactId>jpaboard</artifactId>

<version>0.0.1-SNAPSHOT</version>

<packaging>war</packaging>

<name>jpaboard</name>

<description>Spring Data JPA Board</description>

<parent>

<groupId>org.springframework.boot</groupId>

<artifactId>spring-boot-starter-parent</artifactId>

<version>1.5.7.RELEASE</version>

<relativePath/> <!-- lookup parent from repository -->

</parent>

<properties>

<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>

<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>

<java.version>1.8</java.version>

</properties>

<dependencies>

<dependency>

<groupId>org.springframework.boot</groupId>

<artifactId>spring-boot-starter-data-jpa</artifactId>

</dependency>

<dependency>

<groupId>org.springframework.boot</groupId>

<artifactId>spring-boot-starter-web</artifactId>

</dependency>

<dependency>

<groupId>org.springframework.boot</groupId>

<artifactId>spring-boot-starter-tomcat</artifactId>

<scope>provided</scope>

</dependency>

<dependency>

<groupId>org.springframework.boot</groupId>

<artifactId>spring-boot-starter-test</artifactId>

<scope>test</scope>

</dependency>

<!--  JSP, JSTL 사용위해 -->

         <dependency>

                    <groupId>javax.servlet</groupId>

                    <artifactId>jstl</artifactId>

         </dependency>

         <dependency>

                    <groupId>org.apache.tomcat.embed</groupId>

                    <artifactId>tomcat-embed-jasper</artifactId>

                    <scope>provided</scope>

         </dependency>

        

         <!-- DriverSpy -->

         <dependency>

                    <groupId>org.bgee.log4jdbc-log4j2</groupId>

                    <artifactId>log4jdbc-log4j2-jdbc4.1</artifactId>

                    <version>1.16</version>

         </dependency>

        

         <!-- for oracle -->

<dependency>

     <groupId>com.oracle</groupId>

     <artifactId>ojdbc8</artifactId>

     <version>12.2.0.1</version>

    </dependency>     

</dependencies>

<build>

<plugins>

<plugin>

<groupId>org.springframework.boot</groupId>

<artifactId>spring-boot-maven-plugin</artifactId>

</plugin>

</plugins>

</build>

</project>