Database partition mode Part 2

[jamesagnew]

This is the second in a series of PRs to merge in the new database partition mode code.

This PR is preparation for the actual database partitioning:

• Change the method parameters on a number of SearchBuilder infrastructure components from Long to JpaPid. For now this change doesn't actually make any functional difference, but it will once we start storing the partition ID in there too.
• Sever the HFJ_RES_VER_PROV table from the HFJ_RES_VER table (previously these tables had a @OneToOne relationship which doesn't really work well with the way we're doing partitioning. This table has been deprecated for one year now, and upgrade instructions are provided for anyone who has older data stored. As a part of this change, all of the optmistic fetches we previously used to fetch this table have been removed.
• The ResourceSearchView view has been removed in favour of simply loading the HFJ_RES_VER table directly. This does not affect functionality or performance, but will simplify life when we merge in the final partitioning code.

[github-actions[bot]]

This Pull Request has failed the formatting check

Please run mvn spotless:apply or mvn clean install -DskipTests to fix the formatting issues.

You can automate this auto-formatting process to execute on the git pre-push hook, by installing pre-commit and then calling pre-commit install --hook-type pre-push. This will cause formatting to run automatically whenever you push.

[codecov[bot]]

Codecov Report

All modified and coverable lines are covered by tests :white_check_mark:

Project coverage is 83.47%. Comparing base (406db33) to head (b9ffd07). Report is 94 commits behind head on master.

Additional details and impacted files

```diff @@ Coverage Diff @@ ## master #6409 +/- ## ============================================ - Coverage 83.54% 83.47% -0.07% - Complexity 27432 27834 +402 ============================================ Files 1707 1744 +37 Lines 106185 107907 +1722 Branches 13397 13557 +160 ============================================ + Hits 88710 90077 +1367 - Misses 11750 12016 +266 - Partials 5725 5814 +89 ```

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.