hibernate+proxool连接池不成功.配成功的指点一二!!

Question

proxool.xml
<?xml version="1.0" encoding="GBK"?>
<something-else-entirely>
<proxool>
<!--连接池的别名-->
<alias>DBpool</alias>

<!--数据库URL-->
<driver-url>jdbc:oracle:thin:@192.168.1.200:1521:erm</driver-url>

<!-- JDBC驱动程序-->
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>

<!-- 数据库用户名和密码-->
<driver-properties>
<property name="user" value="sql" />
<property name="password" value="sql" />
</driver-properties>
<house-keeping-sleep-time>90000</house-keeping-sleep-time>
<maximum-new-connections>10</maximum-new-connections>
<prototype-count>3</prototype-count>
<maximum-connection-count>20</maximum-connection-count>
 <house-keeping-test-sql>select CURRENT_DATE</house-keeping-test-sql>
<minimum-connection-count>5</minimum-connection-count>

</proxool>
</something-else-entirely>hbm.xmlsession-factory>
<!--配置proxool数据库连接池 -->
<property name="show_sql">true</property>
<property name="hibernate.connection.provider_class">net.sf.hibernate.connection.ProxoolConnectionProvider</property>
<property name="hibernate.proxool.pool_alias">DBpool</property>
<property name="hibernate.proxool.xml">proxool.xml</property>
<property name="dialect">net.sf.hibernate.dialect.Oracle9Dialect</property>
出错异常:
:57:48,322  WARN DBpool:307 - Use of proxool.maximum-new-connections is deprecated. Use more descriptive proxool.simultaneous-build-throttle instead.
14:57:48,582  INFO ProxoolConnectionProvider:128 - Configuring Proxool Provider to use pool alias: proxool.DBpool
14:57:49,023  INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of process level read-write cache is not recommended)
14:57:51,006  INFO SettingsFactory:114 - Use scrollable result sets: true
14:57:51,006  INFO SettingsFactory:117 - Use JDBC3 getGeneratedKeys(): false
14:57:51,006  INFO SettingsFactory:120 - Optimize cache for minimal puts: false
14:57:51,006  INFO SettingsFactory:126 - echoing all SQL to stdout
14:57:51,006  INFO SettingsFactory:129 - Query language substitutions: {}
14:57:51,006  INFO SettingsFactory:140 - cache provider: net.sf.hibernate.cache.EhCacheProvider
14:57:51,016  INFO Configuration:1130 - instantiating and configuring caches
14:57:51,056  WARN Configurator:125 - No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/D:/webSoftware/myeclipse/eclipse/plugins/com.genuitec.org.hibernate.eclipse_4.1.1/myeclipse-data/2.1/lib/ehcache-0.9.jar!/ehcache-failsafe.xml
14:57:51,226  INFO SessionFactoryImpl:119 - building session factory
14:57:52,197  INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI, no JNDI name configured
14:57:52,488  INFO DBpool:474 - Shutting down 'DBpool' pool immediately [Shutdown Hook]
14:57:52,578 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(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
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(Thread.java:534)
Caused by: java.lang.IllegalStateException: Shutdown in progress
为什么dbpool会Shutting down呢.那里有问题啊!!配置过的指点一二啊!!

Answer 1

首先要确认hibernate与proxool版本
 还有就是文件布置的路径 一般是src下 我的是hibernate3 proxool-0.8.3-------------ProxoolConf.xml -----------(你与偶D不同名字)<?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> 
<alias>pool1</alias> 
<!--proxool只能管理由自己产生的连接--> 
<driver-url>jdbc:mysql://localhost:3306/album</driver-url> <!-- MYSQL -->
<driver-class>com.mysql.jdbc.Driver</driver-class>
<driver-properties> 
<property name="user" value="username"/> 
<property name="password" value="password"/> 
</driver-properties> <!-- 允许最大连接数,超过了这个连接，再有请求时，就排在队列中等候，最大的等待请求数由maximum-new-connections决定--> 
<maximum-connection-count>100</maximum-connection-count>
<!-- 指因未有空闲连接可以分配而在队列中等候的最大请求数,超过这个请求数的用户连接就不会被接受--> 
<maximum-new-connections>20</maximum-new-connections>
<!-- proxool自动侦察各个连接状态的时间间隔(毫秒),侦察到空闲的连接就马上回收,超时的销毁--> 
<house-keeping-sleep-time>90000</house-keeping-sleep-time>
<!-- 最少保持的空闲连接数--> 
<prototype-count>5</prototype-count> 
<!-- 最小连接数--> 
<minimum-connection-count>10</minimum-connection-count> 
</proxool> 
</something-else-entirely> ----------hibernate.cfg.xml----------------------------<session-factory>
<property name="dialect">org.hibernate.dialect.MySQLInnoDBDialect</property> <property name="proxool.pool_alias">pool1</property>  <!-- 名字很重要 -->
<property name="proxool.xml">ProxoolConf.xml</property>
<property name="connection.provider_class">org.hibernate.connection.ProxoolConnectionProvider</property> <property name="show_sql">true</property>
<property name="max_fetch_depth">10</property>
<property name="cache.use_query_cache">true</property>
<property name="cache.provider_class">org.hibernate.cache.EhCacheProvider</property>
<property name="jdbc.batch_size">20</property>
<property name="jdbc.fetch_size">20</property> <mapping resource="model/Album.hbm.xml"></mapping></session-factory>