@RunWith (SpringJUnit4ClassRunner. class )

@ContextConfiguration (locations = { "classpath:/com/mydomain/data/beans.xml" })

@TransactionConfiguration (transactionManager = "transactionManager" ,defaultRollback= true )

@Transactional

public class iBatisDaoTest {

          @Autowired

          private ImageService imageService ;

          private int id ;

          @Test

          public void testInsertImage() {}

}

1. 코드   기반의   트랜잭션   처리 (Progrmmatic Transaction)

2. 선언적   트랜잭션 (Declarative Transaction)  

- <tx:advice> 태그를   이용  

- TransactionProxyFactoryBean 태그를   이용  

- @Transactional 어노테이션을   이용

<beans xmlns="http://www.springframework.org/schema/beans"

       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

       xmlns:aop="http://www.springframework.org/schema/aop"

       xmlns:tx="http://www.springframework.org/schema/tx"

       xsi:schemaLocation="

       http://www.springframework.org/schema/beans

http://www.springframework.org/schema/beans/spring-beans-2.0.xsd

       http://www.springframework.org/schema/tx

       http://www.springframework.org/schema/tx/spring-tx-2.0.xsd

       http://www.springframework.org/schema/aop

       http://www.springframework.org/schema/aop/spring-aop-2.0.xsd">

  <bean id="fooService" class="x.y.service.DefaultFooService"/>

  <tx:advice id="txAdvice" transaction-manager="txManager">  

      <tx:method name="get*" read-only="true"/>

      <tx:method name="*"/>

<aop:pointcut id="fooServiceOperation" expression="execution(* x.y.service.FooService.*(..))"/>

<aop:advisor advice-ref="txAdvice" pointcut-ref="fooServiceOperation"/>

@Transactional(readOnly = true)

public class DefaultFooService implements FooService {

  public Foo getFoo(String fooName) {

    // do something

  }

  // these settings have precedence for this method

  @Transactional(readOnly = false, propagation = Propagation.REQUIRES_NEW)

  public void updateFoo(Foo foo) {

    // do something

  }

}

<bean id="fooService" class="x.y.service.DefaultFooService"/>

<tx:annotation-driven transaction-manager="txManager"/>

SqlMapClientFactoryBean

(org.springframework.orm.ibatis.SqlMapClientFactoryBean)

SqlMapClientTemplate

(org.springframework.orm.ibatis.SqlMapClientTemplate)

SqlMapClientDaoSupport

(org.springframework.orm.ibatis.support.SqlMapClientDaoSupport)

  * 자동 트랜잭션 : 단순한 한 개의 SQL 구문은 명시적으로 구분된 트랜잭션을 필요로 하지 않는다 .

   * 로컬 트랜잭션 : 간단하고 범위가 좁은 트랜잭션으로 여러 SQL 구문을 포함하지만 단일 데이터베이스에서 수행된다 .

   * 글로벌 트랜잭션 : 복잡하고 범위가 넓은 트랜잭션으로 여러 SQL 구문을 여러 데이터베이스 혹은 잠재적으로 데이터베이스가 아닌 JMS 의 큐나 JCA 커넥션 같은 다른 트랜잭션이 가능한 리소스상에서 실행된다 .

   * 사용자 정의 트랜잭션 : 사용자 맘대로 ~

<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE sqlMapConfig    

    PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"    

    "http://ibatis.apache.org/dtd/sql-map-config-2.dtd">

<sqlMapConfig>

    <settings

    cacheModelsEnabled="true"

    enhancementEnabled="true"

    lazyLoadingEnabled="true"

    maxRequests="32"

    maxSessions="10"

    maxTransactions="5"

    useStatementNamespaces="false"

  />

  <sqlMap resource="sqlmaps/Image.xml" />

</sqlMapConfig>

<?xml version="1.0" encoding="UTF-8" standalone="no"?>

DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"

"http://www.ibatis.com/dtd/sql-map-2.dtd">

<sqlMap namespace="Image">      

       <typeAlias alias="image" type="com.mydomain.domain.Image" />      

       <cacheModel id="oneDayProduct" type="LRU">

             <flushInterval hours="24" />

       </cacheModel> 

       <resultMap id="imageMap" class="image">

             <result property="id" column="id" />

             <result property="name" column="name" />

             <result property="mimeType" column="mimetype" />

             <result property="width" column="width" />

             <result property="height" column="height" />

             <result property="resolution" column="resolution" />

             <result property="fileSize" column="filesize" />

             <result property="regDate" column="regdate" />

             <result property="license" column="license" />

             <result property="author" column="author" />

             <result property="description" column="description" />

       </resultMap> 

       <select id="getImages" resultClass="image">

             SELECT * FROM images            

       </select>

<statement id="statementName"

[parameterClass="some.class.Name"]

[resultClass="some.class.Name"]

[parameterMap="nameOfParameterMap"]

[resultMap="nameOfResultMap"]

[cacheModel="nameOfCache"]

> 

<![CDATA

select * from PRODUCT where PRD_ID = [?|#propertyName#]

order by [$simpleDynamic$]

]]>

name : 'buri'

# : 데이터형에 맞는 sql 데이터형으로 변환

#name# : 'buri'

$ : 기존 데이터를 그대로 사용

'%$name$%' : '%buri%'

? : parameterMap에 정의된 순서대로 ? 에 바인딩

public class Image {

       private String description;

       public String getDescription() {

             return description;

       }

       public void setDescription(String description) {

             this.description = description;

       }

       // ....

}

<insert id="insertImage" parameterClass="image">

             INSERT INTO images(name,mimetype,width,height,resolution,filesize,regdate,license,author,description)

             VALUES (#name#, #mimeType#, #width#, #height#, #resolution#,#fileSize#, #regDate#, #license#, #author#, #description#)

             <selectKey keyProperty="id" resultClass="int">

                    values IDENTITY_VAL_LOCAL()

             </selectKey>

</insert>

< cacheModel id = " oneDayProduct " type = " LRU " >

          < flushInterval hours = " 24 " / >

< / cacheModel >

< update id = " dynamicUpdateImage " parameterClass = " image " >

          Update images

          < dynamic prepend = " SET " >

                    < isNotNull property = " name " prepend = " , " >

                                name = #name#

                      < / isNotNull >

                      < isNotNull property = " mimeType " prepend = " , " >

                                mimetype = #mimeType#

                      < / isNotNull >

                      < isNotNull property = " width " prepend = " , " >

                                width = #width#

                      < / isNotNull >

                      < isNotNull property = " height " prepend = " , " >

                                height = #height#

                      < / isNotNull >

                      < isNotNull property = " resolution " prepend = " , " >

                                resolution = #resolution#

                      < / isNotNull >

                      < isNotNull property = " fileSize " prepend = " , " >

                                fileSize = #fileSize#

                      < / isNotNull >

                      < isNotNull property = " regDate " prepend = " , " >

                                regDate = #regDate#

                      < / isNotNull >

                      < isNotNull property = " license " prepend = " , " >

                                license = #license#

                      < / isNotNull >

                      < isNotNull property = " author " prepend = " , " >

                                author = #author#

                      < / isNotNull >

                      < isNotNull property = " description " prepend = " , " >

                                description = #description#

                      < / isNotNull >

            < / dynamic >

            WHERE id=#id#

< / update >

< select id = " selectItemCount " resultClass = " int " >

 SELECT COUNT(*) AS total

 FROM images

 WHERE id = 1

< / select >

< select id = " selectItems " resultClass = " image " >

 SELECT id, name

 FROM images

 WHERE id = 1

< / select >

< sql id = " selectItem_fragment " >

 FROM images

 WHERE id = #value#

< / sql >

< select id = " selectItemCount " parameterClass = " int " resultClass = " int " >

 SELECT COUNT(*) AS total

  < include refid = " selectItem_fragment " / >

< / select >

< select id = " selectItems " parameterClass = " int " resultClass = " image " >

 SELECT id, name

  < include refid = " selectItem_fragment " / >

< / select >

1. Overview

2. Why use iBATIS?

3. Introduce iBATIS

4. How to

5. Transaction

6. iBATIS + Spring

7. iBATIS + Spring + transaction

8. Annotation 기반으로 JUnit4를 이용한 Spring TDD

9. Reference

  1. 데이터베이스연결및트랜잭션관리

  2. 쿼리파라미터를자바객체와셋팅하기.

  3. SQL ResultSets를자바객체로변환하기.

  4. 쿼리문생성하기.