DS_CONSULTA_AMBIENTE.js

function createDataset(fields, constraints, sortFields) {

    log.info("DS_CONSULTA_AMBIENTE - INÍCIO");

    try {
        var contextWD = new javax.naming.InitialContext();
        var dataSourceWD = contextWD.lookup("java:/jdbc/AppDS");
        var connectionWD = dataSourceWD.getConnection();
    } catch (e) {
        log.info("DS_CONSULTA_AMBIENTE - ERRO 1: " + e.message + "(#" + e.lineNumber + ")");
    }

    var newDataset = DatasetBuilder.newDataset();

    if (fields != null && fields.length > 0) {
        for (var alpha in fields) {
            newDataset.addColumn(fields[alpha]);
        }
    } else {
        newDataset.addColumn("URL");
    }

    var SQL = "";

    SQL += "SELECT ";

    var flagField = "";

    if (fields != null && fields.length > 0) {
        for (var alpha in fields) {
            SQL += flagField + " " + fields[alpha] + " ";
            flagField = ",";
        }
    } else {
        SQL += "DATA_VALUE URL ";
    }

    SQL += "FROM FDN_PARAMGERAL WHERE DATA_KEY = 'fluig/server.url' "

    log.info("DS_CONSULTA_AMBIENTE - SQL: " + SQL);

    var statementWD = connectionWD.prepareStatement(SQL);
    var rsWD = statementWD.executeQuery();

    while (rsWD.next()) {

        var arrayRetorno = new Array();

        if (fields != null && fields.length > 0) {
            for (var alpha in fields) {
                arrayRetorno.push(rsWD.getString(fields[alpha]));
            }
        } else {
        	arrayRetorno.push(rsWD.getString("URL"));
        }

        newDataset.addRow(arrayRetorno);
    }

    rsWD.close();
    statementWD.close();
    connectionWD.close();

    log.info("DS_CONSULTA_AMBIENTE - FIM");

    return newDataset;
}