spring集成hibernate3的xml配置-优快云博客

本文介绍了Spring框架中两种不同的数据库配置示例：一种是通过JNDI获取数据源并配置Hibernate，另一种则是直接使用C3P0连接池进行Oracle数据库的数据源配置，并详细展示了SessionFactory与事务管理器的具体设置。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" 
"http://www.springframework.org/dtd/spring-beans.dtd">

<beans default-autowire="byName">

<!-- 数据源采用jndi方式 -->
<bean id="espDataSource"
   class="org.springframework.jndi.JndiObjectFactoryBean">
   <property name="jndiName">
    <value>jdbc/bidbodbc</value>
   </property>
</bean>

<bean id="sessionFactory"
   class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
   <property name="dataSource" ref="espDataSource" />
   <!-- 没有引用hibernate.cfg.xml -->
   <property name="mappingResources">
    <list/>
   </property>
   <property name="hibernateProperties">
    <!-- db2的dialect -->
    <value>hibernate.dialect=org.hibernate.dialect.DB2Dialect</value>
   </property>
</bean>

<!-- hibernate transaction manager -->
<bean id="transactionManager"
   class="org.springframework.orm.hibernate3.HibernateTransactionManager">
   <property name="sessionFactory">
    <ref bean="sessionFactory" />
   </property>
</bean>

<bean id="transactionInterceptor"
   class="org.springframework.transaction.interceptor.TransactionInterceptor">
   <property name="transactionManager" ref="transactionManager" />
   <property name="transactionAttributes">
    <props>
     <!-- 对所有方法事务处理 -->
     <prop key="*">PROPAGATION_REQUIRED,-Exception</prop>
    </props>
   </property>
</bean>

<!-- 只对以Dao结尾的bean作事务处理 -->
<bean
   class="org.springframework.aop.framework.autoproxy.BeanNameAutoProxyCreator">
   <property name="proxyTargetClass" >
       <value>true</value>
    </property>
   <property name="beanNames">
    <value>*Dao</value>
   </property>
   <property name="interceptorNames">
    <list>
     <value>transactionInterceptor</value>
    </list>
   </property>
</bean>

</beans>

另外一个配置

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN"
 "http://www.springframework.org/dtd/spring-beans.dtd">

 <bean id="propertyConfigurer"
 class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
 <property name="location" value="/WEB-INF/jdbc.properties" />
 </bean>

<bean id="oracleDataSource" 
  class="com.mchange.v2.c3p0.ComboPooledDataSource"
  destroy-method="close">
  <property name="driverClass">
   <value>${Oraclejdbc.driverClassName}</value>
  </property>
  <property name="jdbcUrl">
   <value>${Oraclejdbc.url}</value>
  </property>
  <property name="user">
   <value>${Oraclejdbc.username}</value>
  </property>
  <property name="password">
   <value>${Oraclejdbc.password}</value>
  </property>
  <property name="minPoolSize">
   <value>1</value>
  </property>

 <--  达到最大连接数后可以增加的连接数  个 -->
  <property name="acquireIncrement">
   <value>2</value>
  </property>
  <property name="maxPoolSize">
   <value>3</value>
  </property>
  <--  最大闲置时间  秒 -->
  <property name="maxIdleTime">
   <value>600</value>
  </property>

  <property name="maxStatements">
   <value>100</value>
  </property>

 <--  闲置的连接测试周期 秒  -->
  <property name="idleConnectionTestPeriod">
   <value>1200</value>
  </property>
   </bean>

<bean id="oracleSessionFactory"
  class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
  <property name="mappingResources">
   <list>
      <value>
     com/ce/myceaas/hibernate/mis/pojo/Area.hbm.xml
    </value>
    <value>
     com/ce/myceaas/hibernate/mis/pojo/Dept.hbm.xml
    </value>
    <value>
     com/ce/myceaas/hibernate/mis/pojo/Users.hbm.xml
    </value>
    <value>
     com/ce/myceaas/hibernate/mis/pojo/Employeeinfo.hbm.xml
    </value>
    <value>
     com/ce/myceaas/hibernate/mis/pojo/AreaDept.hbm.xml
    </value>
    <value>
     com/ce/myceaas/hibernate/mis/pojo/Roles.hbm.xml
    </value>


      <value>
     com/ce/myceaas/hibernate/myce/pojo/Application.hbm.xml
    </value>
    <value>
     com/ce/myceaas/hibernate/myce/pojo/Role.hbm.xml
    </value>
    <value>
     com/ce/myceaas/hibernate/myce/pojo/User.hbm.xml
    </value>
    <value>
     com/ce/myceaas/hibernate/myce/pojo/Userrole.hbm.xml
    </value>
    <value>
     com/ce/myceaas/hibernate/myce/pojo/Roleprim.hbm.xml
    </value>
   </list>
  </property>
  <property name="hibernateProperties">
   <props>

    <prop key="hibernate.generate_statistics">
     ${hibernate.generate_statistics}
    </prop>
    <prop key="hibernate.dialect">
     ${Oraclehibernate.dialect}
    </prop>
    <prop key="hibernate.show_sql">
     ${hibernate.show_sql}
    </prop>

    </props>
  </property>

   <property name="dataSource">
   <ref local="oracleDataSource" />
   </property>

 </bean>

 <bean id="oracleTransactionManager"
  class="org.springframework.orm.hibernate3.HibernateTransactionManager">
  <property name="sessionFactory" ref="oracleSessionFactory" />
 </bean>

</beans>