code: public static List<Image> getImagesList( IHMConnection connection ) throws Exception {
          List<Image> images = new ArrayList<Image>();
          String sql = "select " + //
                  ImageTableFields.COLUMN_ID.getFieldName() + "," + //
                  ImageTableFields.COLUMN_LON.getFieldName() + "," + //
                  ImageTableFields.COLUMN_LAT.getFieldName() + "," + //
                  ImageTableFields.COLUMN_ALTIM.getFieldName() + "," + //
                  ImageTableFields.COLUMN_TS.getFieldName() + "," + //
                  ImageTableFields.COLUMN_AZIM.getFieldName() + "," + //
                  ImageTableFields.COLUMN_TEXT.getFieldName() + "," + //
                  ImageTableFields.COLUMN_NOTE_ID.getFieldName() + "," + //
                  ImageTableFields.COLUMN_IMAGEDATA_ID.getFieldName() + //
                  " from " + TABLE_IMAGES;
  
          try (IHMStatement statement = connection.createStatement(); IHMResultSet rs = statement.executeQuery(sql);) {
              statement.setQueryTimeout(30); // set timeout to 30 sec.
              
              while( rs.next() ) {
                  long id = rs.getLong(1);
                  double lon = rs.getDouble(2);
                  double lat = rs.getDouble(3);
                  double altim = rs.getDouble(4);
                  long ts = rs.getLong(5);
                  double azim = rs.getDouble(6);
                  String text = rs.getString(7);
                  long noteId = rs.getLong(8);
                  long imageDataId = rs.getLong(9);
  
                  Image image = new Image(id, text, lon, lat, altim, azim, imageDataId, noteId, ts);
                  images.add(image);
              }
          }
          return images;
      }
docs: Get the list of Images from the db.
  
  @return list of notes.
  
  @throws IOException if something goes wrong.