spring+jotm 多数据源事务管理(二)hibernate

hanqunfeng

浏览: 1526291 次
性别:
来自: 北京

最近访客更多访客>>

seasonroad

lehmann_ding

LoApa

sharzi

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

博客分类：

Spring
jotm

spring jotm

spring+jotm 多数据源事务管理系列

spring+jotm 多数据源事务管理(一)jdbc

spring+jotm 多数据源事务管理(二)hibernate

spring+jotm 多数据源事务管理(三)JNDI+Tomcat

使用hibernate关联jotm也很方便，先看一个没有使用jotm的例子：

<?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:p="http://www.springframework.org/schema/p"
	xmlns:aop="http://www.springframework.org/schema/aop" xmlns:context="http://www.springframework.org/schema/context"
	xmlns:tx="http://www.springframework.org/schema/tx" xmlns:util="http://www.springframework.org/schema/util"
	xmlns:jee="http://www.springframework.org/schema/jee"
	xsi:schemaLocation="
			http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd
			http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
			http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-2.5.xsd
			http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd
			http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-2.5.xsd
			http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-2.5.xsd">


    <bean id="dataSource1"  
        class="org.apache.commons.dbcp.BasicDataSource">  
        <property name="driverClassName">  
            <value>${datasource1.driver}</value>  
        </property>  
        <property name="url">  
            <value>${datasource1.url}</value>  
        </property>  
        <property name="username">  
            <value>${datasource1.username}</value>  
        </property>  
        <property name="password">  
            <value>${datasource1.password}</value>  
        </property>  
        <property name="initialSize">  
            <value>5</value>  
        </property>  
        <property name="maxActive">  
            <value>10</value>  
        </property>  
    </bean>  
      
    <bean id="dataSource2"  
        class="org.apache.commons.dbcp.BasicDataSource">  
        <property name="driverClassName">  
            <value>${datasource2.driver}</value>  
        </property>  
        <property name="url">  
            <value>${datasource2.url}</value>  
        </property>  
        <property name="username">  
            <value>${datasource2.username}</value>  
        </property>  
        <property name="password">  
            <value>${datasource2.password}</value>  
        </property>  
        <property name="initialSize">  
            <value>5</value>  
        </property>  
        <property name="maxActive">  
            <value>10</value>  
        </property>  
    </bean>  

	<bean id="sessionFactory1"
		class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
		<property name="dataSource" ref="dataSource1" />
		<property name="mappingLocations" value="${das.mapping.locations}" />
		<property name="hibernateProperties">
			<props>
				<prop key="hibernate.dialect">
					${hibernate.dialect}
				</prop>
				<prop key="hibernate.show_sql">
					${hibernate.show_sql}
				</prop>
				<prop key="hibernate.use_sql_comments">
					${hibernate.use_sql_comments}
				</prop>
			</props>
		</property>
	</bean>


	<bean id="sessionFactory2"
		class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
		<property name="dataSource" ref="dataSource2" />
		<property name="mappingLocations" value="${history.mapping.locations}" />
		<property name="hibernateProperties">
			<props>
				<prop key="hibernate.dialect">
					${hibernate.dialect}
				</prop>
				<prop key="hibernate.show_sql">
					${hibernate.show_sql}
				</prop>
				<prop key="hibernate.use_sql_comments">
					${hibernate.use_sql_comments}
				</prop>
			</props>
		</property>
	</bean>


	

	<bean id="transactionManager1"
		class="org.springframework.orm.hibernate3.HibernateTransactionManager">
		<property name="sessionFactory" ref="sessionFactory1" />
	</bean>
	<bean id="transactionManager2"
		class="org.springframework.orm.hibernate3.HibernateTransactionManager">
		<property name="sessionFactory" ref="sessionFactory2" />
	</bean>

	<aop:config proxy-target-class="true">
		<aop:pointcut id="servicePoint1"
			expression="execution (* com.xxx.function..service.*.*Service*.*(..))" />
		<aop:advisor pointcut-ref="servicePoint1" id="txAdvisor1"
			advice-ref="txAdvice1" />
	</aop:config>

	<aop:config proxy-target-class="true">
		<aop:pointcut id="servicePoint2"
			expression="execution (* com.xxx.function..service.*.*Service*.*(..))" />
		<aop:advisor pointcut-ref="servicePoint2" id="txAdvisor2"
			advice-ref="txAdvice2" />
	</aop:config>


	<tx:advice id="txAdvice1" transaction-manager="transactionManager1">
		<tx:attributes>
			<tx:method name="find*" read-only="true" />
			<tx:method name="get*" read-only="true" />
			<tx:method name="query*" read-only="true" />
			<tx:method name="load*" read-only="true" />
			<tx:method name="add*" propagation="REQUIRED" rollback-for="java.lang.Exception" />
			<tx:method name="create*" propagation="REQUIRED"
				rollback-for="java.lang.Exception" />
			<tx:method name="save*" propagation="REQUIRED"
				rollback-for="java.lang.Exception" />
			<tx:method name="update*" propagation="REQUIRED"
				rollback-for="java.lang.Exception" />
			<tx:method name="modify*" propagation="REQUIRED"
				rollback-for="java.lang.Exception" />
			<tx:method name="delete*" propagation="REQUIRED"
				rollback-for="java.lang.Exception" />
			<tx:method name="remove*" propagation="REQUIRED"
				rollback-for="java.lang.Exception" />
			<tx:method name="apply*" propagation="REQUIRED"
				rollback-for="java.lang.Exception" />
			<tx:method name="handle*" propagation="REQUIRED"
				rollback-for="java.lang.Exception" />
		</tx:attributes>
	</tx:advice>
	<tx:advice id="txAdvice2" transaction-manager="transactionManager2">
		<tx:attributes>
			<tx:method name="find*" read-only="true" />
			<tx:method name="get*" read-only="true" />
			<tx:method name="query*" read-only="true" />
			<tx:method name="load*" read-only="true" />
			<tx:method name="add*" propagation="REQUIRED" rollback-for="java.lang.Exception" />
			<tx:method name="create*" propagation="REQUIRED"
				rollback-for="java.lang.Exception" />
			<tx:method name="save*" propagation="REQUIRED"
				rollback-for="java.lang.Exception" />
			<tx:method name="update*" propagation="REQUIRED"
				rollback-for="java.lang.Exception" />
			<tx:method name="modify*" propagation="REQUIRED"
				rollback-for="java.lang.Exception" />
			<tx:method name="delete*" propagation="REQUIRED"
				rollback-for="java.lang.Exception" />
			<tx:method name="remove*" propagation="REQUIRED"
				rollback-for="java.lang.Exception" />
			<tx:method name="apply*" propagation="REQUIRED"
				rollback-for="java.lang.Exception" />
			<tx:method name="handle*" propagation="REQUIRED"
				rollback-for="java.lang.Exception" />
				<tx:method name="do*" propagation="REQUIRED"
				rollback-for="java.lang.Exception" />
		</tx:attributes>
	</tx:advice>


</beans>

下面看加入jotm的例子：

<?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:p="http://www.springframework.org/schema/p"
	xmlns:aop="http://www.springframework.org/schema/aop" xmlns:context="http://www.springframework.org/schema/context"
	xmlns:tx="http://www.springframework.org/schema/tx" xmlns:util="http://www.springframework.org/schema/util"
	xmlns:jee="http://www.springframework.org/schema/jee" xmlns:security="http://www.springframework.org/schema/security"
	xsi:schemaLocation="
			http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
			http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd
			http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-2.5.xsd
			http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd
			http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-2.5.xsd
			http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-2.5.xsd
            http://www.springframework.org/schema/security http://www.springframework.org/schema/security/spring-security-2.0.xsd"
	default-lazy-init="true">


	<bean id="jotm" class="org.springframework.transaction.jta.JotmFactoryBean" />

	<bean id="transactionManager"
		class="org.springframework.transaction.jta.JtaTransactionManager">
		<property name="userTransaction" ref="jotm" />
	</bean>

	<bean id="dataSource1" class="org.enhydra.jdbc.pool.StandardXAPoolDataSource"
		destroy-method="shutdown">
		<property name="dataSource">
			<bean class="org.enhydra.jdbc.standard.StandardXADataSource"
				destroy-method="shutdown">
				<property name="transactionManager" ref="jotm" />
				<property name="driverName" value="${datasource1.driver}" />
				<property name="url" value="${datasource1.url}" />
			</bean>
		</property>
		<property name="user" value="${datasource1.username}" />
		<property name="password" value="${datasource1.password}" />
	</bean>

	<bean id="dataSource2" class="org.enhydra.jdbc.pool.StandardXAPoolDataSource"
		destroy-method="shutdown">
		<property name="dataSource">
			<bean class="org.enhydra.jdbc.standard.StandardXADataSource"
				destroy-method="shutdown">
				<property name="transactionManager" ref="jotm" />
				<property name="driverName" value="${datasource2.driver}" />
				<property name="url" value="${datasource2.url}" />
			</bean>
		</property>
		<property name="user" value="${datasource2.username}" />
		<property name="password" value="${datasource2.password}" />
	</bean>


	

	<bean id="sessionFactory1"
		class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
		<property name="dataSource" ref="dataSource1" />
		<property name="mappingLocations" value="${hibernate.mapping.locations}" />
		<property name="hibernateProperties">
			<props>
				<prop key="hibernate.dialect">
					${hibernate.dialect}
				</prop>
				<prop key="hibernate.show_sql">
					${hibernate.show_sql}
				</prop>
				<prop key="hibernate.use_sql_comments">
					${hibernate.use_sql_comments}
				</prop>
			</props>
		</property>
	</bean>

	
	<bean id="sessionFactory2"
		class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
		<property name="dataSource" ref="dataSource2" />
		<property name="mappingLocations" value="${hibernate.mapping.special}" />
		<property name="hibernateProperties">
			<props>
				<prop key="hibernate.dialect">
					${hibernate.dialect}
				</prop>
				<prop key="hibernate.show_sql">
					${hibernate.show_sql}
				</prop>
				<prop key="hibernate.use_sql_comments">
					${hibernate.use_sql_comments}
				</prop>
			</props>
		</property>
	</bean>

	<aop:config proxy-target-class="true">
		<aop:pointcut id="servicePoint"
			expression="execution (* com.xxx.function.*.service.*.*Service*.*(..))" />
		<aop:advisor pointcut-ref="servicePoint" id="txAdvisor"
			advice-ref="defaultTxAdvice" />
	</aop:config>

	<tx:advice id="defaultTxAdvice" transaction-manager="transactionManager">
		<tx:attributes>
			<tx:method name="find*" read-only="true" />
			<tx:method name="get*" read-only="true" />
			<tx:method name="query*" read-only="true" />
			<tx:method name="load*" read-only="true" />
			<tx:method name="add*" propagation="REQUIRED" rollback-for="java.lang.Exception" />
			<tx:method name="create*" propagation="REQUIRED"
				rollback-for="java.lang.Exception" />
			<tx:method name="save*" propagation="REQUIRED"
				rollback-for="java.lang.Exception" />
			<tx:method name="update*" propagation="REQUIRED"
				rollback-for="java.lang.Exception" />
			<tx:method name="modify*" propagation="REQUIRED"
				rollback-for="java.lang.Exception" />
			<tx:method name="delete*" propagation="REQUIRED"
				rollback-for="java.lang.Exception" />
			<tx:method name="remove*" propagation="REQUIRED"
				rollback-for="java.lang.Exception" />
			<tx:method name="apply*" propagation="REQUIRED"
				rollback-for="java.lang.Exception" />
			<tx:method name="handle*" propagation="REQUIRED"
				rollback-for="java.lang.Exception" />
		</tx:attributes>
	</tx:advice>

	

</beans>

ok。

分享到：

spring+jotm 多数据源事务管理(三)JNDI+To ... | spring+jotm 多数据源事务管理(一)jdbc

2012-06-07 11:20
浏览 2813
评论(0)
论坛回复 / 浏览 (0 / 1675)
分类:编程语言
查看更多

发表评论

您还没有登录,请您登录后再发表评论

最近访客更多访客>>

博主相关

文章分类

社区版块

存档分类

最新评论

spring+jotm 多数据源事务管理(二)hibernate

spring+jotm 多数据源事务管理(一)jdbc

spring+jotm 多数据源事务管理(二)hibernate

spring+jotm 多数据源事务管理(三)JNDI+Tomcat

评论

发表评论

相关推荐

最近访客 更多访客>>

博主相关

文章分类

社区版块

存档分类

最新评论

spring+jotm 多数据源事务管理(二)hibernate

spring+jotm 多数据源事务管理(一)jdbc

spring+jotm 多数据源事务管理(二)hibernate

spring+jotm 多数据源事务管理(三)JNDI+Tomcat

评论

发表评论

相关推荐

Druid学习笔记

Spring Cache注解+Redis

Spring Cache注解+Memcached

Spring4+Hibernate4+Atomikos3.3多数据源事务管理

SpringMVC4零配置--Web上下文配置【MvcConfig】

SpringMVC4零配置--SpringSecurity相关配置【SpringSecurityConfig】

SpringMVC4零配置--应用上下文配置【AppConfig】

SpringMVC4零配置--web.xml

SpringMVC4零配置

SpringSecurity3.X--LDAP：AD配置

Thrift--JSClient

Thrift--Spring集成ThriftServlet

Thrift转SpringHttpInvoker

Spring集成Thrift--Server AND Client

C3P0配置实战

spring+jotm 多数据源事务管理(三)JNDI+Tomcat

spring+jotm 多数据源事务管理(一)jdbc

SpringSecurity3.X--Cas client 配置之配置session-management遇到的问题(2)

SpringSecurity3.X--Cas client 配置之配置session-management遇到的问题

使用Spring3.1 Cache注解+EHCache遇到的问题

最近访客更多访客>>