title: How to manage DSLContext in jooq? (close connection)
body: <p>This is how I implement each jooq query that i want. </p>
  
  <pre><code>UtilClass{
  
   //one per table more or less
   static void methodA(){
  
    //my method
    Connection con = MySQLConnection.getConexion(); //open
    DSLContext create = DSL.using(con, SQLDialect.MYSQL); //open
  
    /* my logic and jooq querys */ //The code !!!!!!!
  
    try {
  
      if ( con != null )
         con.close(); //close
    } catch (SQLException e) {
  
    } //close
  
    con=null; //close
    create=null; //close
   }
  }
  </code></pre>
  
  <p>Am I overworking here? / Is it safe to leave the Context and Connection Open?</p>
  
  <p>In case it is safe to leave it open I would rather work with 1 static field DSLContext per <code>UtilClass</code> (and only the commented section would be on my methods). I would be opening a connection for each UtilClass since I am encapsulating the methods per table (more or less).</p>