配置文件如下： ( 对应的表的引擎要是 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
最新评论
|
评论