c3p0 数据库连接池配置

最新推荐文章于 2023-10-05 21:03:03 发布

果果软件

最新推荐文章于 2023-10-05 21:03:03 发布

阅读量398

点赞数

分类专栏： hibarnate 文章标签：数据库连接池 c3p0 bean hibernate spring class

本文链接：https://blog.csdn.net/jk6801251/article/details/2218802

版权

hibarnate 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

Spring Hibernate c3p0 数据库连接池配置

       <bean id="DataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
            destroy-method="close">
            <property name="driverClass" value="oracle.jdbc.driver.OracleDriver"></property>
            <property name="jdbcUrl" value="jdbc:oracle:thin:@192.168.1.3:1521:HZORA6"></property>
            <property name="user" value="hz1001"></property>
            <property name="password" value="123"></property>

            <property name="maxPoolSize" value="40"></property>
            <property name="minPoolSize" value="1"></property>
            <property name="initialPoolSize" value="1"></property>
            <property name="maxIdleTime" value="20"></property>
        </bean>

        以下的<SessionFactory>配置，只需要引用<DataSource>bean就可以了

            <bean id="SessionFactory"
                class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
                <property name="dataSource">
                    <ref bean="DataSource" />
                </property>
                <property name="hibernateProperties">
                    <props>
                        <prop key="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</prop>
                        <prop key="hibernate.show_sql">true</prop>
                    </props>
                </property>
                <property name="mappingResources">
                    <list>
                        <value>com/hz/start/pojo/hbm/Sysuser.hbm.xml</value>
                    </list>
                </property>
            </bean>