code: public AssetRef retrieveRef(Long id) throws IOException, SQLException {
          String select = "select definition_id, name, ref from ASSET_REF where definition_id = ?";
          try (Connection conn = getDbConnection();
                  PreparedStatement stmt = conn.prepareStatement(select)) {
              stmt.setLong(1, id);
              try (ResultSet rs = stmt.executeQuery()) {
                  if (rs.next()) {
                      return new AssetRef(rs.getString("name"), id, rs.getString("ref"));
                  }
              }
          }
          return null;
      }
docs: Finds an asset ref from the database by definitionID.