Spring boot oracle Databse 연동 방법

pom.xml

<dependency>   <groupId>com.oracle</groupId>   <artifactId>ojdbc6</artifactId>   <version>1.0</version>   <scope>system</scope>   <systemPath>${project.basedir}/lib/ojdbc6.jar</systemPath> </dependency>

C:\VIW\aria\lib

ojdbc6.jar

3.52MB

 

 

https://mvnrepository.com/artifact/com.oracle.jdbc

 

 

application.properties

server.port = 9090 spring.mvc.view.prefix=/WEB-INF/jsp/ spring.mvc.view.suffix=.jsp #spring.datasource.driverClassName=org.mariadb.jdbc.Driver #spring.datasource.url=jdbc:mariadb://127.0.0.1:3306/viw #spring.datasource.username=viw #spring.datasource.password=9909 spring.datasource.driver-class-name=oracle.jdbc.driver.OracleDriver spring.datasource.url=jdbc:oracle:thin:@localhost:1521/VIWDB spring.datasource.username=C##b2b spring.datasource.password=9909 # ** 하위 폴더 모든 경로, *는 아무 이름이나 와도 된다는것을 뜻합니다. mybatis.mapper-locations=mybatis/**/*.xml