보관함

Spring boot oracle Databse 연동 방법

AI 윤 선생 2021. 7. 3. 15:34
반응형

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

 

 

 

 

 

 

반응형