配置文件如下: ( 對(duì)應(yīng)的表的引擎要是 INNODB 的才可以 )
<? 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:aop = "http://www.springframework.org/schema/aop" ??? ???? xmlns:tx = "http://www.springframework.org/schema/tx" ??? ???? xsi:schemaLocation = "http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd ?????????? http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.0.xsd ?????????? http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.0.xsd" > ??? ??? <!-- 數(shù)據(jù)源 1 --> ??? < bean id = "dataSource1" class = "com.atomikos.jdbc.SimpleDataSourceBean" init-method = "init" destroy-method = "close" > ??? < property name = "uniqueResourceName" > ?? ??????????? < value > mysql/main </ value > ?? ??????? </ property > ?? ??????? < property name = "xaDataSourceClassName" > ?? ??????????? <!-- 使用 Mysql XADataSource(mysql>=5.0, Connector/J>=5.0 才可以支持 XADatasource)--> ?? ??????????? < value > com.mysql.jdbc.jdbc2.optional.MysqlXADataSource </ value > ??????? </ property > ?? ??????? < property name = "xaDataSourceProperties" > ?? ??????????? < value > URL=jdbc:mysql://localhost:3306/test?useUnicode=true & characterEncoding=utf-8;user=root;password=123456 </ value > ?? ??????? </ property > ? ???????? < property name = "validatingQuery" > ??????????? < value > SELECT 1 </ value > ?? ??????? </ property > ??? </ bean > ??? <!-- 數(shù)據(jù)源 2 --> ??? < bean id = "dataSource2" class = "com.atomikos.jdbc.SimpleDataSourceBean" init-method = "init" destroy-method = "close" > ?? ??????? < property name = "uniqueResourceName" > ?? ??????????? < value > mysql/secondary </ value > ?? ??????? </ property > ?? ??????? < property name = "xaDataSourceClassName" > ?? ??????????? <!-- 使用 Mysql XADataSource(mysql>=5.0, Connector/J>=5.0 才可以支持 XADatasource)--> ?? ??????????? < value > com.mysql.jdbc.jdbc2.optional.MysqlXADataSource </ value > ?? ??????? </ property > ??????? < property name = "xaDataSourceProperties" > ?? ??????????? < value > URL=jdbc:mysql://localhost:3306/test2?useUnicode=true & characterEncoding=utf-8;user=root;password=123456 </ value > ?? ??????? </ property > ???????? < property name = "validatingQuery" > ??????????? < value > SELECT 1 </ value > ?? ??????? </ property > ??? </ bean > ??? ??? < bean id = "atomikosTransactionManager" class = "com.atomikos.icatch.jta.UserTransactionManager" init-method = "init" destroy-method = "close" > ??????? < property name = "forceShutdown" value = "true" /> ??? </ bean > ? ? ?? < bean id = "atomikosUserTransaction" class = "com.atomikos.icatch.jta.UserTransactionImp" > ??????? < property name = "transactionTimeout" value = "300" /> ??? </ bean > ??? ??? <!-- JTA 事務(wù)管理器 --> ??? < bean id = "springTransactionManager" class = "org.springframework.transaction.jta.JtaTransactionManager" > ?????? < property name = "transactionManager" ref = "atomikosTransactionManager" /> ?????? < property name = "userTransaction" ref = "atomikosUserTransaction" /> ??? </ bean > ??? ??? <!-- 第一個(gè) sessionFactory ,有多少個(gè)數(shù)據(jù)庫(kù)就要有多少個(gè)數(shù)據(jù)源,也就要有多少個(gè) sessionFactory ,每個(gè) sessionFactory 對(duì)應(yīng)一個(gè)數(shù)據(jù)源 --> ??? < bean id = "sessionFactory1" class = "org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean" > ?????? < property name = "dataSource" ref = "dataSource1" /> ?????? < property name = "annotatedClasses" > ?????????? < list > ????????????? < value > org.zsl.jta.model.User </ value > ?????????? </ list > ?????? </ property > ?????? < property name = "hibernateProperties" > ?????????? < props > ????????????? < prop key = "hibernate.dialect" > org.hibernate.dialect.MySQLDialect </ prop > ????????????? < prop key = "hibernate.show_sql" > true </ prop > ????????????? < prop key = "hibernate.hbm2ddl.auto" > update </ prop > ????????????? <!-- ????????????? <prop key="hibernate.cache.provider_class">org.hibernate.cache.EhCacheProvider</prop> ????????????? <prop key="hibernate.cache.use_query_cache">true</prop> ????????????? ? --> ?????????? </ props > ?????? </ property > ??? </ bean > ??
發(fā)表評(píng)論
最新評(píng)論
|
更多文章、技術(shù)交流、商務(wù)合作、聯(lián)系博主
微信掃碼或搜索:z360901061

微信掃一掃加我為好友
QQ號(hào)聯(lián)系: 360901061
您的支持是博主寫(xiě)作最大的動(dòng)力,如果您喜歡我的文章,感覺(jué)我的文章對(duì)您有幫助,請(qǐng)用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧,狠狠點(diǎn)擊下面給點(diǎn)支持吧,站長(zhǎng)非常感激您!手機(jī)微信長(zhǎng)按不能支付解決辦法:請(qǐng)將微信支付二維碼保存到相冊(cè),切換到微信,然后點(diǎn)擊微信右上角掃一掃功能,選擇支付二維碼完成支付。
【本文對(duì)您有幫助就好】元

評(píng)論