title: Groovy SQL: Shall I manually close the Mysql connection
body: <p>I have a grails service that calls stored procedures using Groovy SQL.
  I am using <code>dataSource</code> for initializing the connection. 
  My question is: Do I need to manually close the connection or will it be handled by Groovy or GORM (since I am using <code>def dataSource</code>)?</p>
  
  <p>Here is how my service is structured.</p>
  
  <pre><code>class MyService {
  
      static transactional = Boolean.FALSE
  
      private static final String STATEMENT_ONE_SQL = "{ call sp_One(?) }"
  
      private static final String STATEMENT_TWO_SQL = "{ call sp_Two(?,?) }"
  
      def dataSource
  
      Sql sql
  
      @PostConstruct
      def initSql() {
         sql = new Sql(dataSource)
      }
  
      List&lt;GroovyRowResult&gt; callSpOne(Integer id) {
          List&lt;GroovyRowResult&gt; results = sql.rows(STATEMENT_ONE_SQL, [id])
          return results
      }
  
      List&lt;GroovyRowResult&gt; callSpTwo(Integer id, String name) {
           List&lt;GroovyRowResult&gt; results = sql.rows(STATEMENT_TWO_SQL, [id, name])
           return results
      }
  </code></pre>