Add tracing, logging, and caching to the plugin

[craigtmoore]

What feature do you want to see added?

In order to measure the performance of the plugin when accessing the database, we should add open telemetry tracing and logging. In addition, there are opportunities to introduce caching so that the plugin doesn't have to access the database each time it needs to access data. instead it can store the data temporarily in a cache to improve access times.

Upstream changes

No response

Are you interested in contributing this feature?

yes, I plan to create a pull request soon to facilitate these changes.

[cyrille-leclerc]

@craigtmoore @timja FYI we are introducing an opentelemetry-api plugin to cleanup your dependencies:

• opentelemetry-api-plugin hosting request jenkins-infra/repository-permissions-updater#3973

I also proposed an enhancement of the SQL spans:

• Instrument jdbc datasource to see SQL statement spans in the traces #416

cc @kuisathaverat