Method withInstance

subprojects/groovy-sql/src/main/java/groovy/sql/Sql.java:336–340

Invokes a closure passing it a new Sql instance created from the given JDBC connection URL. The created connection will be closed if required. @param url a database url of the form jdbc: subprotocol : subname @param c the Closure to call @see #newInstance(Stri

(String url, @ClosureParams(value=SimpleType.class, options="groovy.sql.Sql") Closure c)

     * @throws SQLException if a database access error occurs
     */
    public static void withInstance(String url, @ClosureParams(value=SimpleType.class, options="groovy.sql.Sql") Closure c) throws SQLException {
        try (Sql sql = newInstance(url)) {
            c.call(sql);
        }
    }

    /**
     * Creates a new Sql instance given a JDBC connection URL