hibernate 多数据源 延迟加载

最近在优化公司的系统的时候mysql数据库采用了读写分离策略，同样的sessionFactory要配置两个，但原有的项目中大量应用了hibernate的延时加载，在调试的时候才发现，无论如何都不能同时实现两个sessionFactory的延时加载，后来通过翻阅资料和阅读源码，终于找到了解决方案:

两个sessionFactory的在spirng配置如下：

Java代码  

1. <bean  
2.     id="sessionFactoryAssist"  
3.     class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">  
4.     <property name="configurationClass">  
5.         <value>com.landray.kmss.sys.config.loader.HibernateConfiguration</value>  
6.     </property>  
7.     <property name="hibernateProperties">  
8.         <props>  
9.             <prop key="hibernate.dialect">  
10.                 ${hibernate.dialect}  
11.             </prop>  
12.         </props>  
13.     </property>  
14.     <property name="dataSource">  
15.         <ref bean="dataSourceAssist" />  
16.     </property>  
17.     <property name="lobHandler">  
18.         <ref bean="oracleLobHandler" />  
19.     </property>  
20. </bean>  
21. <bean  
22.     id="sessionFactory"  
23.     class="com.landray.kmss.sys.config.loader.KmssHibernateLocalSessionFactoryBean">  
24.     <property name="configurationClass">  
25.         <value>com.landray.kmss.sys.config.loader.HibernateConfiguration</value>  
26.     </property>  
27.     <property name="hibernateProperties">  
28.         <props>  
29.             <prop key="hibernate.dialect">  
30.                 ${hibernate.dialect}  
31.             </prop>  
32.         </props>  
33.     </property>  
34.     <property name="dataSource">  
35.         <ref bean="dataSource" />  
36.     </property>  
37.     <property name="lobHandler">  
38.         <ref bean="oracleLobHandler" />  
39.     </property>  
40. </bean>  

 

在web.xml中配置两个hibernate filter，分别管理这两个sessionFactory，来实现延时加载：

 

Java代码  

1. <filter>  
2.         <filter-name>hibernateFilter</filter-name>  
3.         <filter-class>  
4.             org.springframework.orm.hibernate3.support.OpenSessionInViewFilter  
5.         </filter-class>  
6.           <init-param>    
7.                <param-name>sessionFactoryBeanName</param-name>    
8.                <param-value>sessionFactory</param-value>    
9.          </init-param>    
10.          <init-param>    
11.              <param-name>singleSession</param-name>    
12.              <param-value>true</param-value>    
13.          </init-param>    
14.          <init-param>    
15.              <param-name>flushMode</param-name>    
16.              <param-value>AUTO</param-value>    
17.          </init-param>    
18.     </filter>  
19.     <filter>  
20.         <filter-name>hibernateFilterAssist</filter-name>  
21.         <filter-class>  
22.             org.springframework.orm.hibernate3.support.OpenSessionInViewFilter  
23.         </filter-class>  
24.           <init-param>    
25.                <param-name>sessionFactoryBeanName</param-name>    
26.                <param-value>sessionFactoryAssist</param-value>    
27.          </init-param>    
28.          <init-param>    
29.              <param-name>singleSession</param-name>    
30.              <param-value>true</param-value>    
31.          </init-param>    
32.          <init-param>    
33.              <param-name>flushMode</param-name>    
34.              <param-value>AUTO</param-value>    
35.          </init-param>    
36.     </filter>  

 

 至此，两个sessionFactory均可以实现延时加载了。