`

连接池p

阅读更多
版本:Proxool 0.9.1

这次配置出问题了,在hibernate.cfg.xml中少个property,如下:
<property name="hibernate.proxool.existing_pool">true</property>
加上就好了。

它的配置:
(1)在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://localhost:3306/zhangwei
           </driver-url>

           <driver-class>com.mysql.jdbc.Driver</driver-class>
           <driver-properties>
               <property name="user" value="root" />
               <property name="password" value="path" />
           </driver-properties>

           <house-keeping-sleep-time>90000</house-keeping-sleep-time>

           <prototype-count>15</prototype-count>
           <maximum-connection-count>500</maximum-connection-count>
           <minimum-connection-count>30</minimum-connection-count>
           <house-keeping-test-sql>select CURRENT_DATE</house-keeping-test-sql>

       </proxool>

</something-else-entirely>

(2)在hibernate.config.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>
(3)在web.xml中添加如下内容:
<!-- 配置初始化servlet,在web容器加载的时候自动加载配置文件,如果不是web程序,这个部分就需要通过开发接口来初始化了 -->
<servlet>
     <servlet-name>proxoolInitialServlet</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>

  好了完成了,ok!
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics