code: public List<KamInfo> getCatalog() throws SQLException {
          List<KamInfo> list = new ArrayList<KamInfo>();
          ResultSet rset = null;
  
          try {
              PreparedStatement ps = getPreparedStatement(SELECT_KAM_CATALOG_SQL);
              rset = ps.executeQuery();
  
              while (rset.next()) {
                  list.add(getKamInfo(rset));
              }
          } catch (SQLException ex) {
              throw ex;
          } finally {
              close(rset);
          }
  
          return list;
      }
docs: Retrieves the {@link KamInfo} objects from the KAM catalog database.
  
  <p>
  If the <tt>kam</tt> doesn't exist then a null {@link KamInfo} is returned.
  </p>
  @return {@link KamInfo}, the kam info object from the
  kam catalog database or null if the kam name cannot be found.
  @throws SQLException Thrown if a SQL error occurred while retrieving
  the {@link KamInfo} objects from the kam catalog.