title: How to set transaction timeout in HikariCP
body: <p>I am looking for an analog of the <code>setDefaultTimeout</code> method of Spring's <code>AbstractPlatformTransactionManager</code> in jOOQ/HikariCP connection pool.</p>
  
  <p>I found various timeouts like <code>loginTimeout</code>, <code>maxLifetime</code>, and <code>idleTimeout</code> in <code>HikariDataSource</code>, but none of them seems to fit my purpose.</p>
  
  <p>I looked at jOOQ's <code>TransactionProvider</code> too.</p>
  
  <p>After some source code investigation I spotted the following code in HikariCP:</p>
  
  <pre><code>         setNetworkTimeout(connection, validationTimeout);
  
           try (Statement statement = connection.createStatement()) {
              if (isNetworkTimeoutSupported != TRUE) {
                 setQueryTimeout(statement, 
                     (int) MILLISECONDS.toSeconds(
                         Math.max(1000L, validationTimeout)));
              }
  
              statement.execute(config.getConnectionTestQuery());
           }
  </code></pre>
  
  <p>Looking at this, I suppose the configuration I am after is <code>validationTimeout</code>. Is this correct?</p>