DB Connection Restore Issue with Apache Commons DBCP 2.5.0

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

DB Connection Restore Issue with Apache Commons DBCP 2.5.0

Shihad Salam
Hi Team,

Please help me in resolving the below issue:

While using the DBCP2 (2.5.0) connection pool in my SpringBoot project with
MS SQL Server, the database connection is not restoring after a DB service
restart. This is working fine when using the SpringBoot default Hikari
Connection Pool. Is this a bug with DBCP2?  If not, how can I solve this
issue?

I have used the below configurations:
**.dbcp2.test-while-idle=true*
**.dbcp2.test-on-borrow=true*
**.dbcp2.time-between-eviction-runs-millis=60000*
**.dbcp2.validation-query=SELECT 1*
**.dbcp2.min-idle=1*
**.dbcp2.max-total=100*

**.dbcp2.max-idle=50*

P.S : If this mail is not intended to this mail group, please forward to
the respective team.

Thanks,
Shihad
Reply | Threaded
Open this post in threaded view
|

Re: DB Connection Restore Issue with Apache Commons DBCP 2.5.0

garydgregory
Hi,

I would try the current version 2.7.0 to see if the problem exists there as
well. If it does, then the best thing to do might be to reproduce the issue
in a way where anyone can also reproduce it, by for example, creating a
self-contained failing unit test in a PR on GitHub with an in-memory
database like H2. You should also make sure you are using the current
version of the MS-SQL JDBC driver. This might be a lot of work but your
description is really not enough to go on.

Gary

On Thu, Oct 31, 2019 at 5:09 AM Shihad Salam <[hidden email]> wrote:

> Hi Team,
>
> Please help me in resolving the below issue:
>
> While using the DBCP2 (2.5.0) connection pool in my SpringBoot project with
> MS SQL Server, the database connection is not restoring after a DB service
> restart. This is working fine when using the SpringBoot default Hikari
> Connection Pool. Is this a bug with DBCP2?  If not, how can I solve this
> issue?
>
> I have used the below configurations:
> **.dbcp2.test-while-idle=true*
> **.dbcp2.test-on-borrow=true*
> **.dbcp2.time-between-eviction-runs-millis=60000*
> **.dbcp2.validation-query=SELECT 1*
> **.dbcp2.min-idle=1*
> **.dbcp2.max-total=100*
>
> **.dbcp2.max-idle=50*
>
> P.S : If this mail is not intended to this mail group, please forward to
> the respective team.
>
> Thanks,
> Shihad
>
Reply | Threaded
Open this post in threaded view
|

Re: DB Connection Restore Issue with Apache Commons DBCP 2.5.0

Phil Steitz
In reply to this post by Shihad Salam
What exactly do you mean by "restoring?"

Phil

On 10/30/19 11:17 PM, Shihad Salam wrote:

> Hi Team,
>
> Please help me in resolving the below issue:
>
> While using the DBCP2 (2.5.0) connection pool in my SpringBoot project with
> MS SQL Server, the database connection is not restoring after a DB service
> restart. This is working fine when using the SpringBoot default Hikari
> Connection Pool. Is this a bug with DBCP2?  If not, how can I solve this
> issue?
>
> I have used the below configurations:
> **.dbcp2.test-while-idle=true*
> **.dbcp2.test-on-borrow=true*
> **.dbcp2.time-between-eviction-runs-millis=60000*
> **.dbcp2.validation-query=SELECT 1*
> **.dbcp2.min-idle=1*
> **.dbcp2.max-total=100*
>
> **.dbcp2.max-idle=50*
>
> P.S : If this mail is not intended to this mail group, please forward to
> the respective team.
>
> Thanks,
> Shihad
>


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]