code: public List<AssetRef> retrieveAllRefs(Date cutoffDate) throws IOException, SQLException {
          List<AssetRef> assetRefList = null;
          String select = "select definition_id, name, ref from ASSET_REF ";
          if (cutoffDate != null)
              select += "where ARCHIVE_DT >= ? ";
          select += "order by ARCHIVE_DT desc";
          try (Connection conn = getDbConnection();
                  PreparedStatement stmt = conn.prepareStatement(select)) {
              if (cutoffDate != null)
                  stmt.setTimestamp(1, new Timestamp(cutoffDate.getTime()));
              try (ResultSet rs = stmt.executeQuery()) {
                  assetRefList = new ArrayList<AssetRef>();
                  while (rs.next()) {
                      String name = rs.getString("name");
                      if (name != null && !name.endsWith("v0")) // Ignore version 0 assets
                          assetRefList.add(new AssetRef(rs.getString("name"), rs.getLong("definition_id"), rs.getString("ref")));
                  }
              }
          }
          return assetRefList;
      }
docs: Finds all asset refs from the database since cutoffDate, or all if cutoffDate is null.