Spring <-> Oracle 연동방법

root-contextDB.xml

<!-- 	<bean id="dataSource"
		class="org.springframework.jdbc.datasource.DriverManagerDataSource">
		<property name="driverClassName"
			value="${jdbc.driverClassName}" />
		<property name="url"
			value="${jdbc.url}" />
		<property name="username" value="${jdbc.username}" />
		<property name="password" value="${jdbc.password}" />
	</bean> -->
    
    
    <!-- 컨넥션 풀링 -->
<dependency>
    <groupId>org.apache.commons</groupId>
    <artifactId>commons-dbcp2</artifactId>
    <version>2.7.0</version>
</dependency>
    
    
    <!-- Connection Pooling 이용하기 -->
<!-- <bean id="dataSource" class="org.apache.commons.dbcp2.BasicDataSource">
<property name="driverClassName" value="${jdbc.driverClassName}" />
<property name="url" value="${jdbc.url}" />
<property name="username" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
</bean> -->

<!-- JNDI 로 CONNECTION POOLING 사용하기 -->

<jee:jndi-lookup id="dataSource" jndi-name="jdbc/myoracle"   resource-ref="true" />

<!-- oracleDB.properties -->
<bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="location" value="/WEB-INF/spring/appServlet/oracleDB.properties"/>
        <property name="fileEncoding" value="UTF-8" />
 </bean>

 

oracleDB.properties

jdbc.driverClassName=oracle.jdbc.driver.OracleDriver
jdbc.url=jdbc:oracle:thin:@localhost:1521:XE
jdbc.username=hr
jdbc.password=hr