Spring+Hibernate实现动态SessionFactory切换(改进版)

前面写了一篇关于动态切换Hibernate SessionFactory的文章，原文地址：http://tangyanbo.iteye.com/admin/blogs/1717402

发现存在一些问题：
需要配置多个HibernateTransactionManager和多个Spring 切面
这样带来两个问题
1. 程序效率降低，因为Spring进行多次Advice的拦截
2. 如果其中一个SessionFactory连接出现问题，会导致整个系统无法工作

今天研究出一种新的方法来解决此类问题
1. 数据源及Hibernate SessionFactory配置：

 

<?xml version="1.0" encoding="UTF-8"?>  
<beans xmlns="http://www.springframework.org/schema/beans"  
    xmlns:p="http://www.springframework.org/schema/p"  
    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" xmlns:context="http://www.springframework.org/schema/context"  
    xsi:schemaLocation="  
            http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd  
            http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd  
            http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd  
            http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd">  
    <!-- FOR SqlServer-->  
    <bean id="SqlServer_DataSource"  
        class="org.springframework.jdbc.datasource.DriverManagerDataSource">  
        <property name="driverClassName" value="com.microsoft.sqlserver.jdbc.SQLServerDriver" />  
        <property name="url"  
            value="url" />  
        <property name="username" value="username" />  
        <property name="password" value="password" />  
    </bean>  
    <bean id="SqlServer_SessionFactory"  
        class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"  
        p:mappingLocations="classpath:/com/entity/*.hbm.xml">  
        <property name="dataSource" ref="SqlServer_DataSource" />       
        <property name="hibernateProperties">  
            <props>                 
                <prop key="hibernate.query.factory_class">org.hibernate.hql.ast.ASTQueryTranslatorFactory</prop>  
                <prop key="hibernate.dialect">org.hibernate.dialect.SQLServer2008Dialect</prop>               
                <prop key="hibernate.show_sql">true</prop>  
                <prop key="hibernate.format_sql">true</prop>  
            </props>  
        </property>  
    </bean>  
   
      
    <!-- FOR Oracle -->  
    <bean id="Oracle _DataSource"  
        class="org.springframework.jdbc.datasource.DriverManagerDataSource">       
        <property name="driverClassName" value="oracle.jdbc.OracleDriver" />  
        <property name="url" value="jdbc:oracle:thin:@localhost:1521/orcl" />  
        <property name="username" value="username" />  
        <property name="password" value="password" />  
    </bean>  
    <bean id="Oracle_SessionFactory"  
        class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"   
        p:mappingLocations="classpath:/com/entity/*.hbm.xml">  
        <property name="dataSource" ref="Oracle_DataSource" />          
        <property name="hibernateProperties">  
            <props>  
                <prop key="hibernate.query.factory_class">org.hibernate.hql.ast.ASTQueryTranslatorFactory</prop>  
                <prop key="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</prop>               
                <prop key="hibernate.show_sql">true</prop>  
                <prop key="hibernate.format_sql">true</prop>  
            </props>  
        </property>  
    </bean>        
</beans>  

 

 

2. 定义扩展接口DynamicSessionFactoryInf继承SessionFactory

 

 

Java代码  

1. import  org.hibernate.SessionFactory;  
2.   
3. public   interface  DynamicSessionFactoryInf  extends  SessionFactory {  
4.   
5.     public  SessionFactory getHibernateSessionFactory();  
6. }  

 

3. 定义DynamicSessionFactory实现DynamicSessionFactoryInf

 

Java代码  

1. public   class  DynamicSessionFactory  implements  DynamicSessionFactoryInf ,ApplicationContextAware{  
2.       
3.     private   static   final   long  serialVersionUID = 1L;  
4.   
5.     private  ApplicationContext applicationContext;  
6.     //动态调用SessionFactory   
7.     private  SessionFactory getHibernateSessionFactory(String name) {  
8.         return  (SessionFactory) applicationContext.getBean(name);  
9.     }  
10.         //实现DynamicSessionFactoryInf 接口的方法   
11.     public  SessionFactory getHibernateSessionFactory() {  
12.         return  getHibernateSessionFactory(ThreadLocalUtil.getCurrentITAsset()  
13.                 .getSessionFactoryName());  
14.     }  
15.       
16.        //以下是实现SessionFactory接口的方法，并对当前的SessionFactory实体进行代理   
17.     public  Reference getReference()  throws  NamingException {  
18.         return  getHibernateSessionFactory().getReference();  
19.     }  
20.   
21.       
22.   
23.     public  Session openSession()  throws  HibernateException {  
24.         return  getHibernateSessionFactory().openSession();  
25.     }  
26.   
27.     public  Session openSession(Interceptor interceptor)  
28.             throws  HibernateException {  
29.         return  getHibernateSessionFactory().openSession(interceptor);  
30.     }  
31.   
32.     public  Session openSession(Connection connection) {  
33.         return  getHibernateSessionFactory().openSession(connection);  
34.     }  
35.   
36.     public  Session openSession(Connection connection, Interceptor interceptor) {  
37.         return  getHibernateSessionFactory().openSession(connection,interceptor);  
38.     }  
39.   
40.     public  Session getCurrentSession()  throws  HibernateException {  
41.         return  getHibernateSessionFactory().getCurrentSession();  
42.     }  
43.   
44.     public  StatelessSession openStatelessSession() {  
45.         return  getHibernateSessionFactory().openStatelessSession();  
46.     }  
47.   
48.     public  StatelessSession openStatelessSession(Connection connection) {  
49.         return  getHibernateSessionFactory().openStatelessSession(connection);  
50.     }  
51.   
52.     public  ClassMetadata getClassMetadata(Class entityClass) {  
53.         return  getHibernateSessionFactory().getClassMetadata(entityClass);  
54.     }  
55.   
56.     public  ClassMetadata getClassMetadata(String entityName) {  
57.         return  getHibernateSessionFactory().getClassMetadata(entityName);  
58.     }  
59.   
60.     public  CollectionMetadata getCollectionMetadata(String roleName) {  
61.         return  getHibernateSessionFactory().getCollectionMetadata(roleName);  
62.     }  
63.   
64.     public  Map getAllClassMetadata() {  
65.         return  getHibernateSessionFactory().getAllClassMetadata();  
66.     }  
67.   
68.     public  Map getAllCollectionMetadata() {  
69.         return  getHibernateSessionFactory().getAllCollectionMetadata();  
70.     }  
71.   
72.     public  Statistics getStatistics() {  
73.         return  getHibernateSessionFactory().getStatistics();  
74.     }  
75.   
76.     public   void  close()  throws  HibernateException {  
77.         getHibernateSessionFactory().close();  
78.     }  
79.   
80.     public   boolean  isClosed() {  
81.         return  getHibernateSessionFactory().isClosed();  
82.     }  
83.   
84.     public  Cache getCache() {  
85.         return  getHibernateSessionFactory().getCache();  
86.     }  
87.   
88.     public   void  evict(Class persistentClass)  throws  HibernateException {  
89.         getHibernateSessionFactory().evict(persistentClass);  
90.     }  
91.   
92.     public   void  evict(Class persistentClass, Serializable id)  
93.             throws  HibernateException {  
94.         getHibernateSessionFactory().evict(persistentClass, id);  
95.     }  
96.   
97.     public   void  evictEntity(String entityName)  throws  HibernateException {  
98.         getHibernateSessionFactory().evictEntity(entityName);  
99.     }  
100.   
101.     public   void  evictEntity(String entityName, Serializable id)  
102.             throws  HibernateException {  
103.         getHibernateSessionFactory().evictEntity(entityName, id);  
104.     }  
105.   
106.     public   void  evictCollection(String roleName)  throws  HibernateException {  
107.         getHibernateSessionFactory().evictCollection(roleName);  
108.     }  
109.   
110.     public   void  evictCollection(String roleName, Serializable id)  
111.             throws  HibernateException {  
112.         getHibernateSessionFactory().evictCollection(roleName, id);  
113.     }  
114.   
115.     public   void  evictQueries(String cacheRegion)  throws  HibernateException {  
116.         getHibernateSessionFactory().evictQueries(cacheRegion);  
117.     }  
118.   
119.     public   void  evictQueries()  throws  HibernateException {  
120.         getHibernateSessionFactory().evictQueries();  
121.     }  
122.   
123.     public  Set getDefinedFilterNames() {  
124.         return  getHibernateSessionFactory().getDefinedFilterNames();  
125.     }  
126.   
127.     public  FilterDefinition getFilterDefinition(String filterName)  
128.             throws  HibernateException {  
129.         return  getHibernateSessionFactory().getFilterDefinition(filterName);  
130.     }  
131.   
132.     public   boolean  containsFetchProfileDefinition(String name) {  
133.         return  getHibernateSessionFactory().containsFetchProfileDefinition(name);  
134.     }  
135.   
136.     @Override   
137.     public   void  setApplicationContext(ApplicationContext applicationContext)  
138.             throws  BeansException {  
139.         this .applicationContext = applicationContext;  
140.     }  
141.   
142.       
143.   
144. }  

 

4. 配置动态SessionFactory

 

Xml代码  

1. < bean   id = "sessionFactory"   class = "com.hp.it.qdpadmin.common.DynamicSessionFactory" />    

 

 

5. 定义DynamicTransactionManager继承HibernateTransactionManager

 

Java代码  

1. public   class  DynamicTransactionManager  extends  HibernateTransactionManager {  
2.   
3.     private   static   final   long  serialVersionUID = 1047039346475978451L;  
4.     //重写getDataSource方法，实现动态获取   
5.     public  DataSource getDataSource() {  
6.         DataSource sfds = SessionFactoryUtils.getDataSource(getSessionFactory());  
7.         return  sfds;  
8.     }  
9.        //重写getSessionFactory方法，实现动态获取SessionFactory   
10.     public  SessionFactory getSessionFactory() {  
11.         DynamicSessionFactoryInf dynamicSessionFactory = (DynamicSessionFactoryInf) super   
12.                 .getSessionFactory();  
13.         SessionFactory hibernateSessionFactory = dynamicSessionFactory  
14.                 .getHibernateSessionFactory();  
15.         return  hibernateSessionFactory;  
16.     }  
17.     //重写afterPropertiesSet，跳过数据源的初始化等操作   
18.     public   void  afterPropertiesSet() {  
19.         return ;  
20.     }  
21.   
22. }  

 

6. 配置dynamicTransactionManager

 

<bean id="dynamicTransactionManager"
		class="com.hp.it.qdpadmin.common.DynamicTransactionManager">
		<property name="sessionFactory" ref="sessionFactory"/>
</bean>

 

 

7. 为SessionFactory配置事务切面

<tx:advice id="dynamicTxAdvice" transaction-manager="dynamicTransactionManager">  
        <tx:attributes>  
            <tx:method name="get*" read-only="true" />  
            <tx:method name="find*" read-only="true" />  
            <tx:method name="*" propagation="REQUIRED" rollback-for="Exception" />  
        </tx:attributes>  
    </tx:advice>  
      
      
    <aop:config proxy-target-class="true">    
        <aop:pointcut id="txPointcut" expression="execution(* com.service.*.*(..))"/>          
        <aop:advisor advice-ref="dynamicTxAdvice" pointcut-ref="txPointcut" /> 
    </aop:config>