hibernate3 配置proxool连接池出现问题(大家帮帮我,要不然我下午就要走人了)

Question

hibernate-cfg.xml:<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
          "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
          "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"><hibernate-configuration>
<session-factory>

        ~~~~~~~~~~~~~~
       <property name="hibernate.connection.provider_class">org.hibernate.connection.ProxoolConnectionProvider
       </property>
<property name="hibernate.proxool.pool_alias">DBRmcPool</property>
<property name="hibernate.proxool.xml">proxool.xml</property>
<property name="show_sql">true</property>
<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
       
</session-factory>
</hibernate-configuration>proxool.xml:<?xml version="1.0" encoding="ISO-8859-1"?>
<!-- the proxool configuration can be embedded within your own application's.
Anything outside the "proxool" tag is ignored. -->
<something-else-entirely>
  <proxool>
    <alias>DBRmcPool</alias>
    <driver-url>jdbc:mysql://localhost:3306/rmc?useUnicode=true&amp;characterEncoding=gbk&amp;autoReconnect=true</driver-url>
    <driver-class>com.mysql.jdbc.Driver</driver-class>
    <driver-properties>
      <property name="user" value="root"/>
      <property name="password" value="admin123"/>
    </driver-properties>
    <maximum-connection-count>4</maximum-connection-count>
    <minimum-connection-count>2</minimum-connection-count>
    <house-keeping-test-sql>select CURRENT_DATE</house-keeping-test-sql>
    <statistics>15m,1h,1d</statistics>
  </proxool>
</something-else-entirely>web.xml
<servlet>
<servlet-name>ServletConfigurator</servlet-name>
<servlet-class>org.logicalcobwebs.proxool.configuration.ServletConfigurator</servlet-class>
<init-param>
<param-name>xmlFile</param-name>
<param-value>WEB-INF/Proxool.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>没次启动tomcat的时候都报错说hibernate-cfg.xml加载不了 proxool.xml 我换成绝对路径也不行...大家帮帮我 小弟 感激..

Answer 1

关于这些配置的问题,有时候可能跟版本有关,比如tomcat5和5.5在配置数据池的时候的server.xml配置就有差别.
....
查看一下action的映射问题..

Answer 2

<property name="hibernate.proxool.pool_alias">dbpool</property> 
<property name="hibernate.proxool.xml">proxool.xml</property> 
<property name="connection.provider_class">org.hibernate.connection.ProxoolConnectionProvider</property> 

Answer 3

在hibernate.cfg.Xml中增加： 
<property name="hibernate.proxool.pool_alias">dbpool</property> 
<property name="hibernate.proxool.xml">proxool.xml</property> 
<property name="connection.provider_class">org.hibernate.connection.ProxoolConnectionProvider</property> 

Answer 4

在与hibernate.cfg.xml同级目录（src根目录下）增加proxool.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> 
        <alias>dbpool</alias> 
        <!--proxool只能管理由自己产生的连接--> 
        <driver-url> 
          jdbc:mysql://20.20.20.6:3306/tcs?useUnicode=true&amp;characterEncoding=UTF-8 
        </driver-url> 
        <driver-class>com.mysql.jdbc.Driver</driver-class> 
        <driver-properties> 
            <property name="user" value="root" /> 
            <property name="password" value="123123" /> 
        </driver-properties> 
        <!-- proxool自动侦察各个连接状态的时间间隔(毫秒),侦察到空闲的连接就马上回收,超时的销毁--> 
        <house-keeping-sleep-time>90000</house-keeping-sleep-time> 
        <!-- 最少保持的空闲连接数--> 
        <prototype-count>5</prototype-count> 
        <!-- 允许最大连接数,超过了这个连接，再有请求时，就排在队列中等候，最大的等待请求数由maximum-new-connections决定--> 
        <maximum-connection-count>100</maximum-connection-count> 
        <!-- 最小连接数--> 
        <minimum-connection-count>10</minimum-connection-count> 
    </proxool> 
</something-else-entirely> 

Answer 5

xml文件中param-value >WEB-INF/Proxool.xml </param-value > 
和hibernate-cfg.xml中的 <property name="hibernate.proxool.xml" >proxool.xml </property > 
文件开头字母大小写不一样。

Answer 6

记住设置 hibernate.proxool.existing_pool   true 

Answer 7

还有你的Proxool.xml 是否是proxool.xml 

Answer 8

顶一个，Hibernate偶还是新手.....