spring3 transaction

最新推荐文章于 2023-05-14 22:38:59 发布

Mark_Ly

最新推荐文章于 2023-05-14 22:38:59 发布

阅读量94

点赞数

分类专栏： spring 文章标签： spring3 jboss as 6 jat

spring 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

1. JBOSS中数据源的配置(mysql-xa-ds.xml支持分布式的事务)，如下：

<datasources>

  <xa-datasource>

    <jndi-name>test1</jndi-name>

    <track-connection-by-tx>true</track-connection-by-tx> 

    <xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>

    <xa-datasource-property name="Url">jdbc:mysql://10.0.0.107:3306/test1?useUnicode=true&characterEncoding=UTF-8</xa-datasource-property>

    <xa-datasource-property name="User">root</xa-datasource-property>

    <xa-datasource-property name="Password">root</xa-datasource-property>

    <metadata>

       <type-mapping>mySQL</type-mapping>

    </metadata>

  </xa-datasource>

  <xa-datasource>

    <jndi-name>test2</jndi-name>

    <track-connection-by-tx>true</track-connection-by-tx> 

    <xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>

    <xa-datasource-property name="Url">jdbc:mysql://10.0.0.106:3306/test?useUnicode=true&characterEncoding=UTF-8</xa-datasource-property>

    <xa-datasource-property name="User">root</xa-datasource-property>

    <xa-datasource-property name="Password">root</xa-datasource-property>

    <metadata>

       <type-mapping>mySQL</type-mapping>

    </metadata>

  </xa-datasource>

</datasources>

2. Spring application-Context.xml配置，如下：

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

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

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

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

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

xsi:schemaLocation="http://www.springframework.org/schema/beans

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

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

           http://www.springframework.org/schema/context/spring-context-3.0.xsd

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

           http://www.springframework.org/schema/aop/spring-aop-3.0.xsd

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

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

           http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-3.0.xsd">

<context:component-scan base-package="com.youyu" />

<jee:jndi-lookup id="dataSource_first" jndi-name="java:test1" />

<jee:jndi-lookup id="dataSource_second" jndi-name="java:test2" />

<bean id="transactionManager"

class="org.springframework.transaction.jta.JtaTransactionManager">

<property name="userTransactionName">

<value>java:comp/UserTransaction</value>

</property>

</bean>

<bean id="sqlSessionFactory_first" class="org.mybatis.spring.SqlSessionFactoryBean">

<property name="dataSource" ref="dataSource_first" />

<property name="configLocation" value="classpath:batisConfig_first.xml" />

</bean>

<bean id="sqlSessionFactory_second" class="org.mybatis.spring.SqlSessionFactoryBean">

<property name="dataSource" ref="dataSource_second" />

<property name="configLocation" value="classpath:batisConfig_second.xml" />

</bean>

<bean id="mapperScannerConfigure_first" class="org.mybatis.spring.mapper.MapperScannerConfigurer">

<property name="basePackage" value="com.youyu.access" />

<property name="sqlSessionFactory" ref="sqlSessionFactory_first" />

</bean>

<bean id="mapperScannerConfigure_second" class="org.mybatis.spring.mapper.MapperScannerConfigurer">

<property name="basePackage" value="com.youyu.accesstwo" />

<property name="sqlSessionFactory" ref="sqlSessionFactory_second" />

</bean>

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

</beans>

3. Service的注解，如下：

public interface AccountService {

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

public abstract int signUp(String name, String email);

}