hibernate连接池Word下载.docx

1、下面是Hibernate环境下几种常见的连接池配置：1Hibernate默认连接池!DOCTYPE hibernate-configurationPUBLIC -/Hibernate/Hibernate Configuration DTD/ENhibernate-configurationsession-factory JDBC驱动程序-property name=connection.driver_classcom.mysql.jdbc.Driver- 连接数据库的URL-connection.urljdbc:mysql:/localhost:3306/schoolprojectconnec

2、tion.useUnicodetrueconnection.characterEncodingUTF-8connection.usernamerootconnection.password-是否将运行期生成的SQL输出到日志以供调试-show_sql-指定连接的语言-dialectorg.hibernate.dialect.MySQLDialectmapping resource=com/wqbi/model/pojo/student.hbm.xml /session-factory/hibernate-configuration2C3P0连接配置-登录密码- C3P0连接池设定-phiber

3、nate.connection.provider_classorg.hibernate.connection.C3P0ConnectionProviderhibernate.c3p0.max_size20hibernate.c3p0.min_size5hibernate.c3p0.timeout120hibernate.c3p0.max_statements100hibernate.c3p0.idle_test_periodhibernate.c3p0.acquire_increment2something-else-entirelyproxool-连接池的别名-aliasDBPool-pro

4、xool只能管理由自己产生的连接-driver-url3306/schoolproject?useUnicode=true&characterEncoding=UTF8/driver-urldriver-class/driver-classdriver-propertiesuser value=root/password/driver-properties- proxool自动侦察各个连接状态的时间间隔（毫秒）,侦察到空闲的连接就马上回收,超时的销毁-house-keeping-sleep-time90000- 指因未有空闲连接可以分配而在队列中等候的最大请求数,超过这个请求数的用户连

5、接就不会被接受-maximum-new-connections/maximum-new-connections- 最少保持的空闲连接数-prototype-count/prototype-count- 允许最大连接数,超过了这个连接，再有请求时，就排在队列中等候，最大的等待请求数由maximum-new-connections决定-maximum-connection-count/maximum-connection-count- 最小连接数-minimum-connection-count10/proxool/something-else-entirely（2）配置hibernate.cfg.xml文件org.hibernate.connection.ProxoolConnectionProviderhibernate.proxool.pool_aliashibernate.proxool.xmlproxoolconf.xml