配置文件如下： ( 對應的表的引擎要是 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" > ??? ??? <!-- 數據源 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 > ??? <!-- 數據源 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 事務管理器 --> ??? < bean id = "springTransactionManager" class = "org.springframework.transaction.jta.JtaTransactionManager" > ?????? < property name = "transactionManager" ref = "atomikosTransactionManager" /> ?????? < property name = "userTransaction" ref = "atomikosUserTransaction" /> ??? </ bean > ??? ??? <!-- 第一個 sessionFactory ，有多少個數據庫就要有多少個數據源，也就要有多少個 sessionFactory ，每個 sessionFactory 對應一個數據源 --> ??? < 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 > ??
分享到：
發表評論
zsl131
最新評論
|
更多文章、技術交流、商務合作、聯系博主
微信掃碼或搜索：z360901061
微信掃一掃加我為好友
QQ號聯系： 360901061
您的支持是博主寫作最大的動力，如果您喜歡我的文章，感覺我的文章對您有幫助，請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧，狠狠點擊下面給點支持吧，站長非常感激您！手機微信長按不能支付解決辦法：請將微信支付二維碼保存到相冊，切換到微信，然后點擊微信右上角掃一掃功能，選擇支付二維碼完成支付。
【本文對您有幫助就好】元
評論