读书人

spring+atomikos 跨库事宜配置

发布时间: 2012-08-22 09:50:35 作者: rapoo

spring+atomikos 跨库事务配置

<bean id="dataSourceA" destroy-method="close">?
??? ??? <property name="uniqueResourceName" value="mysql/merchant" />?
??? ??? <property name="xaDataSourceClassName" value="com.mysql.jdbc.jdbc2.optional.MysqlXADataSource" />?
??? ??? <property name="xaProperties">
??? ??? ??? <props>
??? ??? ??? ??? <prop key="user">root</prop>
??? ??? ??? ??? <prop key="password">wait4you</prop>
??? ??? ??? ??? <prop key="url">jdbc:mysql://10.0.10.24:3306/merchant?useUnicode=true&characterEncoding=utf-8</prop>
??? ??? ??? </props>

??? ??? </property>?
??? ??? <property name="poolSize" value="10"/>
??? ??? <property name="testQuery" value="SELECT 1"/>
??? </bean>
??
???
??? <bean id="dataSourceB" destroy-method="close">?
??? ??? <property name="uniqueResourceName" value="mysql/orders" />?
??? ??? <property name="xaDataSourceClassName" value="com.mysql.jdbc.jdbc2.optional.MysqlXADataSource" />?
??? ??? <property name="xaProperties">
??? ??? ??? <props>
??? ??? ??? ??? <!--prop key="user">root</prop>
??? ??? ??? ??? <prop key="password">wait4you</prop-->
??? ??? ??? ??? <prop key="user">specl</prop>
??? ??? ??? ??? <prop key="password">uBpEaNEI5</prop>
??? ??? ??? ??? <prop key="url">jdbc:mysql://10.0.10.34:3306/orders?useUnicode=true&characterEncoding=utf-8</prop>
??? ??? ??? </props>

??? ??? </property>?
??? ??? <property name="poolSize" value="10"/>
??? ??? <property name="testQuery" value="SELECT 1"/>
??? </bean>

?

?

<bean id="dataSource" value-ref="dataSourceB" />?
??????????????? <entry key="order_rw_0" value-ref="dataSourceB" />
??????????????? <entry key="merchant_r_0" value-ref="dataSourceA" />?
??????????????? <entry key="merchant_rw_0" value-ref="dataSourceA" />
??????????? </map>???
??????? </property>???
??????? <property name="defaultTargetDataSource" ref="dataSourceA"/>???
??? </bean>

??? <bean id="sqlMapClient" value="classpath:sqlmap-config.xml" />
??? ??? <property name="dataSource" ref="dataSource" />
??? </bean>

??? <bean id="atomikosTransactionManager" destroy-method="close">?
??????? <property name="forceShutdown">?
??????????? <value>true</value>?
??????? </property>?
??? </bean>?
??? <bean id="atomikosUserTransaction" value="300" />?
??? </bean>
???
??? <bean id="jtaTransactionManager" />?
??? ??? </property>?
??? ??? <property name="userTransaction">?
??? ??????? <ref bean="atomikosUserTransaction" />?
??? ??? </property>
??? ??? <qualifier value="jtaTx"></qualifier>
??? </bean>
???
??? <bean id="singleTransactionManager" ref="dataSourceA"/>
??????? <qualifier value="singleTx"></qualifier>
??? </bean>???

??? <bean id="boardDao" ref="sqlMapClient"></property>
??? </bean>

读书人网 >操作系统

热点推荐