hibernate的双数据源的配置

柔光的暖阳◎ 2024-02-18 00:40 48阅读 0赞

<?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans"
        xmlns:context="http://www.springframework.org/schema/context"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:tx="http://www.springframework.org/schema/tx"
        xmlns:aop="http://www.springframework.org/schema/aop"
        xsi:schemaLocation="
            http://www.springframework.org/schema/beans     
            http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
            http://www.springframework.org/schema/context
            http://www.springframework.org/schema/context/spring-context-4.0.xsd
            http://www.springframework.org/schema/aop
            http://www.springframework.org/schema/aop/spring-aop-4.0.xsd
            http://www.springframework.org/schema/tx
            http://www.springframework.org/schema/tx/spring-tx-4.0.xsd
            ">
    
        
        
        <context:property-placeholder location="classpath:jdbc.properties"
            ignore-unresolvable="true" />
        <context:property-placeholder location="classpath:orm.properties"
            ignore-unresolvable="true" />
    
    
    
    
        <bean id="sessionFactory"
            class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
            <property name="dataSource" ref="dataSource" />
            <property name="packagesToScan">
                <list>
                    
                    <value>com.farm</value>
                    <value>com.wcp</value>
                    <value>com.manor</value>
                    <value>org.sdkj</value>
                </list>
            </property>
            <property name="hibernateProperties">
                <props>
                    <prop key="hibernate.hbm2ddl.auto">${hibernate.hbm2ddl.auto}</prop>
                    <prop key="hibernate.dialect">${hibernate.dialect}</prop>
                    <prop key="hibernate.show_sql">${hibernate.show_sql}</prop>
                    
                </props>
            </property>
        </bean>
        
        <bean id="sessionFactoryUser"
            class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
            <property name="dataSource" ref="dataSourceUser" />
            <property name="packagesToScan">
                <list>
                    
                    <value>com.farm</value>
                    <value>com.wcp</value>
                    <value>com.manor</value>
                    <value>org.sdkj</value>
                </list>
            </property>
            <property name="hibernateProperties">
                <props>
                    <prop key="hibernate.hbm2ddl.auto">${hibernate.hbm2ddl.auto}</prop>
                    <prop key="hibernate.dialect">${hibernate.dialect}</prop>
                    <prop key="hibernate.show_sql">${hibernate.show_sql}</prop>
                    
                </props>
            </property>
        </bean>
    
    
    
        <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
            <property name="driverClass" value="${jdbc.driverClassName}" />
            <property name="jdbcUrl" value="${jdbc.url}" />
            <property name="user" value="${jdbc.username}" />
            <property name="password" value="${jdbc.password}" />
            <property name="maxIdleTime" value="1800" /> 
        </bean>
        
        <bean id="dataSourceUser" class="com.mchange.v2.c3p0.ComboPooledDataSource">
            <property name="driverClass" value="${user.jdbc.driverClassName}" />
            <property name="jdbcUrl" value="${user.jdbc.url}" />
            <property name="user" value="${user.jdbc.username}" />
            <property name="password" value="${user.jdbc.password}" />
            <property name="maxIdleTime" value="1800" /> 
        </bean>
    
        
        <bean id="transactionManager"
            class="org.springframework.orm.hibernate4.HibernateTransactionManager">
            <property name="sessionFactory" ref="sessionFactory" />
        </bean>
        
        <bean id="transactionManagerUser"
            class="org.springframework.orm.hibernate4.HibernateTransactionManager">
            <property name="sessionFactory" ref="sessionFactoryUser" />
        </bean>
    
        
        <bean id="persistenceExceptionTranslationPostProcessor"
            class="org.springframework.dao.annotation.PersistenceExceptionTranslationPostProcessor" />
        
        <import resource="classpath:config/initTask.xml"></import>
    
    </beans>