code: public static List<GpsLog> getLogsList( IHMConnection connection ) throws Exception {
          List<GpsLog> logsList = new ArrayList<>();
          String sql = "select " + //
                  GpsLogsTableFields.COLUMN_ID.getFieldName() + "," + //
                  GpsLogsTableFields.COLUMN_LOG_STARTTS.getFieldName() + "," + //
                  GpsLogsTableFields.COLUMN_LOG_ENDTS.getFieldName() + "," + //
                  GpsLogsTableFields.COLUMN_LOG_TEXT.getFieldName() + //
                  " from " + TABLE_GPSLOGS; //
          try (IHMStatement statement = connection.createStatement(); IHMResultSet rs = statement.executeQuery(sql);) {
              statement.setQueryTimeout(30); // set timeout to 30 sec.
  
  
              // first get the logs
              while( rs.next() ) {
                  long id = rs.getLong(1);
  
                  long startDateTimeString = rs.getLong(2);
                  long endDateTimeString = rs.getLong(3);
                  String text = rs.getString(4);
  
                  GpsLog log = new GpsLog();
                  log.id = id;
                  log.startTime = startDateTimeString;
                  log.endTime = endDateTimeString;
                  log.text = text;
                  logsList.add(log);
              }
          }
          return logsList;
      }
docs: Get the list of available logs.
  
  @param connection the connection to use.
  @return the list of logs.
  @throws SQLException