preparedStatement = connection.prepareStatement(sql);
            // Fill parameters
            int i = 1; //NOPMD
            for (Object o : params) {
                preparedStatement.setObject(i++, o);
            }
            resultSet = preparedStatement.executeQuery();
            final ResultSetMetaData resultSetMetaData = resultSet.getMetaData();
            final int numberOfColumns = resultSetMetaData.getColumnCount();
            list = new ArrayList<Map<String, Object>>();
            final Map map = new HashMap();
            while (resultSet.next()) {
                for (i = 1; i <= numberOfColumns; i++) {
                    map.put(resultSetMetaData.getColumnName(i), resultSet.
                            getObject(i));
                }
                list.add(map);
            }
        } catch (SQLException e) {
            throw new DbAccessException(String.format(
                    "selectMapList: sql=%s, params=%s", sql, Arrays.asList(
                            params)), e);
        } finally {
            try {
                if (resultSet != null) {
                    resultSet.close();
                }
            } catch (SQLException e) {
                log.error(e.getMessage());
            }
            try {
                if (preparedStatement != null) {
                    preparedStatement.close();
                }
            } catch (SQLException e) {
                log.error(e.getMessage());
            }

            preparedStatement = connection.prepareStatement(sql,
                    Statement.RETURN_GENERATED_KEYS);
            // Fill parameters
            int i = 1; //NOPMD
            for (Object o : params) {
                preparedStatement.setObject(i++, o);
            }
            preparedStatement.executeUpdate();
            resultSet = preparedStatement.getGeneratedKeys();
            final ResultSetMetaData resultSetMetaData = resultSet.getMetaData();
            final int numberOfColumns = resultSetMetaData.getColumnCount();
            // Prime the pump
            if (resultSet.next()) {
                keys = new HashMap<String, Object>();
                for (i = 1; i <= numberOfColumns; i++) {
                    keys.put(resultSetMetaData.getColumnName(i),
                            resultSet.getObject(i));
                }
            }
        } catch (SQLException e) {
            throw new DbAccessException(String.format(
                    "updateReturnKeys: sql=%s, params=%s", sql, Arrays.asList(
                            params)), e);
        } finally {
            try {
                if (resultSet != null) {
                    resultSet.close();
                }
            } catch (SQLException e) {
                log.error(e.getMessage());
            }
            try {
                if (preparedStatement != null) {
                    preparedStatement.close();
                }
            } catch (SQLException e) {
                log.error(e.getMessage());
            }

            preparedStatement = connection.prepareStatement(sql);
            // Fill parameters
            int i = 1; //NOPMD
            for (Object o : params) {
                preparedStatement.setObject(i++, o);
            }
            resultSet = preparedStatement.executeQuery();
            list = createObjects(resultSet, clazz);
        } catch (Exception e) {
            throw new DbAccessException(String.format(
                    "selectBeanList: sql=%s, params=%s", sql, Arrays.asList(
                            params)), e);
        } finally {
            try {
                if (resultSet != null) {
                    resultSet.close();
                }
            } catch (SQLException e) {
                log.error(e.getMessage());
            }
            try {
                if (preparedStatement != null) {
                    preparedStatement.close();
                }
            } catch (SQLException e) {
                log.error(e.getMessage());
            }

            final DbJdbcConn dbAccess = (DbJdbcConn) invocation.
                    getArguments()[0];
            // Begin transaction
            dbAccess.getConnection().setAutoCommit(false);
            try {
                // Proceed with the original method's invocation
                object = invocation.proceed();
                // Commit if successful
                dbAccess.getConnection().commit();
                dbAccess.getConnection().setAutoCommit(true);
                if (log.isDebugEnabled()) {
                    log.debug(String.format(
                            "Committed transaction for method %s",
                            invocation.getMethod().getName()));
                }
            } catch (Exception e) {
                // Rollback on Exception
                if (log.isDebugEnabled()) {
                    log.debug(String.format(
                            "Rollback transaction for method %s",
                            invocation.getMethod().getName()));
                }
                // Rollback on error
                dbAccess.getConnection().rollback();
                dbAccess.getConnection().setAutoCommit(true);
                throw e;
            }
        }
        return object;
    }
}

            list = (List<T>) template.query(connection, sql,
                    new BeanListHandler(clazz,
                            new BasicRowProcessor(new DbBeanProcessor())),
                    params);
        } catch (SQLException e) {
            throw new DbAccessException(String.format(
                    "selectBeanList: sql=%s, params=%s", sql, Arrays.asList(
                            params)), e);
        }
        return list;
    }

    /**
     * Return query results as list of Maps. {@code Connection} is not closed.
     *
     * @param sql SQL statement to execute.
     * @param params Initialize the PreparedStatement's IN parameters.
     * @return {@code List} of Maps containing field name/value pair.
     */
    @Override
    @SuppressFBWarnings(value
            = "SQL_PREPARED_STATEMENT_GENERATED_FROM_NONCONSTANT_STRING",
            justification
            = "SQL libraries are allowed to accept SQL as parameter")
    public final List<Map<String, Object>> selectList(final String sql,
            final Object[] params) {
        if (log.isDebugEnabled()) {
            log.debug(String.format("selectMapList: sql=%s, params=%s", sql,
                    Arrays.asList(params)));
        }
        List<Map<String, Object>> list = null;
        try {
            list = template.query(connection, sql, new MapListHandler(),

                    "selectBeanList: sql=%s, params=%s", sql, Arrays.asList(
                            params)), e);
        } finally {
            try {
                if (resultSet != null) {
                    resultSet.close();
                }
            } catch (SQLException e) {
                log.error(e.getMessage());
            }
            try {
                if (preparedStatement != null) {
                    preparedStatement.close();
                }
            } catch (SQLException e) {
                log.error(e.getMessage());
            }
            try {
                if (connection != null) {
                    connection.close();
                }
            } catch (SQLException e) {
                log.error(e.getMessage());
            }
        }
        return list;
    }

    /**
     * Return query results as list of Maps. {@code Connection} closed
     * automatically.
     *
     * @param sql SQL statement to execute
     * @param params Initialize the PreparedStatement's IN parameters
     * @return {@code List} of Maps containing field name/value pair
     */
    @Override
    @SuppressFBWarnings(value
            = "SQL_PREPARED_STATEMENT_GENERATED_FROM_NONCONSTANT_STRING",
            justification
            = "SQL libraries are allowed to accept SQL as parameter")
    public final List<Map<String, Object>> selectList(final String sql,

            preparedStatement = connection.prepareStatement(sql);
            // Add parameter arrays to batch
            for (Object[] param : params) {
                // Fill parameters
                int i = 1; //NOPMD
                for (Object o : param) {
                    preparedStatement.setObject(i++, o);
                }
                // Add to batch
                preparedStatement.addBatch();
            }
            rows = preparedStatement.executeBatch();
        } catch (SQLException e) {
            throw new DbAccessException(String.format(
                    "batch: sql=%s, params=%s", sql, Arrays.asList(
                            params)), e);
        } finally {
            try {
                if (preparedStatement != null) {
                    preparedStatement.close();
                }
            } catch (SQLException e) {
                log.error(e.getMessage());
            }