private void applySoftDeleteWithVersion(short accountId, short containerId, String blobName, long version,
      Timestamp deleteTs, Connection connection) throws Exception {
    String query = "";
    try (PreparedStatement statement = connection.prepareStatement(SOFT_DELETE_WITH_VERSION_QUERY)) {
      // use the current time
      statement.setTimestamp(1, deleteTs);
      statement.setInt(2, accountId);
      statement.setInt(3, containerId);
      statement.setString(4, blobName);
      statement.setLong(5, version);
      query = statement.toString();
      logger.debug("Soft deleting blob in MySql. Query {}", query);
      statement.executeUpdate();
    } catch (SQLException e) {
      logger.error("Failed to execute query {}, {}", query, e.getMessage());
      throw e;
    }
  }
Construct a list query statement with prefix when {@link MySqlNamedBlobDbConfig#listNamedBlobsSQLOption} is 3
@param statement The {@link PreparedStatement} to set the parameters on.
@param accountId The account id
@param containerId The container id
@param blobNamePrefix The blobname prefix
@param pageToken The page token
@param maxKeysValue The max key to return
@throws SQLException
ambry-named-mysql/src/main/java/com/github/ambry/named/MySqlNamedBlobDb.java