Mailing-List: contact commons-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Jakarta Commons Users List" <commons-user@jakarta.apache.org>
Received-SPF: pass (asf.osuosl.org: domain of joehansen12@hotmail.com
 designates 65.54.175.28 as permitted sender)
Message-ID: <BAY104-F1846BE7A72E8702670D3E9B3AE0@phx.gbl>
From: "Joe Hansen" <joehansen12@hotmail.com>
To: commons-user@jakarta.apache.org
Subject: DBCP removeAbandoned not working!
Date: Tue, 30 Aug 2005 00:36:00 +0000
Mime-Version: 1.0
Content-Type: text/plain; format=flowed

hi all,

I am using DBCP 1.2.1. Why is the abandoned connection NOT returned after 5 
seconds?

Please help.
Thanks,
Joe.

The output of the following program is as follows:
<output>
Loading underlying JDBC driver.
Creating connection 1.
AbandonedObjectPool is used 
(org.apache.commons.dbcp.AbandonedObjectPool@21b6d)
   LogAbandoned: false
   RemoveAbandoned: true
   RemoveAbandonedTimeout: 300
Creating connection 2.
org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool 
exhausted
</output>

<code>
import java.sql.Connection;
import javax.sql.DataSource;
import java.util.Properties;
import org.apache.commons.dbcp.BasicDataSourceFactory;


public class ManualPoolingDriverExample2 {

    public static void main(String[] args) {
        System.out.println("Loading underlying JDBC driver.");
        Properties dataSourceProperties = new Properties();
        dataSourceProperties.setProperty("factory", 
"org.apache.commons.dbcp.BasicDataSourceFactory");
        dataSourceProperties.setProperty("driverClassName", 
"com.progress.sql.jdbc.JdbcProgressDriver");
        dataSourceProperties.setProperty("url", 
"jdbc:jdbcprogress:T:localhost:9199:test");
        dataSourceProperties.setProperty("username", "joe");
        dataSourceProperties.setProperty("password", "joe1");
        dataSourceProperties.setProperty("maxActive", "1");
        dataSourceProperties.setProperty("maxWait", "10000"); // wait for 10 
secs
        dataSourceProperties.setProperty("removeAbandoned", "true");
        dataSourceProperties.setProperty("logAbandoned", "false");
        dataSourceProperties.setProperty("removeAbandonedTimeout", "5"); // 
return abandonded connections after 5 secs

        try {
        	DataSource dataSource = 
BasicDataSourceFactory.createDataSource(dataSourceProperties);

            Connection conn = null;

            System.out.println("Creating connection 1.");
            conn = dataSource.getConnection();
            System.out.println("Creating connection 2.");
            conn = dataSource.getConnection();
            System.out.println("Done creating connections.");
        } catch (Exception ex) {
        	ex.printStackTrace();
        }
    }

}
</code>

_________________________________________________________________
On the road to retirement? Check out MSN Life Events for advice on how to 
get there! http://lifeevents.msn.com/category.aspx?cid=Retirement


---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org