下面我介绍一下在使用Hibernate 3.0做数据执久层解决方案时,怎么配置Proxool 0.8.3数据库连接池的方法。
1、将proxool-0.8.3.jar以及连接数据库用到的jar文件包含在你的项目的classpath或者WEB-INF/lib下面,本例使用的是MS Sqlserver数据库。
2、在和hibernate.cfg.xml平级的目录新建一个proxoolconf.xml文件,添加以下文件内容:
xml 代码
- xml version="1.0" encoding="utf-8"?>
- <something-else-entirely>
- <proxool>
- <alias>proxoolPoolalias>
-
- <driver-url>jdbc:microsoft:sqlserver://192.168.0.5:1433;DatabaseName=videopublishdriver-url>
- <driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriverdriver-class>
- <driver-properties>
- <property name="user" value="jdbc_user"/>
- <property name="password" value="memory"/>
- driver-properties>
-
- <house-keeping-sleep-time>90000house-keeping-sleep-time>
-
- <maximum-new-connections>20maximum-new-connections>
-
- <prototype-count>5prototype-count>
-
- <maximum-connection-count>100maximum-connection-count>
-
- <minimum-connection-count>10minimum-connection-count>
- proxool>
- something-else-entirely>
3、以上就是proxool所需的配置文件,下面就是hibernate.cfg.xml文件的配置了,也很简单,文件内容如下:
xml 代码
- xml version='1.0' encoding='UTF-8'?>
- "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
- "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
-
- <hibernate-configuration>
- <session-factory>
- <property name="proxool.pool_alias">proxoolPoolproperty>
- <property name="proxool.xml">proxoolconf.xmlproperty>
- <property name="connection.provider_class">org.hibernate.connection.ProxoolConnectionProviderproperty>
- <property name="connection.driver_class">com.microsoft.jdbc.sqlserver.SQLServerDriverproperty>
- <property name="show_sql">trueproperty>
- <mapping resource="com/vp/persistent/pojo/Users.hbm.xml" />
- <mapping resource="com/vp/persistent/pojo/Videoclasses.hbm.xml" />
- <mapping resource="com/vp/persistent/pojo/Videodiscuss.hbm.xml" />
- <mapping resource="com/vp/persistent/pojo/Videoinfo.hbm.xml" />
- session-factory>
- hibernate-configuration>