同一个web项目，hibernate的mysql和sqlservice的两个不同数据库配置

拼搏现实的明天。 2024-02-18 14:02 4阅读 0赞

**1.jdbc.properties**

这里写代码片

#mysql
    jdbc.driverClassName=com.mysql.jdbc.Driver
    jdbc.url=jdbc\:mysql\://localhost\:3306/irkb?useUnicode\=true&characterEncoding\=utf-8
    jdbc.username=root
    jdbc.password=root
    #mysql
    user.jdbc.driverClassName=com.mysql.jdbc.Driver
    user.jdbc.url=jdbc\:mysql\://localhost\:3306/wcp?useUnicode\=true&characterEncoding\=utf-8
    user.jdbc.username=root
    user.jdbc.password=root
    
    #sqlservice
    sa.jdbc.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
    sa.jdbc.url=jdbc:sqlserver://192.168.0.168:1433;DatabaseName=callcenterdb
    sa.jdbc.username=sa
    sa.jdbc.password=hrgk_sa

**2.spring-hibernate.xml**

<?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="sessionFactorySa"
            class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
            <property name="dataSource" ref="dataSourceSa" />
            <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="dataSourceSa" class="com.mchange.v2.c3p0.ComboPooledDataSource">
            <property name="driverClass" value="${sa.jdbc.driverClassName}" />
            <property name="jdbcUrl" value="${sa.jdbc.url}" />
            <property name="user" value="${sa.jdbc.username}" />
            <property name="password" value="${sa.jdbc.password}" />
    
        </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="transactionManagerSa"
            class="org.springframework.orm.hibernate4.HibernateTransactionManager">
            <property name="sessionFactory" ref="sessionFactorySa" />
        </bean>
    
        
        <bean id="persistenceExceptionTranslationPostProcessor"
            class="org.springframework.dao.annotation.PersistenceExceptionTranslationPostProcessor" />
        
        <import resource="classpath:config/initTask.xml"></import>
    
    </beans>

3.sqlservice的配置修改过后，需要下载一个jsr包， sqljdbc4.jar是sqlservice的驱动，在maven的中央仓库[https://search.maven.org][https_search.maven.org]去下载依赖  
4. 看是否本地仓库 是否加载过来此jar包![这里写图片描述][SouthEast]

[https_search.maven.org]: https://search.maven.org
[SouthEast]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/29/9b6301916966491988aa46450727cdcb.png