Spring _jdbcTemplate_oracle_설정

오라클 SQL 11버전 설치

CMD - sqlplus를 통해 설치 확인
id system pw ~

계정 생성 및 설정

create user scott identified by tiger;
grant connect, resource to scott;
SQL Developer 사용

hr 더미데이터 사용 코드 기술

hr계정 활성화. 정상적으로 진행시
cmd창에서 sqlplus system/oracle -> 입력
conn /as sysdba -> 입력
alter user hr account unlock; ->입력
alter user hr identified by hr; ->입력
conn hr ->입력
select * from employees; -> 입력

메이븐 의존성 설정(pom.xml).

<!-- Spring JDBC -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>${org.springframework-version}</version>
</dependency>
<!-- Connection Pool -->

<dependency>
<groupId>commons-dbcp</groupId>
<artifactId>commons-dbcp</artifactId>
<version>1.4</version>
</dependency>

<!-- Spring JDBC -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>${org.springframework-version}</version>
</dependency>
<!-- Connection Pool -->

<dependency>
<groupId>commons-dbcp</groupId>
<artifactId>commons-dbcp</artifactId>
<version>1.4</version>
</dependency>

위의 코드를 pom.xml에 집어넣습니다

<!-- Oracle JDBC Driver -->

<dependency>
<groupId>com.oracle</groupId>
<artifactId>ojdbc6</artifactId>
<version>12.1.0.1</version>
</dependency>

단, ojdbc를 스프링에서 정식으로 지원하지 않는지라 pom.xml에 사설 저장소 주소를 새롭게 추가하는 번거로움

<!-- Repository Setting -->
<repositories>
<repository>
<id>oracle</id>
<name>ORACLE JDBC Repository</name>
<url>http://maven.jahia.org/maven2</url>
</repository>
</repositories>

이것을 태그(맨 마지막 줄) 의 한 줄 위에 복붙하면 됩니다.

root - context

<context:property-placeholder location="classpath:database/jdbc.properties"/>
<bean id = "dataSource" class="org.apache.commons.dbcp.BasicDataSource">
	<property name="driverClassName" value="${jdbc.driverClassName}"></property>
	<property name="url" value = "${jdbc.url}"></property>
	<property name="username" value ="${jdbc.username}"></property>
	<property name="password" value = "${jdbc.password}"></property>

</bean>

<bean id = "jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
	<property name = "dataSource" ref = "dataSource"/>
</bean>