The DB connection pool you are using is designed to be SIMPLE as the name implies. If you need something a little more robust I would suggest using DBCP from Apache.
Very easy to configure and it will have all the options you need. Nathan On 6/18/07, Gaurav Goel <[EMAIL PROTECTED]> wrote:
Hello,
I am using simple datasource and have set various parameters.
But i dont find any parameter related to minimum active connections.
How do i set that parameter? Or does it have a default value?
This is code in my sqlmap-config.xml file:
Any help would be highly appreciated.
<?
xml version="1.0" encoding="UTF-8" ?>
<!
DOCTYPE sqlMapConfig
PUBLIC
"-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-config-2.dtd";
>
<
sqlMapConfig>
<settings cacheModelsEnabled="true" enhancementEnabled="true"
maxSessions="64" maxTransactions="8" maxRequests="128" />
<transactionManager type="JDBC">
<dataSource type="SIMPLE">
<property value="oracle.jdbc.driver.OracleDriver"
name="JDBC.Driver" />
<property value="jdbc:oracle:thin:@//abidb02:1521/ORCL"
name="JDBC.ConnectionURL" />
<property value="abiweb" name="JDBC.Username" />
<property value="web4810" name="JDBC.Password" />
<property value="15" name="Pool.MaximumActiveConnections" />
<property value="15" name="Pool.MaximumIdleConnections" />
<property value="1000" name="Pool.MaximumWait" />
<property value="1000" name="JDBC.LoginTimeout" />
<property value="0" name="Pool.TimeToWait"/>
</dataSource>
</transactionManager>
</
sqlMapConfig>
With Warm Regards,
Gaurav Goel.
(Software Engineer)
<<inline: image001.gif>>
