code: void getProperties(Connection connection, long id, LoggingEvent event)
        throws SQLException {
  
      PreparedStatement statement = connection.prepareStatement(sqlProperties);
      try {
        statement.setLong(1, id);
        ResultSet rs = statement.executeQuery();
  
        while (rs.next()) {
          String key = rs.getString(1);
          String value = rs.getString(2);
          event.setProperty(key, value);
        }
      } finally {
        statement.close();
      }
    }
docs: Retrieve the event properties from the logging_event_property table.
  
  @param connection
  @param id
  @param event
  @throws SQLException