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