code: public void removePath(int pathId) {
          PreparedStatement statement = null;
  
          try (Connection sqlConnection = sqlService.getConnection()) {
              // remove any enabled overrides with this path
              statement = sqlConnection.prepareStatement(
                  "DELETE FROM " + Constants.DB_TABLE_ENABLED_OVERRIDE +
                      " WHERE " + Constants.ENABLED_OVERRIDES_PATH_ID + " = ?"
              );
              statement.setInt(1, pathId);
              statement.executeUpdate();
              statement.close();
  
              // remove path
              statement = sqlConnection.prepareStatement(
                  "DELETE FROM " + Constants.DB_TABLE_PATH
                      + " WHERE " + Constants.GENERIC_ID + " = ?"
              );
              statement.setInt(1, pathId);
              statement.executeUpdate();
              statement.close();
  
              //remove path from responseRequest
              statement = sqlConnection.prepareStatement(
                  "DELETE FROM " + Constants.DB_TABLE_REQUEST_RESPONSE
                      + " WHERE " + Constants.REQUEST_RESPONSE_PATH_ID + " = ?"
              );
              statement.setInt(1, pathId);
              statement.executeUpdate();
              statement.close();
          } catch (SQLException e) {
              e.printStackTrace();
          } finally {
              try {
                  if (statement != null) {
                      statement.close();
                  }
              } catch (Exception e) {
              }
          }
      }
docs: Remove a path
  
  @param pathId ID of path