commons-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Paul Hsu" <>
Subject Re: [dbcp] Wait forever when get Ceonnction from data source
Date Mon, 17 Jan 2005 21:29:53 GMT

Thank you for help. So you think there is no way we can ask DBCP to abandon 
long waiting connection request  via jdbc/odbc driver? But if the odbc 
driver does not provide the property to set up the connection time out, it 
is better for DBCP to support. I think it will nice if Jakata DBCP project 
can implement this. I write a time out java program to abandon the 
connection request in certain period, but it is even better if DBCP project 
team can add this to project.
BTW, I thought that the maxWait is the max waiting time of a client can 
borrow the connection from pool before return.

----- Original Message ----- 
From: "Dirk Verbeeck" <>
To: "Jakarta Commons Developers List" <>
Sent: Monday, January 17, 2005 1:00 PM
Subject: Re: [dbcp] Wait forever when get Ceonnction from data source

> Connection timeout is a database driver specific property. You can set it 
> using the DBCP connectionProperties property. Or sometimes it is appended 
> to the URL.
> In your case you probably need to set the timeout on the odbc driver.
> Once the connection is in the pool then the maxWait can be used to limit 
> the pool waiting time.
> -- Dirk
> Paul Hsu wrote:
>> Hi,
>> I have one question about DBCP. I am connecting a database thruough 
>> Dharma odbc driver, so I use jdbc to odbc bridge,. It take a long time 
>> come back as expection when I try to call datasource.getConnection() and 
>> the server database daemon is not running. I cannot find any way to set 
>> up the time out in DBCP, I may miss some paramters. It would be 
>> appreciated if any one know how can I solve the problem.
>> Thanks,
>> Paul
> ---------------------------------------------------------------------
> To unsubscribe, e-mail:
> For additional commands, e-mail:

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message