Method firstRow

subprojects/groovy-sql/src/main/java/groovy/sql/Sql.java:2491–2502

Performs the given SQL query and return the first row of the result set. Example usage: def ans = sql.firstRow("select from PERSON where firstname like 'S%'") println ans.firstname Resource handling is performed automatically where appropriate. @param sql the SQL statement @ret

(String sql)

     * @throws SQLException if a database access error occurs
     */
    public GroovyRowResult firstRow(String sql) throws SQLException {
        List<GroovyRowResult> rows = null;
        try {
            rows = rows(sql, 1, 1, null);
        }
        //should be SQLFeatureNotSupportedException instead once we move to Java 1.6
        catch (SQLException featureNotSupportedException) {
            rows = rows(sql);
        }
        if (rows.isEmpty()) return null;
        return rows.get(0);
    }

    /**
     * Performs the given SQL query and return