spring数据源

<bean id="paymentService" class="rmi.PaymentServiceImpl">
     </bean>
    <bean class="org.springframework.remoting.rmi.RmiServiceExporter">
    <property name="service">
        <ref bean="paymentService"/>
    </property>
    <property name="serviceName">
        <value>PayService</value>
    </property>
    <property name="serviceInterface">
        <value>com.springinaction.payment.PaymentService</value>
    </property>
  </bean>
   
 -->

    <!-- SPRING JNDI -->
    <!-- 
    <bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean" singleton="true">
        <property name="jndiName">
          <value>java:comp/env/jdbc/myDatasource</value>   
        </property>
    </bean>
    -->

    <!-- spring hibernate session factory -->
    <!--
    <bean id="sessionFactory"
        class="org.springframework.orm.hibernate.LocalSessionFactoryBean">
        <property name="dataSource">
            <ref local="dataSource"/>
        </property>
        <property name="mappingResources">
            <list>
                <value>org/appfuse/model/User.hbm.xml</value>
            </list>
        </property>
        <property name="hibernateProperties">
            <props>
                <prop key="hibernate.dialect"> net.sf.hibernate.dialect.HSQLDialect </prop>
                <prop key="hibernate.hbm2ddl.auto">create</prop>
            </props>
        </property>
    </bean>
    -->
   
    <!-- Transaction manager for a single Hibernate SessionFactory (alternative to JTA) -->
    <!-- 想使用jta transaction manager ，将此bean的class属性改成 org.springframework.transaction.jta.JtaTransactionManager -->
   
    <!--
    <bean id="transactionManager"
        class="org.springframework.orm.hibernate.HibernateTransactionManager">
        <property name="sessionFactory">
            <ref local="sessionFactory"/>
        </property>
    </bean>
    -->
     
    <!-- spring connection sql -->
   
    <!--
    <bean id="dataSource2"
        class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName">
        <value>com.microsoft.sqlserver.jdbc.SQLServerDriver</value>
        </property>
        <property name="url">
        <value>jdbc:sqlserver://192.168.0.26:1433</value>
        </property>
        <property name="username">
        <value>sa</value>
        </property>
        <property name="password">
        <value>123456</value>
        </property>
    </bean>
    -->

 

 

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
    <bean id="mySessionFactory"
        class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
        <property name="dataSource">
            <ref local="dataSource" />
        </property>
        <property name="hibernateProperties">
            <props>
                  
                  <prop key="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</prop>
                  <prop key="hibernate.dialect">org.hibernate.dialect.OracleDialect</prop>                  
                  <prop key="hibernate.cache.provider_class">org.hibernate.cache.EhCacheProvider</prop>
                  <prop key="hibernate.jdbc.fetch_size">50</prop>
                  <prop key="hibernate.query.factory_class">org.hibernate.hql.classic.ClassicQueryTranslatorFactory</prop>
                 
                  <!--启用cglib反射优化   指定默认的数据库 设定对数据库进行批量删除，批量更新和批量插入的时候的批次大小，有点相当于设置Buffer缓冲区大小
                  <prop key="hibernate.jdbc.batch_size">50</prop>
                  <prop key="hibernate.cglib.use_reflection_optimizer">true</prop>
                  <prop key="hibernate.default_schema">${hibernate.default_schema}</prop>
                  -->
                  <prop key="hibernate.show_sql">true</prop>
             </props>
        </property>
        <!--
        <property name="configLocation"
            value="classpath:hibernate.cfg.xml">
        </property>
        -->
        <property name="mappingResources">
          <list>          
            <value>/WEB-INF/table-mapping/FixMasterFunction.hbm.xml</value>
            <value>/WEB-INF/table-mapping/FixSecurityPrivilege.hbm.xml</value>
        
          </list>
        </property>
    </bean>
     
    <bean id="myTransactionManager"
        class="org.springframework.orm.hibernate3.HibernateTransactionManager">
        <property name="sessionFactory">
            <ref local="mySessionFactory" />
        </property>
    </bean>

     <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">  
        <property name="driverClass" value="oracle.jdbc.driver.OracleDriver"/>  
        <property name="jdbcUrl" value="jdbc:oracle:thin:@192.168.0.84:1501:test"/>  
        <property name="user" value="fix"/>  
        <property name="password" value="fix"/>  
        <property name="maxPoolSize" value="20"/>  
        <property name="minPoolSize" value="5"/>  
        <property name="initialPoolSize" value="10"/>  
        <property name="maxIdleTime" value="20"/>
        <property name="autoCommitOnClose" value="true"/>
        <property name="checkoutTimeout" value="5000"/>
        <!--当连接池中的连接耗尽的时候c3p0一次同时获取的连接数。Default: 3 -->
        <property name="acquireIncrement" value="5"/>
        <property name="maxStatementsPerConnection" value="1800"/>
                              
    </bean>


   <bean id="jdbcTransactionManager"
         class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
         <property name="dataSource">
             <ref bean="dataSource"/>
         </property>
    </bean>

    <bean id="baseTxProxy" lazy-init="true" abstract="true"
        class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
        <property name="transactionManager">
            <ref bean="myTransactionManager" />
        </property>
       
        <property name="transactionAttributes">
            <props>
                <prop key="find*">PROPAGATION_REQUIRED,readOnly</prop>
                <prop key="get*">PROPAGATION_REQUIRED,readOnly</prop>
                <prop key="save*">PROPAGATION_REQUIRED</prop>
                <prop key="*">PROPAGATION_REQUIRED</prop>
            </props>
        </property>
    </bean>

    <bean id="baseJdbcTxProxy" lazy-init="true" abstract="true"
        class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
        <property name="transactionManager">
            <ref bean="jdbcTransactionManager" />
        </property>
        <property name="transactionAttributes">
            <props>
                <prop key="find*">PROPAGATION_REQUIRED,readOnly</prop>
                <prop key="get*">PROPAGATION_REQUIRED,readOnly</prop>
                <prop key="*">PROPAGATION_REQUIRED</prop>
            </props>
        </property>
    </bean>
 
           

    <bean id="phaseDAO" class="com.yict.fix.dao.system.PhaseDAOImpl">
      <property name="sessionFactory">
        <ref bean="mySessionFactory"/>
        </property>
    </bean> 

      <bean id="phaseProxy" parent="baseTxProxy">
        <property name="target">
            <ref local="phaseDAO" />
        </property>
    </bean>

 


 
    
     <bean id="yardWithoutEquMonitorDAOImpl" class="com.yict.fix.dao.am.YardWithoutEquMonitorDAOImpl">
         <constructor-arg><ref local="yardWithoutEquMonitor"></ref></constructor-arg>
         <property name="dataSource">
            <ref bean="dataSource"/>
        </property>      
     </bean>
    
  

</beans>