spring-boot:jdbc re-connection after db outage

Question

i'm using spring-boot and datasource with jdbc template (postgres). in my service i do

@Autowired
public MyDao(DataSource dataSource) {
    this.jdbcTemplate = new JdbcTemplate(dataSource);
}

and later jdbcTemplate().query(...);. all works as expected but when i restart db, it stops working. looks like datasource doesn't reconnect. i got:

org.postgresql.util.PSQLException: This connection has been closed.

i got same error when i add:

spring:
  datasource:
    testOnBorrow: true
    validationQuery: select 1

how to make datasource reconnect automatically?

See stackoverflow.com/questions/30451470/… (although it is about MySQL, the settings apply to other drivers as well). — M. Deinum
– M. Deinum, Commented Aug 4, 2016 at 12:47

piotrek · Accepted Answer · 2016-08-04 12:55:09Z

3

actually i found it does reconnect after adding:

spring:
  datasource:
    testOnBorrow: true
    validationQuery: select 1

i just needed to wait the default validationInterval that is 30sec

answered Aug 4, 2016 at 12:55

piotrek

14.7k17 gold badges95 silver badges184 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Miloš Milivojević Over a year ago

Can you accept your answer so that the question does not show as unanswered? Thanks!

Collectives™ on Stack Overflow

spring-boot:jdbc re-connection after db outage

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related