gistfile1.java

    public void connect() {
        try {
            Connection connIrs=new MyConnectDB().connect(irsConnection,irsUser,irsPassword);
            Connection connImpact=new MyConnectDB().connect(impactConnection,impactUser,impactPassword);
            Connection connIpreport=new MyConnectDB().connect(ipreportConnection,ipreportUser,ipreportPassword);

            Mapping myMapping=Mapping.getInstance(connIrs,connImpact,connIpreport);
            TreeMap<String, String> myParameters = myMapping.getParams(adminNum,sceneid,data,indata);
            if(!myParameters.isEmpty()) {
                for(String param : myParameters.keySet()) {
                    parameters.put(param, myParameters.get(param));
                    logger.log(Logger.INFO, "Get param "+param+"="+myParameters.get(param));
                }
            } else {
                logger.log(Logger.WARNING, "Not supported technical solution for "+adminNum);
                opStore.addError(operationID,"Route Agent","Not supported technical solution",kowgar.agent.common.Definitions.ERROR_LEVEL_CRITICAL);
            }

        } catch (Exception e) {
            log.info();

        } finally {
            close(connIrs);
            close(connImpact);
            close(connIpreport);
        }

        logger.log(Logger.INFO, "<obtainParametersFromBd() ");
        return parameters;
    }



    private Connection getConnection(String a, b, c) {
        Conenction conenction = new MyConnectDB().connect(irsConnection,irsUser,irsPassword);
        if (conenction == null) {
            throw new IllegalStateException("Impossible to connect");
        }
        return connection;
    }


    
    public void close(Connection connection, String message) {
        if(connection!=null) {
            try {
                connection.close();
            } catch (Exception ex) {
                logger.log(Logger.WARNING, "Exception on "+message+" connection close "+ex);
            }
        }
    }