Example usage for javax.naming Context lookup

Introduction

In this page you can find the example usage for javax.naming Context lookup.

Prototype

public Object lookup(String name) throws NamingException;

Source Link

Document

Retrieves the named object.

Usage

From source file:org.enlacerh.util.Seg001.java

/**
 * Actualiza Paises//from w ww  . j a  v a  2 s .  c  o m
 **/
public void update() {
    try {
        Context initContext = new InitialContext();
        DataSource ds = (DataSource) initContext.lookup(JNDI);
        con = ds.getConnection();

        String query = "UPDATE SEG001";
        query += " SET CANTTRAB =" + Integer.parseInt(cantrab);
        query += " ,FECVEN = '" + getFechaFormat(fecven) + "'";
        query += " ,ESTATUS = ?";
        query += " ,EMPRESA = ?";
        query += " ,JNDI = ?";
        query += " WHERE grupo = " + Integer.parseInt(grupo);
        //System.out.println(query);
        pstmt = con.prepareStatement(query);
        pstmt.setString(1, estatus.toUpperCase());
        pstmt.setString(2, empresa.toUpperCase());
        pstmt.setString(3, jndi.toLowerCase());
        //Antes de insertar verifica si el rol del usuario tiene permisos para insertar
        vGacc = acc.valAccmnu("bas1", "update", login, JNDI);//LLama a la funcion que valida las opciones del rol
        if (vGacc) {
            msj = new FacesMessage(FacesMessage.SEVERITY_ERROR, getMessage("msnAccUpdate"), "");
        } else {
            try {
                //Avisando
                pstmt.executeUpdate();
                if (pstmt.getUpdateCount() == 0) {
                    msj = new FacesMessage(FacesMessage.SEVERITY_ERROR, getMessage("msnNoUpdate"), "");
                } else {
                    msj = new FacesMessage(FacesMessage.SEVERITY_INFO, getMessage("msnUpdate"), "");
                }
                fecven = null;
                cantrab = "25";
                estatus = "0";
                empresa = "";
                jndi = "";
            } catch (SQLException e) {
                e.printStackTrace();
                msj = new FacesMessage(FacesMessage.SEVERITY_FATAL, e.getMessage(), "");
            }

            pstmt.close();
            con.close();
        }

    } catch (Exception e) {
        e.printStackTrace();
    }
    FacesContext.getCurrentInstance().addMessage(null, msj);
}

---

From source file:org.enlacerh.util.Seg002.java

/**
* Leer Datos de roles//w ww. java2s .c  om
* @throws NamingException 
* @throws IOException 
**/

public void select(int first, int pageSize, String sortField, Object filterValue)
        throws SQLException, NamingException, IOException {

    Context initContext = new InitialContext();
    DataSource ds = (DataSource) initContext.lookup(JNDI);
    con = ds.getConnection();
    //Reconoce la base de datos de coneccin para ejecutar el query correspondiente a cada uno
    DatabaseMetaData databaseMetaData = con.getMetaData();
    productName = databaseMetaData.getDatabaseProductName();//Identifica la base de datos de coneccin

    String query = "";

    switch (productName) {
    case "Oracle":
        //Consulta paginada
        query = "  select * from ";
        query += " ( select query.*, rownum as rn from";
        query += "  ( SELECT trim(codrol), trim(desrol), trim(grupo)";
        query += " FROM SEG002";
        query += " where codrol like '" + codrol + "%'";
        query += " and codrol||desrol like '%" + ((String) filterValue).toUpperCase() + "%'";
        query += " and grupo = '" + grupo + "'";
        query += " order by 1) query";
        query += " ) where rownum <= " + pageSize;
        query += " and rn > (" + first + ")";

        break;
    case "PostgreSQL":
        //Consulta paginada
        query = "SELECT trim(codrol), trim(desrol), trim(CAST(grupo AS text))";
        query += " FROM SEG002";
        query += " where codrol like '" + codrol + "%'";
        query += " and codrol||desrol like '%" + ((String) filterValue).toUpperCase() + "%'";
        query += " and CAST(grupo AS text) = '" + grupo + "'";
        query += " order by " + sortField.replace("v", "");
        query += " LIMIT " + pageSize;
        query += " OFFSET " + first;
        break;
    }

    pstmt = con.prepareStatement(query);
    //System.out.println(query);

    r = pstmt.executeQuery();

    while (r.next()) {
        Rol select = new Rol();
        select.setVcodrol(r.getString(1));
        select.setVdesrol(r.getString(2));
        select.setVgrupo(r.getString(3));
        //Agrega la lista
        list.add(select);
        rows = list.size();
    }
    //Cierra las conecciones
    pstmt.close();
    con.close();
    r.close();

}

---

From source file:org.codesearch.commons.database.DBAccessImpl.java

@Inject
public DBAccessImpl() {
    Connection testConnection = null;
    try {/*w w  w. ja  va  2  s.c  om*/
        InitialContext ic = new InitialContext();
        Context evtContext = (Context) ic.lookup("java:comp/env/");
        dataSource = (DataSource) evtContext.lookup("jdbc/codesearch");
        if (dataSource != null) {
            testConnection = dataSource.getConnection();
            if (testConnection.isValid(3)) {
                LOG.info("Successfully connected to database");
            }
        } else {
            LOG.error("Database is not configured, code analysis will not be available");
        }
    } catch (SQLException ex) {
        LOG.error("Error accessing database, code analysis will not be available:\n", ex);
    } catch (NamingException ex) {
        LOG.error("Error accessing database, code analysis will not be available:\n", ex);
    } finally {
        if (testConnection != null) {
            try {
                testConnection.close();
            } catch (Exception ex) {
                LOG.warn("Could not close test database connection:\n", ex);
            }
        }
    }
}

---

From source file:org.enlacerh.util.Seg001.java

/**
 * Borra Paises/*from   w w  w.  j a  v a  2s .co m*/
 * <p>
 * Parametros del metodo: String codpai. Pool de conecciones
 **/
public void delete() {
    HttpServletRequest request = (HttpServletRequest) FacesContext.getCurrentInstance().getExternalContext()
            .getRequest();
    String[] chkbox = request.getParameterValues("toDelete");
    if (chkbox == null) {
        msj = new FacesMessage(FacesMessage.SEVERITY_WARN, getMessage("pnt003DelPai"), "");
    } else {
        try {
            Context initContext = new InitialContext();
            DataSource ds = (DataSource) initContext.lookup(JNDI);
            con = ds.getConnection();
            //Reconoce la base de datos de coneccin para ejecutar el query correspondiente a cada uno
            DatabaseMetaData databaseMetaData = con.getMetaData();
            productName = databaseMetaData.getDatabaseProductName();//Identifica la base de datos de coneccin

            String query = "";

            String param = "'" + StringUtils.join(chkbox, "','") + "'";

            switch (productName) {
            case "Oracle":
                query = "DELETE FROM SEG001 WHERE grupo in (" + param + ")";
                break;
            case "PostgreSQL":
                query = "DELETE FROM SEG001 WHERE CAST(grupo AS text) in (" + param + ")";
                break;
            }

            pstmt = con.prepareStatement(query);
            //System.out.println(query);

            //Antes de insertar verifica si el rol del usuario tiene permisos para insertar
            vGacc = acc.valAccmnu("bas1", "delete", login, JNDI);//LLama a la funcion que valida las opciones del rol
            if (vGacc) {
                msj = new FacesMessage(FacesMessage.SEVERITY_ERROR, getMessage("msnAccDelete"), "");
            } else {
                try {
                    //Avisando
                    pstmt.executeUpdate();
                    if (pstmt.getUpdateCount() <= 1) {
                        msj = new FacesMessage(FacesMessage.SEVERITY_INFO, getMessage("msnDelete"), "");
                    } else {
                        msj = new FacesMessage(FacesMessage.SEVERITY_INFO, getMessage("msnDeletes"), "");
                    }
                    limpiarValores();
                } catch (SQLException e) {
                    e.printStackTrace();
                    msj = new FacesMessage(FacesMessage.SEVERITY_FATAL, e.getMessage(), "");
                }

                pstmt.close();
                con.close();
            }

        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    FacesContext.getCurrentInstance().addMessage(null, msj);
}

---

From source file:org.enlacerh.util.Pnt003.java

/**
* Actualiza Paises//from w ww .ja  v a  2s. c o  m
**/
private void update() {
    try {
        Context initContext = new InitialContext();
        DataSource ds = (DataSource) initContext.lookup(JNDI);
        con = ds.getConnection();
        //Reconoce la base de datos de coneccin para ejecutar el query correspondiente a cada uno
        DatabaseMetaData databaseMetaData = con.getMetaData();
        productName = databaseMetaData.getDatabaseProductName();//Identifica la base de datos de coneccin

        String query = "";

        switch (productName) {
        case "Oracle":
            query = "UPDATE PNT003";
            query += " SET DESPAI = ?";
            query += " , FECACT = '" + getFecha() + "' , USRACT = '" + login + "'";
            query += " WHERE codpai = trim('" + codpai + "')";
            query += " and grupo = " + Integer.parseInt(localgrupo);
            break;
        case "PostgreSQL":
            query = "UPDATE PNT003";
            query += " SET DESPAI = ?";
            query += " , FECACT = '" + getFecha() + "' , USRACT = '" + login + "'";
            query += " WHERE CAST(codpai AS text) = trim('" + codpai + "')";
            query += " and grupo = " + Integer.parseInt(localgrupo);
            break;
        }

        //System.out.println(query);
        pstmt = con.prepareStatement(query);
        pstmt.setString(1, despai.toUpperCase());
        //Antes de insertar verifica si el rol del usuario tiene permisos para insertar
        vGacc = acc.valAccmnu("bas01", "update", login, JNDI);//LLama a la funcion que valida las opciones del rol
        if (vGacc) {
            msj = new FacesMessage(FacesMessage.SEVERITY_ERROR, getMessage("msnAccUpdate"), "");
        } else {
            try {
                //Avisando
                pstmt.executeUpdate();
                if (pstmt.getUpdateCount() == 0) {
                    msj = new FacesMessage(FacesMessage.SEVERITY_ERROR, getMessage("msnNoUpdate"), "");
                } else {
                    msj = new FacesMessage(FacesMessage.SEVERITY_INFO, getMessage("msnUpdate"), "");
                }
                despai = "";
                localgrupo = "";
                validarOperacion = 0;
            } catch (SQLException e) {
                e.printStackTrace();
                msj = new FacesMessage(FacesMessage.SEVERITY_FATAL, e.getMessage(), "");
            }

            pstmt.close();
            con.close();

        } //Fin validacion de licencia

    } catch (Exception e) {
        e.printStackTrace();
    }
    FacesContext.getCurrentInstance().addMessage(null, msj);
}

---

From source file:org.enlacerh.util.Seg001.java

/**
  * Leer Datos de paises/*  w  w  w  . j a  v a 2 s . c o  m*/
  * @throws NamingException 
  * @throws IOException 
  **/
public void select(int first, int pageSize, String sortField, Object filterValue)
        throws SQLException, NamingException, IOException {
    try {
        Context initContext = new InitialContext();
        DataSource ds = (DataSource) initContext.lookup(JNDI);

        con = ds.getConnection();
        //Reconoce la base de datos de coneccin para ejecutar el query correspondiente a cada uno
        DatabaseMetaData databaseMetaData = con.getMetaData();
        productName = databaseMetaData.getDatabaseProductName();//Identifica la base de datos de coneccin

        String query = "";

        switch (productName) {
        case "Oracle":
            //Consulta paginada
            query = "  select * from ";
            query += " ( select query.*, rownum as rn from";
            query += " ( SELECT grupo, canttrab, to_char(fecven, 'dd/mm/yyyy'), case when estatus ='0' then '"
                    + getMessage("pnt009Opc0") + "' else '" + getMessage("pnt009Opc1")
                    + "' end, estatus, empresa, JNDI";
            query += " FROM seg001";
            query += " where grupo||empresa like '%" + ((String) filterValue).toUpperCase() + "%'";
            //query += " order by " + sortField.replace("v", "") + ") query";
            query += ") query";
            query += ") where rn <= " + pageSize;
            query += " and rn > (" + first + ")";

            break;
        case "PostgreSQL":
            //Consulta paginada
            query = "SELECT grupo, canttrab, to_char(fecven, 'dd/mm/yyyy'), case when estatus ='0' then '"
                    + getMessage("pnt009Opc0") + "' else '" + getMessage("pnt009Opc1")
                    + "' end, estatus, empresa, JNDI";
            query += " FROM seg001";
            query += " where CAST(grupo AS text)||empresa like '%" + ((String) filterValue).toUpperCase()
                    + "%'";
            query += " order by 1";
            query += " LIMIT " + pageSize;
            query += " OFFSET " + first;
            break;
        }

        pstmt = con.prepareStatement(query);
        System.out.println(query);

        r = pstmt.executeQuery();

        while (r.next()) {
            GruposSeg select = new GruposSeg();
            select.setVgrupo(r.getString(1));
            select.setVcantrab(r.getString(2));
            select.setVfecven(r.getString(3));
            select.setVestatus(r.getString(4));
            select.setEstatuscode(r.getString(5));
            select.setVempresa(r.getString(6));
            select.setVjndi(r.getString(7));
            //Agrega la lista
            list.add(select);

        }
    } catch (SQLException e) {
        e.printStackTrace();
    }
    //Cierra las conecciones
    pstmt.close();
    con.close();
    r.close();
}

---

From source file:org.enlacerh.util.Pnt003.java

/**
* Leer Datos de paises/*from w w w .  j a va2 s . co m*/
* @throws NamingException 
* @throws IOException 
**/
public void select(int first, int pageSize, String sortField, Object filterValue)
        throws SQLException, NamingException {
    try {
        //System.out.println("JNDI: " + JNDI);
        Context initContext = new InitialContext();
        DataSource ds = (DataSource) initContext.lookup(JNDI);

        con = ds.getConnection();
        //Reconoce la base de datos de coneccin para ejecutar el query correspondiente a cada uno
        DatabaseMetaData databaseMetaData = con.getMetaData();
        productName = databaseMetaData.getDatabaseProductName();//Identifica la base de datos de coneccin

        String query = "";

        switch (productName) {
        case "Oracle":
            //Consulta paginada
            query = "  select * from ";
            query += " ( select query.*, rownum as rn from";
            query += " ( SELECT codpai, trim(despai), grupo";
            query += " FROM Pnt003";
            query += " where codpai like '" + codpai + "%'";
            query += " and codpai||despai like '%" + ((String) filterValue).toUpperCase() + "%'";
            query += " and grupo = '" + grupo + "'";
            query += " order by " + sortField.replace("v", "") + ") query";
            query += " ) where rownum <= " + pageSize;
            query += " and rn > (" + first + ")";

            break;
        case "PostgreSQL":
            //Consulta paginada
            query = "SELECT codpai, trim(despai), grupo";
            query += " FROM Pnt003";
            query += " where CAST(codpai AS text) like '" + codpai + "%'";
            query += " and cast(codpai as text)||despai like '%" + ((String) filterValue).toUpperCase() + "%'";
            query += " and CAST(grupo AS text) = '" + grupo + "'";
            query += " order by " + sortField;
            query += " LIMIT " + pageSize;
            query += " OFFSET " + first;

            break;
        }

        pstmt = con.prepareStatement(query);
        //System.out.println(query);

        r = pstmt.executeQuery();

        while (r.next()) {
            Pnt003 select = new Pnt003();
            select.setCodpai(r.getString(1));
            select.setDespai(r.getString(2));
            select.setLocalgrupo(r.getString(3));
            //Agrega la lista
            list.add(select);
        }
    } catch (SQLException e) {
        e.printStackTrace();
    }
    //Cierra las conecciones
    pstmt.close();
    con.close();
    r.close();

}

---

From source file:org.enlacerh.util.Seg002.java

/**
* Borra Paises/*w w w . j  a  va2s  .  c o  m*/
* <p>
* Parametros del metodo: String codpai. Pool de conecciones
* @throws NamingException 
* @throws IOException 
**/
public void delete() throws NamingException, IOException {
    if (licencia(grupo)) {
        msj = new FacesMessage(FacesMessage.SEVERITY_WARN, getMessage("licven"), "");
        FacesContext.getCurrentInstance().addMessage(null, msj);
    } else {
        HttpServletRequest request = (HttpServletRequest) FacesContext.getCurrentInstance().getExternalContext()
                .getRequest();
        String[] chkbox = request.getParameterValues("toDelete");

        if (codrol.equals(".")) {
            codrol = "";
        }

        if (chkbox == null) {
            msj = new FacesMessage(FacesMessage.SEVERITY_WARN, getMessage("del"), "");
        } else {
            try {
                Context initContext = new InitialContext();
                DataSource ds = (DataSource) initContext.lookup(JNDI);
                con = ds.getConnection();
                //Reconoce la base de datos de coneccin para ejecutar el query correspondiente a cada uno
                DatabaseMetaData databaseMetaData = con.getMetaData();
                productName = databaseMetaData.getDatabaseProductName();//Identifica la base de datos de coneccin

                String query = "";

                String param = "'" + StringUtils.join(chkbox, "','") + "'";

                switch (productName) {
                case "Oracle":
                    query = "DELETE FROM seg002 WHERE CODROL||GRUPO in (" + param + ")";
                    break;
                case "PostgreSQL":
                    query = "DELETE FROM seg002 WHERE CODROL||cast(GRUPO as text) in (" + param + ")";
                    break;
                }

                pstmt = con.prepareStatement(query);
                //System.out.println(query);
                //Antes de insertar verifica si el rol del usuario tiene permisos para insertar
                vGacc = acc.valAccmnu("seg01", "delete", login, JNDI);//LLama a la funcion que valida las opciones del rol
                if (vGacc) {
                    msj = new FacesMessage(FacesMessage.SEVERITY_ERROR, getMessage("msnAccDelete"), "");
                } else {

                    try {
                        //Avisando
                        pstmt.executeUpdate();
                        if (pstmt.getUpdateCount() <= 1) {
                            msj = new FacesMessage(FacesMessage.SEVERITY_INFO, getMessage("msnDelete"), "");
                        } else {
                            msj = new FacesMessage(FacesMessage.SEVERITY_INFO, getMessage("msnDeletes"), "");
                        }
                        limpiarValores();
                    } catch (SQLException e) {
                        msj = new FacesMessage(FacesMessage.SEVERITY_FATAL, e.getMessage(), "");
                    }

                    pstmt.close();
                    con.close();
                }
            } catch (Exception e) {
            }
        }
        FacesContext.getCurrentInstance().addMessage(null, msj);
    }
}

---

From source file:org.enlacerh.util.Pnt003.java

/**
* Borra Paises/*from   w ww .j a  va  2 s  . c  om*/
* <p>
* Parametros del metodo: String codpai. Pool de conecciones
* @throws NamingException 
* @throws IOException 
**/
public void delete() throws NamingException, IOException {
    if (licencia(grupo)) {
        msj = new FacesMessage(FacesMessage.SEVERITY_WARN, getMessage("licven"), "");
        FacesContext.getCurrentInstance().addMessage(null, msj);
    } else {
        HttpServletRequest request = (HttpServletRequest) FacesContext.getCurrentInstance().getExternalContext()
                .getRequest();
        String[] chkbox = request.getParameterValues("toDelete");

        if (chkbox == null) {
            msj = new FacesMessage(FacesMessage.SEVERITY_WARN, getMessage("pnt003DelPai"), "");
        } else {
            try {
                Context initContext = new InitialContext();
                DataSource ds = (DataSource) initContext.lookup(JNDI);
                con = ds.getConnection();
                //Reconoce la base de datos de coneccin para ejecutar el query correspondiente a cada uno
                DatabaseMetaData databaseMetaData = con.getMetaData();
                productName = databaseMetaData.getDatabaseProductName();//Identifica la base de datos de coneccin

                String query = "";

                String param = "'" + StringUtils.join(chkbox, "','") + "'";

                switch (productName) {
                case "Oracle":
                    query = "DELETE FROM PNT003 WHERE codpai||grupo in (" + param + ")";
                    break;
                case "PostgreSQL":
                    query = "DELETE FROM PNT003 WHERE CAST(codpai AS text)||CAST(grupo AS text) in (" + param
                            + ")";
                    break;
                }

                pstmt = con.prepareStatement(query);
                //System.out.println(query);

                //Antes de insertar verifica si el rol del usuario tiene permisos para insertar
                vGacc = acc.valAccmnu("bas01", "delete", login, JNDI);//LLama a la funcion que valida las opciones del rol
                if (vGacc) {
                    msj = new FacesMessage(FacesMessage.SEVERITY_ERROR, getMessage("msnAccDelete"), "");
                } else {
                    try {
                        //Avisando
                        pstmt.executeUpdate();
                        if (pstmt.getUpdateCount() <= 1) {
                            msj = new FacesMessage(FacesMessage.SEVERITY_INFO, getMessage("msnDelete"), "");
                        } else {
                            msj = new FacesMessage(FacesMessage.SEVERITY_INFO, getMessage("msnDeletes"), "");
                        }
                        limpiarValores();
                    } catch (SQLException e) {
                        e.printStackTrace();
                        msj = new FacesMessage(FacesMessage.SEVERITY_FATAL, e.getMessage(), "");
                    }

                    pstmt.close();
                    con.close();
                }

            } catch (Exception e) {
                e.printStackTrace();
            }
        }
        FacesContext.getCurrentInstance().addMessage(null, msj);
    }
}

---

From source file:org.enlacerh.util.Seg007.java

/**
  * Leer Datos de compaas para asignar a menucheck
  * @throws NamingException /*w  w w .  ja  v a2 s. co  m*/
 * @throws SQLException 
  * @throws IOException 
  **/
private void selectSeg007Cias() throws NamingException, SQLException, IOException {

    Context initContext = new InitialContext();
    DataSource ds = (DataSource) initContext.lookup(JNDI);
    con = ds.getConnection();

    //Reconoce la base de datos de coneccin para ejecutar el query correspondiente a cada uno
    DatabaseMetaData databaseMetaData = con.getMetaData();
    productName = databaseMetaData.getDatabaseProductName();//Identifica la base de datos de coneccin

    String query = null;

    switch (productName) {
    case "Oracle":
        //Consulta paginada
        query = "SELECT codcia, codcia||' - '||nomcia2";
        query += " FROM pnt001";
        query += " where grupo = '" + grupo + "'";
        query += " order by codcia";
        break;
    case "PostgreSQL":
        //Consulta paginada
        query = "SELECT codcia, codcia||' - '||nomcia2";
        query += " FROM pnt001";
        query += " where CAST(grupo AS text) = '" + grupo + "'";
        query += " order by codcia";
        break;
    }

    pstmt = con.prepareStatement(query);
    //System.out.println(query);

    ResultSet r = pstmt.executeQuery();

    while (r.next()) {
        String cia = new String(r.getString(1));
        String nombre = new String(r.getString(2));

        listCias.put(nombre, cia);
        sorted = sortByValues(listCias);

    }
    //Cierra las conecciones
    pstmt.close();
    con.close();

}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• »