I am trying to handle reader failures during database restart. I tried with spring batch retry configuration. But I am getting SQL error saying connection is closed. Also c3p0 error as A PooledConnection that has already signalled a Connection error is still in use. Can anyone please help me out to solve this? Is there any specific settings I need to do for c3p0?
Asked
Active
Viewed 414 times
0
-
Possible duplicate of [Spring batch retry mechanism for reader failure](https://stackoverflow.com/questions/32680759/spring-batch-retry-mechanism-for-reader-failure) – Mahmoud Ben Hassine Nov 22 '18 at 09:54
-
I am not having problems in retry. During retry database connections are lost due to restart. Want to know how to solve that – Kannan Nov 22 '18 at 12:09
-
I don't know about c3p0, but hikari automatically reconnect a lost connection. See https://stackoverflow.com/questions/45356565/hikaricp-auto-reconnect – Mahmoud Ben Hassine Nov 22 '18 at 14:27