title: Jooq connection lifecycle
body: <p>I am evaluating Jooq and I would like to confirm my understanding about the JDBC connection lifecycle.</p>
  
  <p>I am using a connection pool (Hikari) and I configure a DSLContext using the datasource.</p>
  
  <p>As I understand it:</p>
  
  <ol>
  <li><p>I am safe to create one DSLContext that I can reuse across my application in many threads? Is there any negative to doing this provided I don't modify the config? Contention etc?</p></li>
  <li><p>Each time I do a database access, does Jooq obtain a connection from the pool, do the DB access and then commit and release it? Eg:</p></li>
  </ol>
  
  <pre><code>Result&lt;Record&gt; result = context.select().from(AUTHOR).fetch();
  Result&lt;Record&gt; otherResult = context.select().from(BOOKS).fetch();
  </code></pre>
  
  <p>Each of these queries would obtain and release a new connection from the pool?</p>
  
  <ol start="3">
  <li>When using the transaction API like this:</li>
  </ol>
  
  <pre><code>context.transaction(ctx -&gt; {
          DSLContext trans = DSL.using(ctx);
     ...
  });
  </code></pre>
  
  <p>A connection would be obtained from the pool and reused for all accesses using the <code>trans</code> context?</p>
  
  <p>Thanks!</p>