spring ibatis 多数据源 事务配置
网上找的，spring+ibatis+struts1.2 的多数据源事务配置。没试过。先做下记录。

jdbc.properties文件内容：
jdbc2.driverClassName=net.sourceforge.jtds.jdbc.Driver
jdbc2.url=jdbc:jtds:sqlserver://10.101.122.9:1433/testdb;charset=gb2312
jdbc2.username=user1
jdbc2.password=password

jdbc.driverClassName=oracle.jdbc.driver.OracleDriver
jdbc.url=jdbc:oracle:thin:@10.101.126.29:1521:DBSERVER
jdbc.username=user1
jdbc.password=password

applicationContext.xml配置文件内容如下：
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN 2.0//EN" "http://www.springframework.org/dtd/spring-beans-2.0.dtd">
<beans>
<bean id="propertyConfigurer" destroy-method="close">
<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>
<bean id="transactionManager" ref="dataSource"/>
</bean>
<bean id="transactionInterceptor" ref="transactionManager"/>
<property name="transactionAttributes">
<props>
<prop key="insert*">PROPAGATION_REQUIRED</prop>
<prop key="delete*">PROPAGATION_REQUIRED</prop>
<prop key="update*">PROPAGATION_REQUIRED</prop>
<prop key="do*">PROPAGATION_REQUIRED</prop>
</props>
</property>
</bean>
<bean id="sqlMapClient" value="sql-map-config.xml"/>
<property name="dataSource" ref="dataSource"/>
</bean>
<!-- =========================sqlserver dataSource========================= -->
<bean id="dataSource2" destroy-method="close">
<property name="driverClassName" value="${jdbc2.driverClassName}"/>
<property name="url" value="${jdbc2.url}"/>
<property name="username" value="${jdbc2.username}"/>
<property name="password" value="${jdbc2.password}"/>
</bean>
<bean id="transactionManager2" ref="dataSource2"/>
</bean>
<bean id="transactionInterceptor2" ref="transactionManager2"/>
<property name="transactionAttributes">
<props>
<prop key="insert*">PROPAGATION_REQUIRED</prop>
<prop key="delete*">PROPAGATION_REQUIRED</prop>
<prop key="update*">PROPAGATION_REQUIRED</prop>
<prop key="do*">PROPAGATION_REQUIRED</prop>
</props>
</property>
</bean>
<bean id="sqlMapClient2" value="sql-map-config.xml"/>
<property name="dataSource" ref="dataSource2"/>
</bean>


<!-- =========================DAO配置 example ========================= -->
<bean id="FirstDAO" ref="sqlMapClient"/>
</bean>
<bean id="SecondDAO" ref="sqlMapClient2"/>
</bean>

<bean id="FirstService" ref="FirstDAO"/>
</bean>
<bean id="SecondService" ref="SecondDAO"/>
</bean>
</beans>




1 楼 zqwfd 2011-06-16 nc高手啊 2 楼 benbenxiongyuan 2011-06-17 zqwfd 写道nc高手啊
nc是啥意思？ 3 楼 zqwfd 2011-06-17 牛c，比nb狠