i config my connectionpool as below.but connection will be exhausted very soon.
<data-sources>
<data-source key="testSource" type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="driverClassName" value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/>
<set-property property="url" value="jdbc:microsoft:sqlserver://myComputer:1433;DatabaseName=myDB"/>
<set-property property="maxActive" value="50"/>
<set-property property="maxIdle" value="5"/>
<set-property property="username" value="user"/>
<set-property property="maxWait" value="5"/>
<set-property property="password" value=""/>
</data-source>
</data-sources>
_________________________________________________________________
免费下载 MSN Explorer: http://explorer.msn.com/lccn
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
