spring+hibernate的c0p3连接池配置

最新推荐文章于 2020-04-04 20:09:17 发布

原创最新推荐文章于 2020-04-04 20:09:17 发布 · 2.8k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#hibernate #spring #c #properties #c3p0 #class

java 专栏收录该内容

45 篇文章

订阅专栏

本文介绍了一个使用Spring框架配置Hibernate的数据源及会话工厂的过程。包括PropertyPlaceholderConfigurer配置、c3p0连接池参数设置、OracleLobHandler处理大对象等细节。

摘要生成于 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>
           

          <bean id="placeholderConfig" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
            <property name="location">
                      <value>classpath:init.properties</value>

            </property>
          </bean>
          <bean id="nativeJdbcExtractor" class="org.springframework.jdbc.support.nativejdbc.SimpleNativeJdbcExtractor"/>

           <bean id="oracleLobHandle" class="org.springframework.jdbc.support.lob.OracleLobHandler" lazy-init="true">
                        <property name="nativeJdbcExtractor">
                                     <ref local="nativeJdbcExtractor"/>
                        </property>
           </bean>
              <bean id="dataSource"  class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">

                <property name="driverClass">
                        <value>${datasource.driverClassName}</value>
                </property>
                <property name="jdbcUrl">
                        <value>${datasource.url}</value>
                </property>

                <property name="properties">
                        <props>
                                <prop key="c3p0.minPoolSize">${hibernate.c3p0.minPoolSize}</prop>
                                <prop key="hc3p0.maxPoolSize">${hibernate.c3p0.maxPoolSize}</prop>
                                <prop key="hc3p0.timeout">${hibernate.c3p0.timeout}</prop>
                                <prop key="c3p0.max_statement">${hibernate.c3p0.max_statement}</prop>
                                <prop key="c3p0.testConnectionOnCheckout">true</prop>
                                <prop key="user">${datasource.username}</prop>
                <prop key="password">${datasource.password}</prop>

                        </props>
                </property>
        </bean>

        
        <bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
                <property name="dataSource">
                        <ref local="dataSource"/>
                </property>
                <property name="lobHandler"><ref local="oracleLobHandle"/></property>
                <property name="mappingResources">

                    <list>
                            <value>com/cs2c/oa2/pojo/Testfile.hbm.xml</value>
                    </list>
                </property>

                <property name="hibernateProperties">
                      <props>
                            <prop key="hibernate.cglib.use_reflection_optimizer">${hibernate.cglib.use_reflection_optimizer}</prop>
                            <prop key="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</prop>
                            <prop key="hibernate.dialect">${hibernate.dialect}</prop>
                            <prop key="hibernate.default_schema">${hibernate.default_schema}</prop>
                            <prop key="hibernate.show_sql">${hibernate.show_sql}</prop>
                       </props>
                </property>
        </bean>



        <bean id="test" class="com.cs2c.oa2.test.TestHibernate">
        <property name="sessionFactory">
                        <ref bean="sessionFactory"/>
        </property>
    </bean>

   </beans>

在配置的时候 cp30的属性的名字必须是 ''driverClass' , 'jdbcUrl', 'user' , 'password' 而 <property name="properties">的名字也必须是“properties”，另外cp30配置文件的属性名也都是诸如："c3p0.minPoolSize"、"hc3p0.maxPoolSize"等等，