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; }