Пример #1
0
  public ResultSet dump() throws SQLException {
    CachedRowSetImpl rs = new CachedRowSetImpl();
    RowSetMetaDataImpl meta = new RowSetMetaDataImpl();
    meta.setColumnCount(2);
    meta.setColumnName(1, "QUEUE_TYPE");
    meta.setColumnType(1, Types.VARCHAR);
    meta.setColumnName(2, "REQUEST");
    meta.setColumnType(2, Types.VARCHAR);
    rs.setMetaData(meta);

    synchronized (queue) {
      Iterator<AbstractQueryManager> it = queue.iterator();
      while (it.hasNext()) {
        AbstractQueryManager s = (AbstractQueryManager) it.next();
        rs.moveToInsertRow();
        rs.updateString(1, "QUEUE");
        rs.updateString(2, s.getSql());
        rs.insertRow();
        rs.moveToCurrentRow();
      }
      it = executingQueries.iterator();
      while (it.hasNext()) {
        AbstractQueryManager s = (AbstractQueryManager) it.next();
        rs.moveToInsertRow();
        rs.updateString(1, "EXECUTING_QUERIES");
        rs.updateString(2, s.getSql());
        rs.insertRow();
        rs.moveToCurrentRow();
      }
    }
    return rs;
  }