commons-dev mailing list archives

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

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.

Paul
----- Original Message ----- 
From: "Dirk Verbeeck" <dirk.verbeeck@pandora.be>
To: "Jakarta Commons Developers List" <commons-dev@jakarta.apache.org>
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: commons-dev-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: commons-dev-help@jakarta.apache.org
>
> 


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


Mime
View raw message