오라클과 연결

dao 코드를 작성하기 전, 오라클과 연결을 위한 설정을 해줌.

사용한 라이브러리: HikariDataSource
pom.xml 설정

<dependency>
      	<groupId>org.springframework</groupId>
     	 <artifactId>spring-jdbc</artifactId>
     	 <version>${org.springframework-version}</version>
</dependency>		
<dependency>
       	<groupId>org.springframework</groupId>
	 <artifactId>spring-tx</artifactId>
	<version>${org.springframework-version}</version>
</dependency>
<dependency>
	<groupId>com.zaxxer</groupId>
	<artifactId>HikariCP</artifactId>
	<version>2.7.8</version>
</dependency>

root-context.xml 설정

<bean id="hikariConfig" class="com.zaxxer.hikari.HikariConfig">
	<property name="driverClassName" value="net.sf.log4jdbc.sql.jdbcapi.DriverSpy"></property>
	<property name="jdbcUrl" value="jdbc:log4jdbc:oracle:thin:@localhost:1521:JAVA"></property>
	<property name="username" value="spring"></property>
	<property name="password" value="java"></property>
</bean>

<bean id="dataSource" class="com.zaxxer.hikari.HikariDataSource" destroy-method="close">
	<constructor-arg ref="hikariConfig" />
</bean>	

jdbc에서 사용하는 로그 설정
pom.xml과 properties파일을 다음과 같이 설정

<dependency>
	<groupId>org.bgee.log4jdbc-log4j2</groupId>
	<artifactId>log4jdbc-log4j2-jdbc4</artifactId>
	<version>1.16</version>
</dependency>

log4jdbc.spylogdelegator.name=net.sf.log4jdbc.log.slf4j.Slf4jSpyLogDelegator