Hibernate 连接池配置

Hibernate 连接池配置
<!-- jdbc -->

<property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="connection.url">jdbc:oracle:thin:@10.203.14.132:1521:remotedb</property>
<property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
<property name="myeclipse.connection.profile">oracledriver</property>

<property name="connection.username">imagedb</property>
<property name="connection.password">cpic</property>

<!-- C3P0-->

<property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="connection.url">jdbc:oracle:thin:@10.203.14.132:1521:remotedb</property>
<property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
<property name="myeclipse.connection.profile">oracledriver</property>
<property name="connection.username">imagedb</property>
<property name="connection.password">cpic</property>

<property name="hibernate.connection.provider_class">

org.hibernate.connection.C3P0ConnectionProvider</property>
<property name="hibernate.c3p0.max_size">20</property>
<property name="hibernate.c3p0.min_size">5</property>
<property name="hibernate.c3p0.timeout">120</property>
<property name="hibernate.c3p0.max_statements">100</property>
<property name="hibernate.c3p0.idle_test_period">120</property>
<property name="hibernate.c3p0.acquire_increment">20</property>

<!-- Proxool -->
<!-- 这个名字要和上面XML文件中的别名要对应啊 -->
<property name="connection.provider_class">

org.hibernate.connection.ProxoolConnectionProvider</property>
<property name="proxool.pool_alias">imagePool</property>
<!-- 这个你刚才上面建立的XML文件的名字 -->
<property name="proxool.xml">ProxoolConf.xml</property>
<property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>

ProxoolConf.xml

<?xml version="1.0" encoding="utf-8"?>
<!-- the proxool configuration can be embedded within your own application's.
Anything outside the "proxool" tag is ignored. -->
<something-else-entirely>
<proxool>
<!-- 连接池的别名可以随便写，但注意的是后面在hibernate部分要对应-->
<alias>imagePool</alias>
<!--proxool只能管理由自己产生的连接-->
<driver-url>jdbc:oracle:thin:@10.203.14.132:1521:remotedb</driver-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<driver-properties>
<property name="user" value="imagedb"/>
<property name="password" value="cpic"/>
</driver-properties>
<!-- proxool自动侦察各个连接状态的时间间隔(毫秒),侦察到空闲的连接就马上回收,超时的销毁-->
<house-keeping-sleep-time>90000</house-keeping-sleep-time>
<!--指因未有空闲连接可以分配而在队列中等候的最大请求数,超过这个请求数的用户连接就不会被接受-->
<maximum-new-connections>20</maximum-new-connections>
<!-- 最少保持的空闲连接数-->
<prototype-count>5</prototype-count>
<!-- 允许最大连接数,超过了这个连接，再有请求时，就排在队列中等候，最大的等待请求数由maximum-new-connections决定-->
<maximum-connection-count>100</maximum-connection-count>
<!-- 最小连接数-->
<minimum-connection-count>10</minimum-connection-count>
<!--最大的等待请求数,即因没有空闲连接可以分配而在队列中等候的最大请求数,超过这个请求数的 用户 连接就不会被接受-->
<proxool.simultaneous-build-throttle>200</proxool.simultaneous-build-throttle>
<!--Test SQL(SELECT getDate()) -->
<house-keeping-test-sql>select CURRENT_DATE</house-keeping-test-sql>
</proxool>
</something-else-entirely>


　　这是proxool-0.8.3版本关闭时发生的异常

18:08:54,703 INFO imagePool:474 - Shutting down 'imagePool' pool immediately [Shutdown Hook]
18:08:54,750 ERROR ShutdownHook:62 - Problem calling "get cause" on IllegalStateException.
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.logicalcobwebs.proxool.ShutdownHook.remove(ShutdownHook.java:40)
at org.logicalcobwebs.proxool.ProxoolFacade.shutdown(ProxoolFacade.java:238)
at org.logicalcobwebs.proxool.ProxoolFacade.shutdown(ProxoolFacade.java:220)
at org.logicalcobwebs.proxool.ShutdownHook.run(ShutdownHook.java:99)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.IllegalStateException: Shutdown in progress
at java.lang.Shutdown.remove(Unknown Source)
at java.lang.Runtime.removeShutdownHook(Unknown Source)
... 9 more

建议用proxool-0.9.1.jar

官方地址：http://proxool.sourceforge.net/changelog.html