spring+hibernate多数据源切换のSessionFactory切换

2024-06-01 08:38
文章标签 java 切换 spring 数据源 hibernate sessionfactory

本文主要是介绍spring+hibernate多数据源切换のSessionFactory切换，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

看到好多多数据源的例子，有切换datasource的，有切换sessionFactory的，我的是mysql和sqlserver两个数据库之间的切换，涉及到方言，所以就采用了后者。因为之前差点成功了，但是由于疏忽犯了个脑残失误就卡在somewhe了 ，今天本来想理清一下思路问大神的，结果理了一下，自己搞定了。不废话了，直接进入正题。

首先说配置方面，正常情况下都是陪一个datasource,一个sessionfactory,有事务还要配置tansationManager，如果是多数据源的话，就会有两个datasource，如果是不同类型的数据库的话，就需要连个Sessionfactory来配置方言。以下是配置内容

<!-- mysql --><bean id="dataSourceMS" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close"><property name="driverClass" value="${datasource.driver}"/><property name="jdbcUrl" value="${datasource.url}"/><property name="user" value="${datasource.username}"/><property name="password" value="${datasource.password}"/><property name="acquireIncrement" value="${c3p0.acquireIncrement}"/><property name="initialPoolSize" value="${c3p0.initialPoolSize}"/><property name="minPoolSize" value="${c3p0.minPoolSize}"/><property name="maxPoolSize" value="${c3p0.maxPoolSize}"/><property name="maxIdleTime" value="${c3p0.maxIdleTime}"/><property name="idleConnectionTestPeriod" value="${c3p0.idleConnectionTestPeriod}"/><property name="maxStatements" value="${c3p0.maxStatements}"/><property name="numHelperThreads" value="${c3p0.numHelperThreads}"/><!-- <property name="preferredTestQuery" value="${c3p0.preferredTestQuery}"/> --><property name="testConnectionOnCheckout" value="${c3p0.testConnectionOnCheckout}"/></bean><bean id="sessionFactoryMS"	class="org.springframework.orm.hibernate4.LocalSessionFactoryBean"><property name="dataSource" ref="dataSourceMS" /><property name="hibernateProperties"><props><prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop><prop key="hibernate.show_sql">false</prop><prop key="hibernate.cache.region.factory_class">org.hibernate.cache.ehcache.EhCacheRegionFactory</prop><prop key="hibernate.format_sql">false</prop><prop key="hibernate.use_sql_comments">false</prop><prop key="hibernate.jdbc.fetch_size">80</prop><prop key="hibernate.jdbc.batch_size">80</prop><prop key="hibernate.jdbc.use_streams_for_binary">true</prop><prop key="hibernate.current_session_context_class">org.springframework.orm.hibernate4.SpringSessionContext</prop><prop key="hibernate.cache.use_second_level_cache">true</prop><prop key="hibernate.cache.use_query_cache">true</prop><prop key="hibernate.max_fetch_depth">3</prop><prop key="hibernate.hbm2ddl.auto">none</prop></props></property><property name="packagesToScan" value="com.ivo.*" /></bean><!-- sqlServer --><bean id="dataSourceSS" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close"><property name="driverClass" value="${datasource2.driver}"/><property name="jdbcUrl" value="${datasource2.url}"/><property name="user" value="${datasource2.username}"/><property name="password" value="${datasource2.password}"/><property name="acquireIncrement" value="${c3p0.acquireIncrement}"/><property name="initialPoolSize" value="${c3p0.initialPoolSize}"/><property name="minPoolSize" value="${c3p0.minPoolSize}"/><property name="maxPoolSize" value="${c3p0.maxPoolSize}"/><property name="maxIdleTime" value="${c3p0.maxIdleTime}"/><property name="idleConnectionTestPeriod" value="${c3p0.idleConnectionTestPeriod}"/><property name="maxStatements" value="${c3p0.maxStatements}"/><property name="numHelperThreads" value="${c3p0.numHelperThreads}"/><!-- <property name="preferredTestQuery" value="${c3p0.preferredTestQuery}"/> --><property name="testConnectionOnCheckout" value="${c3p0.testConnectionOnCheckout}"/></bean><bean id="sessionFactorySS"	class="org.springframework.orm.hibernate4.LocalSessionFactoryBean"><property name="dataSource" ref="dataSourceSS" /><property name="hibernateProperties"><props><prop key="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</prop><prop key="hibernate.show_sql">false</prop><prop key="hibernate.cache.region.factory_class">org.hibernate.cache.ehcache.EhCacheRegionFactory</prop><prop key="hibernate.format_sql">false</prop><prop key="hibernate.use_sql_comments">false</prop><prop key="hibernate.jdbc.fetch_size">80</prop><prop key="hibernate.jdbc.batch_size">80</prop><prop key="hibernate.jdbc.use_streams_for_binary">true</prop><prop key="hibernate.current_session_context_class">org.springframework.orm.hibernate4.SpringSessionContext</prop><prop key="hibernate.cache.use_second_level_cache">true</prop><prop key="hibernate.cache.use_query_cache">true</prop><prop key="hibernate.max_fetch_depth">3</prop><prop key="hibernate.hbm2ddl.auto">none</prop></props></property><property name="packagesToScan" value="com.ivo.*" /></bean><!-- 动态SessionFactory --><bean id="sessionFactory" class="com.ivo.util2.DynamicSessionFactoryImpl"><property name="defaultTargetSessionFactory" ref="sessionFactoryMS"/><property name="targetSessionFactorys"><map>     <entry value-ref="sessionFactoryMS" key="sessionFactoryMS"/><entry value-ref="sessionFactorySS" key="sessionFactorySS"/></map> </property></bean><bean class="com.ivo.core.HibernateInvoker"><property name="sessionFactory" ref="sessionFactory" /></bean><!-- 自定义动态切换SessionFactory事务管理器，注入sessionFactory  --><bean id="transactionManager" class="com.ivo.util2.DynamicTransactionManager"><property name="sessionFactory" ref="sessionFactory" /></bean>

好了，xml配置就这么多，然后开始用自己写的类来接管Sessionfactory和 TransationFactory。如上文中看到的

com.ivo.util2.DynamicSessionFactoryImpl 和 <span style="font-family: Arial, Helvetica, sans-serif;">com.ivo.util2.DynamicTransactionManager</span>

先写一个继承sessionfactory的接口DynamicSessionFactory

package com.ivo.util2;import org.hibernate.SessionFactory;public interface DynamicSessionFactory extends SessionFactory {public SessionFactory getHibernateSessionFactory();
}

实现这个接口 
DynamicSessionFactoryImpl

package com.ivo.util2;import com.ivo.util.CustomerContextHolder;
import com.ivo.util2.DynamicSessionFactory;import java.io.Serializable;
import java.sql.Connection;
import java.util.Map;
import java.util.Set;import javax.naming.NamingException;
import javax.naming.Reference;import org.hibernate.Cache;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.SessionBuilder;
import org.hibernate.SessionFactory;
import org.hibernate.StatelessSession;
import org.hibernate.StatelessSessionBuilder;
import org.hibernate.TypeHelper;
import org.hibernate.engine.spi.FilterDefinition;
import org.hibernate.metadata.ClassMetadata;
import org.hibernate.metadata.CollectionMetadata;
import org.hibernate.stat.Statistics;public class DynamicSessionFactoryImpl implements DynamicSessionFactory {/*** */private static final long serialVersionUID = 7328134180626920452L;private Map<Object, SessionFactory> targetSessionFactorys;private SessionFactory defaultTargetSessionFactory;@Overridepublic SessionFactoryOptions getSessionFactoryOptions() {return getHibernateSessionFactory().getSessionFactoryOptions();}@Overridepublic SessionBuilder withOptions() {return getHibernateSessionFactory().withOptions();}@Overridepublic Session openSession() throws HibernateException {return getHibernateSessionFactory().openSession();}@Overridepublic Session getCurrentSession() throws HibernateException {return getHibernateSessionFactory().getCurrentSession();}@Overridepublic StatelessSessionBuilder withStatelessOptions() {return getHibernateSessionFactory().withStatelessOptions();}@Overridepublic StatelessSession openStatelessSession() {return getHibernateSessionFactory().openStatelessSession();}@Overridepublic StatelessSession openStatelessSession(Connection connection) {return getHibernateSessionFactory().openStatelessSession(connection);}@Overridepublic ClassMetadata getClassMetadata(@SuppressWarnings("rawtypes") Class entityClass) {return getHibernateSessionFactory().getClassMetadata(entityClass);}@Overridepublic ClassMetadata getClassMetadata(String entityName) {return getHibernateSessionFactory().getClassMetadata(entityName);}@Overridepublic CollectionMetadata getCollectionMetadata(String roleName) {return getHibernateSessionFactory().getCollectionMetadata(roleName);}@Overridepublic Map<String, ClassMetadata> getAllClassMetadata() {return getHibernateSessionFactory().getAllClassMetadata();}@SuppressWarnings("rawtypes")@Overridepublic Map getAllCollectionMetadata() {return getHibernateSessionFactory().getAllCollectionMetadata();}@Overridepublic Statistics getStatistics() {return getHibernateSessionFactory().getStatistics();}@Overridepublic void close() throws HibernateException {getHibernateSessionFactory().close();}@Overridepublic boolean isClosed() {return getHibernateSessionFactory().isClosed();}@Overridepublic Cache getCache() {return getHibernateSessionFactory().getCache();}@SuppressWarnings({ "deprecation", "rawtypes" })@Overridepublic void evict(Class persistentClass) throws HibernateException {getHibernateSessionFactory().evict(persistentClass);}@SuppressWarnings({ "deprecation", "rawtypes" })@Overridepublic void evict(Class persistentClass, Serializable id)throws HibernateException {getHibernateSessionFactory().evict(persistentClass, id);}@SuppressWarnings("deprecation")@Overridepublic void evictEntity(String entityName) throws HibernateException {getHibernateSessionFactory().evictEntity(entityName);}@SuppressWarnings("deprecation")@Overridepublic void evictEntity(String entityName, Serializable id)throws HibernateException {getHibernateSessionFactory().evictEntity(entityName, id);}@SuppressWarnings("deprecation")@Overridepublic void evictCollection(String roleName) throws HibernateException {getHibernateSessionFactory().evictCollection(roleName);}@SuppressWarnings("deprecation")@Overridepublic void evictCollection(String roleName, Serializable id)throws HibernateException {getHibernateSessionFactory().evictCollection(roleName, id);}@SuppressWarnings("deprecation")@Overridepublic void evictQueries(String cacheRegion) throws HibernateException {getHibernateSessionFactory().evictQueries(cacheRegion);}@SuppressWarnings("deprecation")@Overridepublic void evictQueries() throws HibernateException {getHibernateSessionFactory().evictQueries();}@SuppressWarnings("rawtypes")@Overridepublic Set getDefinedFilterNames() {return getHibernateSessionFactory().getDefinedFilterNames();}@Overridepublic FilterDefinition getFilterDefinition(String filterName)throws HibernateException {return getHibernateSessionFactory().getFilterDefinition(filterName);}@Overridepublic boolean containsFetchProfileDefinition(String name) {return getHibernateSessionFactory().containsFetchProfileDefinition(name);}@Overridepublic TypeHelper getTypeHelper() {return getHibernateSessionFactory().getTypeHelper();}@Overridepublic Reference getReference() throws NamingException {return getHibernateSessionFactory().getReference();}@Overridepublic SessionFactory getHibernateSessionFactory() {SessionFactory targetSessionFactory = targetSessionFactorys.get(CustomerContextHolder.getCustomerType());if (targetSessionFactory != null) {return targetSessionFactory;} else if (defaultTargetSessionFactory != null) {return defaultTargetSessionFactory;}return null;}public void setTargetSessionFactorys(Map<Object, SessionFactory> targetSessionFactorys) {this.targetSessionFactorys = targetSessionFactorys;}public void setDefaultTargetSessionFactory(SessionFactory defaultTargetSessionFactory) {this.defaultTargetSessionFactory = defaultTargetSessionFactory;}
}


事务管理类DynamicTransactionManager 

package com.ivo.util2;import org.springframework.orm.hibernate4.HibernateTransactionManager;
import javax.sql.DataSource;
import org.hibernate.SessionFactory;
import org.springframework.orm.hibernate4.SessionFactoryUtils;public class DynamicTransactionManager extends HibernateTransactionManager {/*** */private static final long serialVersionUID = 2591641126163504954L;@Overridepublic DataSource getDataSource() {return SessionFactoryUtils.getDataSource(getSessionFactory());}@Overridepublic SessionFactory getSessionFactory() {DynamicSessionFactory dynamicSessionFactory = (DynamicSessionFactory) super.getSessionFactory();  SessionFactory hibernateSessionFactory = dynamicSessionFactory.getHibernateSessionFactory();  return hibernateSessionFactory;  }
}


最后写一个切换当前线程内容的类 

package com.ivo.util2;public class CustomerContextHolder {public static final String SESSION_FACTORY_MYSQL = "sessionFactoryMS";  public static final String SESSION_FACTORY_SQLSERVER = "sessionFactorySS";  private static final ThreadLocal<String> contextHolder = new ThreadLocal<String>();  public static void setCustomerType(String dbType) {  contextHolder.set(dbType);  }  public static String getCustomerType() {  return contextHolder.get();  }  public static void clearCustomerType() {  contextHolder.remove();  }  
}

OK 大功告成了`(*∩_∩*)′


这篇关于spring+hibernate多数据源切换のSessionFactory切换的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！


http://www.chinasem.cn/article/1020516。

相关文章

Java设计模式---迭代器模式(Iterator)解读

Java设计模式---迭代器模式(Iterator)解读

《Java设计模式---迭代器模式(Iterator)解读》：本文主要介绍Java设计模式---迭代器模式(Iterator),具有很好的参考价值,希望对大家有所帮助,如有错误或未考虑完全的地方,... 目录1、迭代器（Iterator）1.1、结构1.2、常用方法1.3、本质1、解耦集合与遍历逻辑2、统一
阅读更多...
Java内存分配与JVM参数详解(推荐)

Java内存分配与JVM参数详解(推荐)

《Java内存分配与JVM参数详解(推荐)》本文详解JVM内存结构与参数调整,涵盖堆分代、元空间、GC选择及优化策略,帮助开发者提升性能、避免内存泄漏,本文给大家介绍Java内存分配与JVM参数详解,... 目录引言JVM内存结构JVM参数概述堆内存分配年轻代与老年代调整堆内存大小调整年轻代与老年代比例元空
阅读更多...
深度解析Java DTO(最新推荐)

深度解析Java DTO(最新推荐)

《深度解析JavaDTO(最新推荐)》DTO（DataTransferObject）是一种用于在不同层（如Controller层、Service层）之间传输数据的对象设计模式,其核心目的是封装数据,... 目录一、什么是DTO？DTO的核心特点：二、为什么需要DTO？（对比Entity）三、实际应用场景解析
阅读更多...
Java 线程安全与 volatile与单例模式问题及解决方案

Java 线程安全与 volatile与单例模式问题及解决方案

《Java线程安全与volatile与单例模式问题及解决方案》文章主要讲解线程安全问题的五个成因（调度随机、变量修改、非原子操作、内存可见性、指令重排序）及解决方案,强调使用volatile关键字... 目录什么是线程安全线程安全问题的产生与解决方案线程的调度是随机的多个线程对同一个变量进行修改线程的修改操
阅读更多...
从原理到实战深入理解Java 断言assert

从原理到实战深入理解Java 断言assert

《从原理到实战深入理解Java断言assert》本文深入解析Java断言机制,涵盖语法、工作原理、启用方式及与异常的区别,推荐用于开发阶段的条件检查与状态验证,并强调生产环境应使用参数验证工具类替代... 目录深入理解 Java 断言（assert）：从原理到实战引言：为什么需要断言？一、断言基础1.1 语
阅读更多...
深度解析Java项目中包和包之间的联系

深度解析Java项目中包和包之间的联系

《深度解析Java项目中包和包之间的联系》文章浏览阅读850次，点赞13次，收藏8次。本文详细介绍了Java分层架构中的几个关键包：DTO、Controller、Service和Mapper。_jav... 目录前言一、各大包1.DTO1.1、DTO的核心用途1.2. DTO与实体类(Entity)的区别1
阅读更多...
Java中的雪花算法Snowflake解析与实践技巧

Java中的雪花算法Snowflake解析与实践技巧

《Java中的雪花算法Snowflake解析与实践技巧》本文解析了雪花算法的原理、Java实现及生产实践,涵盖ID结构、位运算技巧、时钟回拨处理、WorkerId分配等关键点,并探讨了百度UidGen... 目录一、雪花算法核心原理1.1 算法起源1.2 ID结构详解1.3 核心特性二、Java实现解析2.
阅读更多...
SpringBoot整合liteflow的详细过程

SpringBoot整合liteflow的详细过程

《SpringBoot整合liteflow的详细过程》：本文主要介绍SpringBoot整合liteflow的详细过程,本文给大家介绍的非常详细,对大家的学习或工作具有一定的参考借鉴价值,需要的朋...  liteflow 是什么？ 能做什么？总之一句话：能帮你规范写代码逻辑 ，编排并解耦业务逻辑，代码
阅读更多...
JavaSE正则表达式用法总结大全

JavaSE正则表达式用法总结大全

《JavaSE正则表达式用法总结大全》正则表达式就是由一些特定的字符组成,代表的是一个规则,：本文主要介绍JavaSE正则表达式用法的相关资料,文中通过代码介绍的非常详细,需要的朋友可以参考下... 目录常用的正则表达式匹配符正则表China编程达式常用的类Pattern类Matcher类PatternSynta
阅读更多...
Spring Security中用户名和密码的验证完整流程

Spring Security中用户名和密码的验证完整流程

《SpringSecurity中用户名和密码的验证完整流程》本文给大家介绍SpringSecurity中用户名和密码的验证完整流程,本文结合实例代码给大家介绍的非常详细,对大家的学习或工作具有一定... 首先创建了一个UsernamePasswordAuthenticationTChina编程oken对象，这是S
阅读更多...

Copyright China编程 23002807@qq.com

沪ICP备2023033072号-2