<bean id="abstractDataSource"
class="org.logicalcobwebs.proxool.ProxoolDataSource" abstract="true" lazy-init="true">
<property name="driver">
<value>net.sourceforge.jtds.jdbc.Driver</value>
</property>
<property name="user"> <!-- 必須設定,但Proxool不使用 -->
<value>${db.boss.user}</value>
</property>
<property name="password"> <!-- 必須設定,但Proxool不使用 -->
<value>${db.boss.password}</value>
</property>
<!-- 自動偵察各個串連狀態的時間間隔(毫秒),偵察到閒置串連就馬上回收,逾時的銷毀 -->
<property name="houseKeepingSleepTime">
<value>${db.abstract.houseKeepingSleepTime}</value>
</property>
<!-- 最少保持的空閑串連數 -->
<property name="prototypeCount">
<value>${db.abstract.prototypeCount}</value>
</property>
<property name="maximumConnectionCount">
<value>${db.abstract.maximumConnectionCount}</value>
</property>
<property name="minimumConnectionCount">
<value>${db.abstract.minimumConnectionCount}</value>
</property>
<property name="trace">
<value>${db.abstract.trace}</value>
</property>
<property name="verbose">
<value>${db.abstract.verbose}</value>
</property>
<!-- 串連最大生命時間 單位:秒 -->
<property name="maximumConnectionLifetime">
<value>${db.abstract.maximumConnectionLifetime}</value>
</property>
<property name="simultaneousBuildThrottle">
<value>${db.abstract.simultaneousBuildThrottle}</value>
</property>
<property name="recentlyStartedThreshold">
<value>${db.abstract.recentlyStartedThreshold}</value>
</property>
<property name="overloadWithoutRefusalLifetime">
<value>${db.abstract.overloadWithoutRefusalLifetime}</value>
</property>
<property name="statistics">
<value>${db.abstract.statistics}</value>
</property>
<property name="statisticsLogLevel">
<value>${db.abstract.statisticsLogLevel}</value>
</property>
<!-- 最大串連啟用時間 單位:秒-->
<property name="maximumActiveTime">
<value>${db.abstract.maximumActiveTime}</value>
</property>
</bean>
<bean id="jobcnBossBaseDataSource" parent="abstractDataSource">
<property name="driverUrl">
<value>jdbc:jtds:sqlserver://localhost:1433;user=username;password=password;DatabaseName=dbName</value>
</property>
<property name="alias">
<value>dbName</value>
</property>
</bean>
需要的包jtds-1.2.2.jar,msbase.jar,mssqlserver.jar,msutil.jar,proxool-0.9.0RC3.jar