title: How to configure auto reconnection with hikari in SpringBoot application?
body: <p>We are using SpringBoot 2.1.x version so Hikari is the default DataSource implementation. However, I am not sure how to configure Hikari settings to auto reconnect to our Oracle database after database maintenance/restart or network connection issue. </p>
  
  <p>We have the following hikari settings but it does not seem to help.</p>
  
  <pre><code>account.datasource.url: jdbc:oracle:thin:@myserver:1521:DEV
  account.datasource.username: user
  account.datasource.password: xxxx
  account.datasource.driverClassName: oracle.jdbc.driver.OracleDriver
  
  account.datasource.hikari.connection-timeout: 30000
  account.datasource.hikari.maximum-pool-size: 3
  account.datasource.hikari.idle-timeout: 60000
  account.datasource.hikari.max-lifetime: 1800000
  account.datasource.hikari.minimum-idle: 2
  </code></pre>
  
  <p>It failed to reconnect after network connection to the database got restored.</p>
  
  <p>Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30033ms.</p>
  
  <p>Any other account.datasource.hikari.xxxxx will help to auto reconnect to the database ?</p>