code: private Profile getProfileFromResultSet(ResultSet result) throws Exception {
          Profile profile = new Profile();
          profile.setId(result.getInt(Constants.GENERIC_ID));
          Clob clobProfileName = result.getClob(Constants.PROFILE_PROFILE_NAME);
          String profileName = clobProfileName.getSubString(1, (int) clobProfileName.length());
          profile.setName(profileName);
          return profile;
      }
docs: Creates a Profile object from a SQL resultset
  
  @param result resultset containing the profile
  @return Profile
  @throws Exception exception