[Spring] Spring/MyBatis/Oracle 연동&설정

[Spring] Spring/MyBatis/Oracle 연동 / 설정

앞글 https://rios.tistory.com/280 에서 Mybatis 설명 및 Spring / Mysql 연동 방법을

설명했으니 이번엔 oracle 버전으로 알아보도록하자.

사실 앞글에선 이론 및 mybatis 등을 설명하느라 글이 좀길어졌는데

간단하게 표현하면 설정파일 3개를 수정 ( root-context.xml , pom.xml , web.xml )

▼root-context.xml 설정 

 
 
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
 
    <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
 
    <property name="url" value="jdbc:oracle:thin:@localhost:1521:xe" />
 
    <property name="username" value="test"/>
 
    <property name="password" value="1234"/>
 
</bean>
 
 
 
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
 
    <property name="dataSource" ref="dataSource" />
 
    <property name="mapperLocations" value="classpath:/sqlMappers/*.xml" />
 
</bean>
 
 
 
<bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate">
 
    <constructor-arg index="0" ref="sqlSessionFactory" />
 
</bean>
 
 
 

▼pom.xml 설정 

<repositories>
 
    <repository>
 
        <id>mesir-repo</id>
 
        <url>http://mesir.googlecode.com/svn/trunk/mavenrepo</url>
 
    </repository>
 
</repositories>
 
 
 
<!-- Spring -->
 
<dependency>
 
    <groupId>org.springframework</groupId>
 
    <artifactId>spring-orm</artifactId>
 
    <version>${org.springframework-version}</version>
 
    <exclusions>
 
        <!-- Exclude Commons Logging in favor of SLF4j -->
 
        <exclusion>
 
            <groupId>commons-logging</groupId>
 
            <artifactId>commons-logging</artifactId>
 
         </exclusion>
 
    </exclusions>
 
</dependency>
 
<dependency>
 
    <groupId>org.springframework</groupId>
 
    <artifactId>spring-webmvc</artifactId>
 
    <version>${org.springframework-version}</version>
 
</dependency>
 
<dependency>
 
    <groupId>org.mybatis</groupId>
 
    <artifactId>mybatis</artifactId>
 
    <version>3.2.8</version>
 
</dependency>
 
<dependency>
 
    <groupId>org.mybatis</groupId>
 
    <artifactId>mybatis-spring</artifactId>
 
    <version>1.2.2</version>
 
</dependency>
 
<dependency>
 
    <groupId>com.oracle</groupId>
 
    <artifactId>ojdbc14</artifactId>
 
    <version>10.2.0.4.0</version>
 
</dependency>
 
 

▼web.xml 설정 

<servlet-mapping>
 
    <servlet-name>appServlet</servlet-name>
 
    <url-pattern>/</url-pattern>
 
</servlet-mapping>
 
 

p.s 앞에 글을 참조하면 이후 연동 및 테스트 방법으로 사용할수있습니다.