hibernate、proxool配置

环境说明：tomcat6，hibernate3.6，proxool-0.9.1.jar，proxool-cglib.jar

hibernate.cfg.xml配置：

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
        "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
        "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">

<hibernate-configuration>

    <session-factory>
        <!-- Database connection settings -->    
            
        <property name="hibernate.connection.provider_class">org.hibernate.connection.ProxoolConnectionProvider</property>
        <property name="hibernate.proxool.xml">proxool.xml</property>
        <property name="hibernate.proxool.pool_alias">weicoop-proxool</property>
                
        <!-- SQL dialect -->
        <property name="dialect">org.hibernate.dialect.MySQL5Dialect</property>
        <!-- Enable Hibernate's automatic session context management -->
        <property name="current_session_context_class">thread</property>

        <!-- Disable the second-level cache  -->
        <property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>
        
        <!-- Echo all executed SQL to stdout -->
        <property name="show_sql">true</property>

        <!-- Drop and re-create the database schema on startup -->
        <property name="hbm2ddl.auto">update</property>
        <!--<mapping resource="m/model/Student.hbm.xml" />
        -->
        <mapping class="cn.mxc.weicoop.model.user.User"/>
            </session-factory>
</hibernate-configuration>

proxool.xml配置：

<?xml version="1.0" encoding="UTF-8"?>
<proxool>
    <alias>weicoop-proxool</alias>
    <driver-class>com.mysql.jdbc.Driver</driver-class>
    <driver-url>jdbc:mysql://localhost/weicoop?useUnicode=true&amp;characterEncoding=utf-8</driver-url>
    <driver-properties>
        <property name="user" value="root" />
        <property name="password" value="1234" />
    </driver-properties>
    <maximum-connection-count>10</maximum-connection-count>
    <house-keeping-test-sql>selectCURRENT_DATE</house-keeping-test-sql>
</proxool>  

提示：

1、hibernate.cfg.xml和proxool.xml在同级目录下

2、要认真看好所有的属性配置，特别是属性名，很多问题都会因为错误的属性书写导致的

3、在hibernate3.6中不要还有自带的proxool-0.8.3.jar（用proxool-0.9.1.jar和proxool-cglib.jar代替）这会导致报错如下：

　　

  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 
      at java.lang.Shutdown.remove(Shutdown.java:102) 
      at java.lang.Runtime.removeShutdownHook(Runtime.java:218) 
      ... 9 more