在hibernate中配置proxool连接池
1：在applicationcontext.xml中配置sessionfactory
<bean id="sessionfactory" class="org.springframework.orm.hibernate3.localsessionfactorybean">
    <property name="hibernateproperties">
        <props>
            <prop key="hibernate.dialect">org.hibernate.dialect.oracle9dialect</prop>
            <prop key="hibernate.show_sql">true</prop>
            <!--指定proxool配置文件-->
            <prop key="hibernate.proxool.properties">conf/proxool.properties</prop>
            <!--<prop key="hibernate.proxool.xml">conf/proxool.xml</prop>-->
            <!--指定proxool的alias，必须与proxool的配置文件中的alias一致-->
            <prop key="hibernate.proxool.pool_alias">hibernate-oracle</prop>
        </props>
    </property>
</bean>
2：配置proxool(conf/proxool.properties)
#jdbc-0.proxool.alias=mysql
#jdbc-0.proxool.driver-class=org.gjt.mm.mysql.driver
#jdbc-0.proxool.driver-url=jdbc:mysql://localhost:3306/contestdb?user=root&password=1234&useunicode=true&characterencoding=utf8
#jdbc-0.user=root
#jdbc-0.password=1234

jdbc-0.proxool.alias=hibernatea-oracle
jdbc-0.proxool.driver-class=oracle.jdbc.driver.oracledriver
jdbc-0.proxool.driver-url=jdbc:oracle:thin:@172.16.2.6:1521:dbname
jdbc-0.user=username
jdbc-0.password=username
jdbc-0.proxool.maximum-connection-count=20
jdbc-0.proxool.house-keeping-test-sql=select sysdate from dual;
#debug, info, warn, error, fatal.
jdbc-0.proxool.statistics-log-level=error