随着公司网站的发展，网站上的产品越来越多，单个mysql库表太多不好维护,我着手开始分库表，由于服务器是class="tags" href="/tags/TOMCAT.html" title=tomcat>tomcat的本身不支持JTA,我就打算用class="tags" href="/tags/SPRING.html" title=spring>spring+Jotm的方式来实现跨class="tags" href="/tags/ShuJuKu.html" title=数据库>数据库的事务管理,class="tags" href="/tags/SPRING.html" title=spring>spring的配置文件如下:
datasoruce.xml:
//jotm事务管理
<class="tags" href="/tags/BEAN.html" title=bean>bean id="jotmJta" class="org.class="tags" href="/tags/SPRING.html" title=spring>springframework.transaction.jta.JotmFactoryBean" />
<class="tags" href="/tags/BEAN.html" title=bean>bean id="jtaTxManager"  class="org.class="tags" href="/tags/SPRING.html" title=spring>springframework.transaction.jta.JtaTransactionManager">  
      <property name="userTransaction" ref="jotmJta"/>
</class="tags" href="/tags/BEAN.html" title=bean>bean>
///第一个datasource
<class="tags" href="/tags/BEAN.html" title=bean>bean id="familyDataSource" class="org.enhydra.jdbc.pool.StandardXAPoolDataSource" destroy-method="shutdown">  
    <property name="dataSource">
       <class="tags" href="/tags/BEAN.html" title=bean>bean class="org.enhydra.jdbc.standard.StandardXADataSource" destroy-method="shutdown">  
    <property name="transactionManager" ref="jotmJta" />
    <property name="driverName" value="com.mysql.jdbc.Driver"/>
    <property name="url" value="jdbc:mysql://192.168.0.12:3306/family?useUnicode=true&characterEncoding=GBK"/>
       </class="tags" href="/tags/BEAN.html" title=bean>bean>
    </property>
    <property name="user" value="xband"/>
    <property name="password" value="Lix8cjDb7$"/>
</class="tags" href="/tags/BEAN.html" title=bean>bean>
///第二个datasource
<class="tags" href="/tags/BEAN.html" title=bean>bean id="localDataSource" class="org.enhydra.jdbc.pool.StandardXAPoolDataSource" destroy-method="shutdown">  
    <property name="dataSource">
<class="tags" href="/tags/BEAN.html" title=bean>bean class="org.enhydra.jdbc.standard.StandardXADataSource" destroy-method="shutdown">  
<property name="transactionManager" ref="jotmJta" />
<property name="driverName" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost:3306/family?useUnicode=true&characterEncoding=GBK"/>
</class="tags" href="/tags/BEAN.html" title=bean>bean>
</property>
<property name="user" value="root"/>
<property name="password" value="1234"/>
</class="tags" href="/tags/BEAN.html" title=bean>bean>
<tx:annotation-driven transaction-manager="jtaTxManager"/>
///第一个class="tags" href="/tags/HIBERNATE.html" title=hibernate>hibernate配置
<class="tags" href="/tags/BEAN.html" title=bean>bean id="familySessionFactory" class="org.class="tags" href="/tags/SPRING.html" title=spring>springframework.orm.class="tags" href="/tags/HIBERNATE.html" title=hibernate>hibernate3.LocalSessionFactoryBean">
<property name="dataSource" ref="familyDataSource"/>
<property name="configLocation" value="classpath:class="tags" href="/tags/HIBERNATE.html" title=hibernate>hibernate.cfg.xml"/>
</class="tags" href="/tags/BEAN.html" title=bean>bean>
///第二个class="tags" href="/tags/HIBERNATE.html" title=hibernate>hibernate配置
<class="tags" href="/tags/BEAN.html" title=bean>bean id="localSessionFactory" class="org.class="tags" href="/tags/SPRING.html" title=spring>springframework.orm.class="tags" href="/tags/HIBERNATE.html" title=hibernate>hibernate3.LocalSessionFactoryBean">
<property name="dataSource" ref="localDataSource"/>
<property name="configLocation" value="classpath:class="tags" href="/tags/HIBERNATE.html" title=hibernate>hibernate.cfg.xml"/>
</class="tags" href="/tags/BEAN.html" title=bean>bean>
///service用@Transactional标识
<class="tags" href="/tags/BEAN.html" title=bean>bean id="jtaService" class="com.xband.client.test.JtaService">
  <property name="localJtaDAO" ref="localJtaDAO"/>
  <property name="familyJtaDAO" ref="familyJtaDAO"/>
  <property name="localJdbcDao" ref="localJdbcDao"/>
  <property name="familyJdbcDao" ref="familyJdbcDao"/>
</class="tags" href="/tags/BEAN.html" title=bean>bean>

这种方法如果用jdbc同事向两个库插入数据,rollback成功,但用class="tags" href="/tags/HIBERNATE.html" title=hibernate>hibernate插入数据，就连单个库都不会rollback,我看 了一下class="tags" href="/tags/SPRING.html" title=spring>spring的源代码LocalSessionFactoryBean里有个jtaTransactionManager，修改两个 SessionFactory如下:
<class="tags" href="/tags/BEAN.html" title=bean>bean id="familySessionFactory" class="org.class="tags" href="/tags/SPRING.html" title=spring>springframework.orm.class="tags" href="/tags/HIBERNATE.html" title=hibernate>hibernate3.LocalSessionFactoryBean">
<property name="dataSource" ref="familyDataSource"/>
<property name="configLocation" value="classpath:class="tags" href="/tags/HIBERNATE.html" title=hibernate>hibernate.cfg.xml"/>
<property name="jtaTransactionManager">  
<ref class="tags" href="/tags/BEAN.html" title=bean>bean="jotmJta" />  
</property> 
</class="tags" href="/tags/BEAN.html" title=bean>bean>

<class="tags" href="/tags/BEAN.html" title=bean>bean id="localSessionFactory" class="org.class="tags" href="/tags/SPRING.html" title=spring>springframework.orm.class="tags" href="/tags/HIBERNATE.html" title=hibernate>hibernate3.LocalSessionFactoryBean">
<property name="dataSource" ref="localDataSource"/>
<property name="configLocation" value="classpath:class="tags" href="/tags/HIBERNATE.html" title=hibernate>hibernate.cfg.xml"/>
                   <property name="jtaTransactionManager">  
<ref class="tags" href="/tags/BEAN.html" title=bean>bean="jotmJta" />  
</property> 

</class="tags" href="/tags/BEAN.html" title=bean>bean>

@Transaction注解对业务类jtaService进行事务声明，通过<tx:annotation-driven/>

mysql需要设置成innodb才能回滚事务

把connectionPoolSize的连接池大小设成0,应该有问题的，如果你用mysql的话用show processlist命令看一下class="tags" href="/tags/ShuJuKu.html" title=数据库>数据库的链接数，只有一个链接，而且这个链接总是sleep,我猜如果设为0的话链接池更本没有用，每次都是新建一个链 接.如果你把connectionPoolSize设为1，mysql显示会有两个链接，总会多一个链接出来，而且这个多出来的链接一直都是sleep. 不知道这个多出来的链接是干什么的.
    再补充一点atomikos的链接池和dbcp不一样，dbcp有一个initialSize和maxActive可以设,如果initialSize初 为1那么启项目时只有一个链接，最大链接为maxActive,atomikos的话只有connectionPoolSize属性，我观察过这个属性是 初始化链接数也是最大链接数！这点非常不好！
  我想问一下"collin000 "SimpleDataSourceBean(听名字就让人觉的不爽!)用的链接池性能上怎样?如果要用更好的链接池atomikos好像是要收费的,不知道能不能用xapool?因为我们是做网站的所以性能对我们来说非常重要