spring+hibernate的c3p0 连接池配置

baizheng

<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"> 

        <property name="hibernateProperties">
            <props>
                <prop key="hibernate.connection.driver_class">org.hsqldb.jdbcDriver</prop> 
                             <prop key="hibernate.connection.url">jdbc:hsqldb:hsql://localhost/gpcswebdb</prop>
                <prop key="hibernate.connection.username">sa</prop>
                <prop key="hibernate.connection.password"></prop>
                <prop key="hibernate.c3p0.min_size">5</prop>
                <prop key="hibernate.c3p0.max_size">20</prop>
                <prop key="hibernate.c3p0.timeout">1800</prop>
                <prop key="hibernate.c3p0.max_statements">50</prop>

                <prop key="hibernate.dialect">org.hibernate.dialect.HSQLDialect</prop>

                <prop key="hibernate.show_sql">false</prop>
                <prop key="hibernate.use_outer_join">true</prop>

                <prop key="hibernate.hbm2ddl.auto">update</prop>

                <prop key="hibernate.jdbc.batch_size">0</prop>
                <prop key="hibernate.jdbc.batch_versioned_data">true</prop>
                <prop key="hibernate.max_fetch_depth">1</prop>
                <prop key="hibernate.jdbc.use_streams_for_binary">true</prop>
            </props>
        </property>
        <property name="mappingResources">
            <list>
                <value>com/citi/rpc/webentity/BusinessDay.hbm.xml</value>
                <value>com/citi/rpc/webentity/Duty.hbm.xml</value>
                <value>com/citi/rpc/webentity/Employee.hbm.xml</value>
                <value>com/citi/rpc/webentity/TeamMember.hbm.xml</value>
                <value>com/citi/rpc/webentity/Project.hbm.xml</value>
            </list>
        </property>
    </bean>