11、Spring-hibernate.xml

来源：互联网发布：sql 查询结果赋值变量编辑：程序博客网时间：2024/04/29 21:49

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:jdbc="http://www.springframework.org/schema/jdbc"
xmlns:jee="http://www.springframework.org/schema/jee" xmlns:tx="http://www.springframework.org/schema/tx"
xmlns:jpa="http://www.springframework.org/schema/data/jpa" xmlns:p="http://www.springframework.org/schema/p"
xsi:schemaLocation="
  http://www.springframework.org/schema/beanshttp://www.springframework.org/schema/beans/spring-beans-4.0.xsd
  http://www.springframework.org/schema/contexthttp://www.springframework.org/schema/context/spring-context-4.0.xsd
  http://www.springframework.org/schema/jdbchttp://www.springframework.org/schema/jdbc/spring-jdbc-4.0.xsd
  http://www.springframework.org/schema/jeehttp://www.springframework.org/schema/jee/spring-jee-4.0.xsd
  http://www.springframework.org/schema/txhttp://www.springframework.org/schema/tx/spring-tx-4.0.xsd
  http://www.springframework.org/schema/aophttp://www.springframework.org/schema/aop/spring-aop-4.0.xsd
  http://www.springframework.org/schema/data/jpahttp://www.springframework.org/schema/data/jpa/spring-jpa-1.3.xsd"
default-lazy-init="false">

<description>Spring DAO </description>

<bean id="defaultDataSource" class="com.jolbox.bonecp.BoneCPDataSource" destroy-method="close">
     <property name="driverClass" value="${bonecp0.driverClassName}" />
     <property name="jdbcUrl" value="${bonecp0.url}" />
     <property name="username" value="${bonecp0.username}"/>
     <property name="password" value="${bonecp0.password}"/>
     <property name="IdleConnectionTestPeriodInMinutes" value="${bonecp0.idleConnectionTestPeriod}"/>
     <property name="IdleMaxAgeInMinutes" value="${bonecp0.idleMaxAge}"/>
     <property name="maxConnectionsPerPartition" value="${bonecp0.maxConnectionsPerPartition}"/>
     <property name="minConnectionsPerPartition" value="${bonecp0.minConnectionsPerPartition}"/>
     <property name="partitionCount" value="${bonecp0.partitionCount}"/>
     <property name="acquireIncrement" value="${bonecp0.acquireIncrement}"/>
  <property name="poolAvailabilityThreshold" value="${bonecp0.poolAvailabilityThreshold}"></property>
  <property name="ConnectionTimeoutInMs" value="${bonecp0.connectionTimeout}"></property>
</bean>

<bean id="dynamicDataSource" class="com.demo.core.dao.datasource.DynamicDataSource">
  <property name="defaultTargetDataSource" ref="defaultDataSource"></property>
  <property name="targetDataSources">
   <map key-type="java.lang.String" value-type="javax.sql.DataSource">
    <entry key="defaultDataSource" value-ref="defaultDataSource"></entry>
    
   </map>
  </property>
</bean>

<bean id="jdbcAvicit" class="com.demo.core.jdbc.JdbcAvicit">
  <property name="jdbcTemplate" ref="jdbcTemplate"/>
</bean>
<bean id="dialectInitializer" class="com.demo.core.jdbc.DialectInitializer"/>
<bean id="nativeJdbcExtractor" class="org.springframework.jdbc.support.nativejdbc.SimpleNativeJdbcExtractor" />
<bean id="oracleLobHandler" class="org.springframework.jdbc.support.lob.OracleLobHandler">
  <property name="nativeJdbcExtractor" ref="nativeJdbcExtractor" />
</bean>
<bean id="sessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
  <property name="dataSource" ref="defaultDataSource"></property>
  
  <property name="hibernateProperties">
   <props>
    <prop key="hibernate.show_sql">false</prop>
    <prop key="hibernate.format_sql">true</prop>
    <prop key="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</prop>

<prop key="hibernate.order_updates">true</prop>
    <prop key="hibernate.generate_statistics">true</prop>
    <prop key="hibernate.use_sql_comments">false</prop>
    <prop key="hibernate.jdbc.batch_versioned_data">true</prop>
    <prop key="hibernate.jdbc.batch_size">15</prop>
    <prop key="hibernate.connection.release_mode">after_statement</prop>
   </props>
  </property>
  <property name="lobHandler" ref="oracleLobHandler" />
  <property name="mappingLocations">
   <list>
    <value>classpath*:/com/demo/bpm/cfg/hbm/*.hbm.xml</value>
    <value>classpath*:/com/**/bo/*.hbm.xml</value>
    <value>classpath*:/com/**/domain/*.hbm.xml</value>
    <value>classpath*:/com/**/bo/*.hbm.xml</value>
   </list>
  </property>
  <property name="packagesToScan">
   <list>
    <value>demo/**/domain</value>
   </list>
  </property>
</bean>
<bean id="hibernateTemplate" class="org.springframework.orm.hibernate3.HibernateTemplate">
  <property name="sessionFactory" ref ="sessionFactory"></property>
</bean> 

<bean id="commonHibernateDao2" class="com.demo.core.dao.hibernate.CommonHibernateDao2" scope="singleton">
  <property name="hibernateTemplate" ref="hibernateTemplate"></property>
</bean>
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
  <property name="dataSource" ref="dynamicDataSource"/>
</bean>

</beans>

0 0