lizongbo 的 編程學(xué)習(xí)

很奇怪，很多人都說proxool很好，
但是搜索spring中配置proxool作 數(shù)據(jù)源連接池的資料卻幾乎找不到詳細(xì)點(diǎn)的。

因此自己整理如下：

? 先下載:
?
? http://surfnet.dl.sourceforge.net/sourceforge/proxool/proxool-0.9.0RC2.zip


? web.xml

-------------------------


? <servlet>
??? <servlet-name>proxoolServletConfigurator</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>
? <servlet>
??? <servlet-name>proxooladmin</servlet-name>
??? <servlet-class>org.logicalcobwebs.proxool.admin.servlet.AdminServlet</servlet-class>
? </servlet>
? <servlet-mapping>
??? <servlet-name>proxooladmin</servlet-name>
??? <url-pattern>/proxooladmin</url-pattern>
? </servlet-mapping>


-------------------------

? proxool.xml

-------------------------
<?xml version="1.0" encoding="UTF-8"?>
<proxool-config>
? <proxool>
??? <alias>blogdb</alias>
??? <driver-url>jdbc:oracle:thin:@127.0.0.1:1521:ORADB</driver-url>
??? <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
??? <driver-properties>
????? <property name="user" value="lizongbo"/>
????? <property name="password" value="password"/>
??? </driver-properties>
??? <maximum-connection-count>10</maximum-connection-count>
??? <house-keeping-test-sql>select 1 from dual</house-keeping-test-sql>
? </proxool>
</proxool-config>

spring里：
兩種配置：
a:? <!-- 與上面的proxool以及web.xml里結(jié)合使用-->
??? <bean id="mainDataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
??? <property name="driverClassName">
??? <value>org.logicalcobwebs.proxool.ProxoolDriver</value>
??? </property>
??? <property name="url">
??? <value>proxool.blogdb</value>
??? </property>
??? </bean>

b:<!-- 單獨(dú)的類似dbcp的使用-->
? <bean id="mainDataSource" class="org.logicalcobwebs.proxool.ProxoolDataSource" destroy-method="close">
??? <property name="driver">
????? <value>oracle.jdbc.driver.OracleDriver</value>
??? </property>
??? <property name="driverUrl">
????? <value>jdbc:oracle:thin:lizongbo/password@127.0.0.1:1521:ORADB</value>????
?<!--用戶名和密碼寫在一起才調(diào)用成功,不然會報 調(diào)用無效的參數(shù) 錯誤，下面設(shè)置用戶名和密碼的property好像是無效的，其它數(shù)據(jù)庫也是這樣
?比如mysql的也要把用戶名和密碼寫在url里：<property name="driverUrl" value="jdbc:mysql://localhost:3306/blogdb?user=lizongbo&amp;password=lizongbo" />
?-->
??? </property>
??? <property name="user"> <!-- 必須在這里也設(shè)置，但是 proxool卻不使用它，或許是個bug-->
????? <value>lizongbo</value>
??? </property>
??? <property name="password"> <!-- 必須在這里也設(shè)置，但是 proxool卻不使用它，或許是個bug-->
????? <value>lizongbo</value>
??? </property>
??? <property name="alias">
????? <value>lizongbo</value>
??? </property>
??? <property name="houseKeepingSleepTime">
????? <value>90000</value>
??? </property>
??? <property name="prototypeCount">
????? <value>5</value>
??? </property>
??? <property name="maximumConnectionCount">
????? <value>100</value>
??? </property>
??? <property name="minimumConnectionCount">
????? <value>10</value>
??? </property>
??? <property name="trace">
????? <value>true</value>
??? </property>
??? <property name="verbose">
????? <value>true</value>
??? </property>
? </bean>


???