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 <shihadsa...@gmail.com> 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 >
