Loading...
Skip to end of metadata
Go to start of metadata

 

Overview

This document describes how to manage Spring+iBatis transactions.

 

How to manage

1. Bean Managed Transaction (BMT), explicit transaction management (how to consider transaction processing in the source)

1-1 When directly using DataSourceTransactionManager

1-2 When using TransactionTemplate

 

2. CMT (Container Managed Transaction), declarative transaction management (using a configuration file and reducing consideration for transaction processing in the source)


2-1 Method using <tx:advice> tag

2-2. Method using TransactionProxyFactoryBean tag

2-3 Method using the @Transactional annotation

 

Detailed description

Common application

applicationContext.xml
?
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" >
   <property name="driverClassName"><value>Altibase.jdbc.driver.AltibaseDriver</value></property>
   <property name="url"><value>jdbc:Altibase://192.168.1.82:20300/mydb</value></property>
   <property name="username"><value>sys</value></property>
   <property name="password"><value>manager</value></property>
   <property name="maxActive"><value>20</value></property>
   <property name="maxIdle"><value>30000</value></property>
   <property name="maxWait"><value>100</value></property>
  </bean>
  
  <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
   <property name="dataSource"><ref local="dataSource"/></property>
  </bean>

 

1-1. When using DataSourceTransactionManager directly

  • Configuration file: There is no additional configuration.
  • Commit and rollback are processed directly on the source.
    SetAutoCommit(false) must be called in order to process as a transaction.
    Note that setAutoCommit(false) must be called when selecting blobs.

1-2. When to use TransactionTemplate

  • Configuration file

    ?
    <bean id="transactionTemplate" class="org.springframework.transaction.support.TransactionTemplate">
     <property name="transactionManager"><ref local="transactionManager"/></property>
    </bean>
     
    <bean id="xxxService" class="…">
     <property name="transactionTemplate"><ref local=" transactionTemplate"/></property>
    </bean>
  • The user must use functions such as transactionTemplate.execute() and doInTransaction() on the source.
  • Note that when selecting blobs, Oracle did not process transactions, but when using Altibase, the user must use functions such as transactionTemplate.execute() and doInTransaction() on the source to process transactions.

2-1. Method using <tx:advice> tag

  • Configuration file

    ?
    <bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
         <property name="configLocation"><value>sqlmap.xml</value></property>
         <property name="dataSource"><ref bean="dataSource" /></property>
         <property name="lobHandler"><ref bean="defaultLobHandler"/></property>
         <property name="transactionConfigProperties">
            <props>
               <prop key="DefaultAutoCommit">false</prop>
               <prop key="SetAutoCommitAllowed">true</prop>
            </props>
         </property>
    </bean>    
    <tx:advice id="txAdvice" transaction-manager="transactionManager">
        <tx:attributes>
          <!-- all methods starting with 'get' are read-only -->
          <tx:method name="get*" read-only="true" rollback-for="Exception"/>
          <!-- other methods use the default transaction settings (see below) -->
          <tx:method name="*" propagation=”REQUIRED”/>
        </tx:attributes>
    </tx:advice>
  • There is no need for transaction-related code on the source.

2-2. Method using TransactionProxyFactoryBean tag

  • Configuration file

    ?
    <bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
        <property name="configLocation"><value>sqlmap.xml</value></property>
        <property name="dataSource"><ref bean="dataSource" /></property>
        <property name="lobHandler"><ref bean="defaultLobHandler"/></property>
        <property name="transactionConfigProperties">
           <props>
              <prop key="DefaultAutoCommit">false</prop>
              <prop key="SetAutoCommitAllowed">true</prop>
           </props>
        </property>
    </bean>    
    <bean id="txProxyTemplate" abstract="true" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
      <property name="transactionManager">
       <ref local="transactionManager"></ref>  
      </property>
      <property name="transactionAttributes">
       <props>
        <prop key="insert*">PROPAGATION_REQUIRED</prop>
        <prop key="update*">PROPAGATION_REQUIRED</prop>
        <prop key="delete*">PROPAGATION_REQUIRED</prop>
        <prop key="save*">PROPAGATION_REQUIRED</prop>   
        <prop key="*">PROPAGATION_SUPPORTS</prop>
       </props>
      </property>
    </bean>
  • There is no need for transaction-related code on the source.

2-3 Method using the @Transactional annotation

  • Configuration

    ?
    <bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
         <property name="configLocation"><value>sqlmap.xml</value></property>
         <property name="dataSource"><ref bean="dataSource" /></property>
         <property name="lobHandler"><ref bean="defaultLobHandler"/></property>
         <property name="transactionConfigProperties">
            <props>
               <prop key="DefaultAutoCommit">false</prop>
               <prop key="SetAutoCommitAllowed">true</prop>
            </props>
         </property>
      </bean>    
      <tx:annotation-driven transaction-manager="transactionManager"/>
  • Classes that require transactions on the source require @Transactional(propagation=Propagation.REQUIRED) notation.

Reference

  • If AltibaseClobStringTypeHandler is applied guided by the standard framework, an error may occur when CLOB is 0 byte.
    In this case, the user can check that it is normally searched by adding annotations without using TypeHandle.


Sample code

Sample code for handling LOB data.

 



 

 

 

 

 

 

 

  • No labels