三步走:
第一步:在Spring的配置文件中加入:
<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"> <property name="configLocation"> <value>classpath:hibernate.cfg.xml</value> </property> </bean>
第二步:在Hibernate配置文件中加入:
<session-factory> <property name="hibernate.proxool.pool_alias"> DBPool </property> <property name="hibernate.proxool.xml">pool.xml</property> <property name="hibernate.connection.provider_class"> org.hibernate.connection.ProxoolConnectionProvider </property> <property name="hibernate.proxool.existing_pool">false</property> <property name="dialect"> org.hibernate.dialect.Oracle9iDialect </property> <property name="hibernate.show_sql">true</property> </session-factory>
第三步:增加pool.xml文件,内容如下:
<?xml version="1.0" encoding="UTF-8"?> <something-else-entirely> <proxool> <alias>DBPool</alias> <driver-url> jdbc:oracle:thin:@192.168.1.166:1521:test </driver-url> <driver-class>oracle.jdbc.driver.OracleDriver</driver-class> <driver-properties> <property name="user" value="test" /> <property name="password" value="test" /> </driver-properties> <!-- 连接最大活动时间(毫秒)--> <maximum-active-time>120000</maximum-active-time> <!-- 连接最大生命时间 (毫秒)--> <maximum-connection-lifetime>36000000</maximum-connection-lifetime> <!-- 侦测状时间(毫秒) --> <house-keeping-sleep-time>60000</house-keeping-sleep-time> <!-- 并发数 --> <simultaneous-build-throttle>200</simultaneous-build-throttle> <!-- 每次新增连接数 --> <prototype-count>2</prototype-count> <!-- 最大连接数量 --> <maximum-connection-count>300</maximum-connection-count> <!-- 最小连接数量 --> <minimum-connection-count>5</minimum-connection-count> </proxool> </something-else-entirely>