Ejemplo n.º 1
0
  public List<StoredProc> retrieveProcList(
      String schema, String search, String procType, String userKey) throws SqlFireException {
    Connection conn = null;
    PreparedStatement stmt = null;
    ResultSet rset = null;
    List<StoredProc> procs = null;
    String srch = null;

    try {
      conn = AdminUtil.getConnection(userKey);
      stmt = conn.prepareStatement(Constants.USER_STORED_CODE);
      if (search == null) srch = "%";
      else srch = "%" + search.toUpperCase() + "%";

      stmt.setString(1, procType);
      stmt.setString(2, schema);
      stmt.setString(3, srch);
      rset = stmt.executeQuery();

      procs = makeProcListFromResultSet(rset);
    } catch (SQLException se) {
      logger.debug("Error retrieving all procs with search string = " + search);
      throw new SqlFireException(se);
    } catch (Exception ex) {
      logger.debug("Error retrieving all procs with search string = " + search);
      throw new SqlFireException(ex);
    } finally {
      // close all resources
      JDBCUtil.close(rset);
      JDBCUtil.close(stmt);
    }

    return procs;
  }
Ejemplo n.º 2
0
  public List<ProcedureParameter> describeProcedure(
      String schemaName, String procName, String userKey) throws SqlFireException {
    List<ProcedureParameter> procParams = new ArrayList<ProcedureParameter>();

    Connection conn = null;
    ResultSet rset = null;

    try {
      conn = AdminUtil.getConnection(userKey);
      rset =
          conn.getMetaData()
              .getProcedureColumns(null, schemaName.toUpperCase(), procName.toUpperCase(), "%");

      while (rset.next()) {
        ProcedureParameter param =
            new ProcedureParameter(
                rset.getInt("PARAMETER_ID"),
                rset.getString("COLUMN_NAME"),
                rset.getString("TYPE_NAME"));

        procParams.add(param);
      }
    } catch (SQLException se) {
      logger.debug("Error retrieving all parameters for procedure with name " + procName);
      throw new SqlFireException(se);
    } catch (Exception ex) {
      logger.debug("Error retrieving all parameters for procedure with name " + procName);
      throw new SqlFireException(ex);
    } finally {
      // close all resources
      JDBCUtil.close(rset);
    }

    // TODO Auto-generated method stub
    return procParams;
  }