Spring集成Hibernate多种数据源配置

 

方案1.---------------------------------------------------------------------------------------
<!-- (数据源配置1:DBCP数据源)-->
<bean id="dataSource"
   class="org.apache.commons.dbcp.BasicDataSource">
   <property name="driverClassName">
    <value>com.microsoft.sqlserver.jdbc.SQLServerDriver</value>
   </property>
   <property name="url">
    <value>
     jdbc:sqlserver://localhost:1433;DatabaseName=HR_DB;SelectMethod=cursor
    </value>
   </property>
   <property name="username">
    <value>sa</value>
   </property>
   <property name="password">
    <value>123</value>
   </property>
</bean>
方案2.---------------------------------------------------------------------------------------
<!-- (数据源配置2:C3P0数据源)-->
<bean id="dataSource"
   class="com.mchange.v2.c3p0.ComboPooledDataSource"
   destroy-method="close" dependency-check="none">
   <property name="driverClass">
    <value>net.sourceforge.jtds.jdbc.Driver</value>
   </property>
   <property name="jdbcUrl">
    <value>jdbc:jtds:sqlserver://localhost:1433/HR_DB</value>
   </property>
   <property name="user">
    <value>sa</value>
   </property>
   <property name="password">
    <value>123</value>
   </property>
   <property name="acquireIncrement">
    <value>3</value>
   </property>
   <property name="initialPoolSize">
    <value>3</value>
   </property>
   <property name="minPoolSize">
    <value>2</value>
   </property>
   <property name="maxPoolSize">
    <value>50</value>
   </property>
   <property name="maxIdleTime">
    <value>600</value>
   </property>
   <property name="idleConnectionTestPeriod">
    <value>900</value>
   </property>
   <property name="maxStatements">
    <value>100</value>
   </property>
   <property name="numHelperThreads">
    <value>10</value>
   </property>
</bean>
方案3.---------------------------------------------------------------------------------------
<!-- (数据源配置3:读配置文件的方式引用属性)-->
<bean id="propertyConfigurer"
   class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
   <property name="location" value="/WEB-INF/jdbc.properties" />
</bean>
<bean id="dataSource"
   class="com.mchange.v2.c3p0.ComboPooledDataSource"
   destroy-method="close" dependency-check="none">
   <property name="driverClass">
    <value>${jdbc.driverClassName}</value>
   </property>
   <property name="jdbcUrl">
    <value>${jdbc.url}</value>
   </property>
   <property name="user">
    <value>${jdbc.username}</value>
   </property>
   <property name="password">
    <value>${jdbc.password}</value>
   </property>
   <property name="acquireIncrement">
    <value>3</value>
   </property>
   <property name="initialPoolSize">
    <value>3</value>
   </property>
   <property name="minPoolSize">
    <value>2</value>
   </property>
   <property name="maxPoolSize">
    <value>50</value>
   </property>
   <property name="maxIdleTime">
    <value>600</value>
   </property>
   <property name="idleConnectionTestPeriod">
    <value>900</value>
   </property>
   <property name="maxStatements">
    <value>100</value>
   </property>
   <property name="numHelperThreads">
    <value>10</value>
   </property>
</bean>
jdbc.properties----------------------
jdbc.driverClassName=net.sourceforge.jtds.jdbc.Driver
jdbc.url=jdbc:jtds:sqlserver://localhost:1433/HR_DB
jdbc.username=sa
jdbc.password=123
方案4.---------------------------------------------------------------------------------------
<!-- (数据源配置4:获取JNDI数据源-->
<bean id="dataSource"
   class="org.springframework.jndi.JndiObjectFactoryBean">
   <property name="jndiName" value="java:comp/env/jdbc/hr" />
</bean>
web服务器中server.xml文件中数据源配置
    <Resource name="jdbc/hr" auth="Container" type="javax.sql.DataSource"
        maxActive="100" maxIdle="30" maxWait="10000"
        username="sa" password="123" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
        url="jdbc:sqlserver://localhost:1433; DatabaseName=HR_DB"/>
方案5.---------------------------------------------------------------------------------------
<!-- (数据源配置5:Spring 2.0版本jee命名空间-->
<jee:jndi-lookup id="dataSource" jndi-name="java:comp/env/jdbc/hr"/>
spring配置文件中命名空间的引入
<beans xmlns="http://www.springframework.org/schema/beans"
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
   xmlns:jee="http://www.springframework.org/schema/jee"
   xsi:schemaLocation="http://www.springframework.org/schema/beans     
  http://www.springframework.org/schema/beans/spring-beans-2.0.xsd     
  http://www.springframework.org/schema/jee   
  http://www.springframework.org/schema/jee/spring-jee-2.0.xsd">
</beans>