[GROOVY-5375] Sql has newInstance methods which create connections but doesn't manage them

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.0-beta-3, 1.8.7
• Assignee: Paul King
• Reporter: Paul King
• Created: 20/Mar/12 08:12
• Updated: 07/Apr/15 19:07
• Resolved: 21/Mar/12 18:00

Description

It would be useful to have variations of some of the groovy.sql.Sql#newInstance methods which took care of resource management, e.g. instead of this:

def sql
try {
  sql = Sql.newInstance(db.url, db.user, db.password, db.driver)
  // sql operations here
} finally {
  sql?.close()
}

You could do something like:

Sql.withInstance(db.url, db.user, db.password, db.driver) { sql ->
  // sql operations here
}