利用c3p0配置数据库连接

来源：互联网发布：交换机丢包率测试软件编辑：程序博客网时间：2024/06/05 11:44

利用c3p0配置数据库连接
一.连接mysql数据库

<bean id="dataSource"
        class="com.mchange.v2.c3p0.ComboPooledDataSource"
        destroy-method="close" abstract="false" singleton="true"
        lazy-init="default" autowire="default" dependency-check="default">
        <property name="driverClass">
            <value>com.mysql.jdbc.Driver</value>
        </property>
        <property name="jdbcUrl">
            <value>jdbc:mysql://192.168.0.1/databasename?useUnicode=true&characterEncoding=utf-8&autoReconnect=true</value>
        </property>
        <property name="user">
            <value>username</value>
        </property>
        <property name="password">
            <value>password</value>
        </property>
        <property name="minPoolSize">
            <value>10</value>
        </property>
        <property name="maxPoolSize">
            <value>20</value>
        </property>
        <property name="initialPoolSize">
            <value>10</value>
        </property>
    </bean>
    <bean id="sessionFactory"
        class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
        <property name="dataSource">
            <ref bean="dataSource"></ref>
        </property>
        <property name="hibernateProperties">
            <props>
                <prop key="hibernate.dialect">
                    org.hibernate.dialect.MySQLDialect
                </prop>
                <prop key="hibernate.show_sql">
                    false
                </prop>
                <prop key="hibernate.generate_statistics">true</prop>
                <prop key="hibernate.cache.use_query_cache">
                    true
                </prop>
                <prop key="hibernate.cache.use_second_level_cache">
                    true
                </prop>
                <prop key="hibernate.cache.provider_class">
                    net.sf.ehcache.hibernate.EhCacheProvider
                </prop>
                <prop key="hibernate.connection.provider_class">
                    org.hibernate.connection.C3P0ConnectionProvider
                </prop>
                <prop key="hibernate.query.substitutions">
                    true 1, false 0, yes 'Y', no 'N'
                </prop>
                <prop
                    key="hibernate.bytecode.use_reflection_optimizer">
                    true
                </prop>
                <prop key="hibernate.use_outer_join">true</prop>
                <prop key="hibernate.prepare_sql">true</prop>
                <prop key="hibernate.query.factory_class">
                    org.hibernate.hql.ast.ASTQueryTranslatorFactory
                </prop>
            </props>
        </property>

二.连接Oracle数据库

    <bean id="sessionFactory"
        class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
        <property name="dataSource">
            <ref bean="dataSource"></ref>
        </property>
        <property name="hibernateProperties">
            <props>
                <prop key="hibernate.dialect">
                    org.hibernate.dialect.OracleDialect
                </prop>
                <prop key="hibernate.show_sql">
                    false
                </prop>
                <prop key="hibernate.generate_statistics">true</prop>
                <prop key="hibernate.cache.use_query_cache">
                    true
                </prop>
                <prop key="hibernate.cache.use_second_level_cache">
                    true
                </prop>
                <prop key="hibernate.cache.provider_class">
                    net.sf.ehcache.hibernate.EhCacheProvider
                </prop>
                <prop key="hibernate.connection.provider_class">
                    org.hibernate.connection.C3P0ConnectionProvider
                </prop>
                <prop key="hibernate.query.substitutions">
                    true 1, false 0, yes 'Y', no 'N'
                </prop>
                <prop
                    key="hibernate.bytecode.use_reflection_optimizer">
                    true
                </prop>
                <prop key="hibernate.use_outer_join">true</prop>
                <prop key="hibernate.prepare_sql">true</prop>
                <prop key="hibernate.query.factory_class">
                    org.hibernate.hql.ast.ASTQueryTranslatorFactory
                </prop>
            </props>
        </property>

本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/hbcui1984/archive/2006/11/19/1395961.aspx