https://mvnrepository.com/search?q=ojdbc 에서 ojdbc를 친다
<!-- https://mvnrepository.com/artifact/com.oracle.database.jdbc/ojdbc10 -->
<dependency>
<groupId>com.oracle.database.jdbc</groupId>
<artifactId>ojdbc10</artifactId>
<version>19.10.0.0</version>
<scope>test</scope>
</dependency>
이걸 pom.xml에 넣는다 이 때 test줄은 삭제한다
3.hikaricp라이브러리도 가지고와서 넣어준다
히카리 커넥션풀링 미리 만들어서 효율을 높이는 것
<!-- https://mvnrepository.com/artifact/com.zaxxer/HikariCP -->
<dependency>
<groupId>com.zaxxer</groupId>
<artifactId>HikariCP</artifactId>
<version>4.0.3</version>
</dependency>
<!-- DataSource 준비 -->
<bean id="hikariConfig" class="com.zaxxer.hikari.HikariConfig">
<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" />
<property name="jdbcUrl" value="jdbc:oracle:thin:@127.0.0.1:1521:xe" />
<property name="username" value="myuser" />
<property name="password" value="1234" />
</bean>
<bean id="dataSource" class="com.zaxxer.hikari.HikariDataSource" >
<constructor-arg ref="hikariConfig" />
</bean>
적어준다
여기 테스트파일하나 만들어서
import lombok.extern.log4j.Log4j;
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration("file:src/main/webapp/WEB-INF/spring/root-context.xml")
@Log4j
public class DataSourceTests {
@Autowired
private DataSource dataSource;
@Test
public void testConnection() {
try {
Connection con = dataSource.getConnection();
log.info(con);
} catch (SQLException e) {
fail(e.getMessage());
}
}
}
테스트해본다
<dependency>
<groupId>com.oracle.database.jdbc</groupId>
<artifactId>ojdbc10</artifactId>
<version>19.10.0.0</version>
<scope>test</scope>
</dependency>
이라이브러리가 오류가 날경우 직접 프로젝트에 lib폴더를 만들어서 ojdbc8.jar파일을 넣어준다음 빌드패스를 해주면됨
이 라이브러리도 추가하기