JDBC - Add OTEL span attributes for number of rows returned/affected by query

[doppleware]

Is your feature request related to a problem? Please describe.

Not directly a problem but I am trying to draw correlations between performance problems and number of rows returned by query

Describe the solution you'd like

Similar to the Micrometer implementation:
https://jdbc-observations.github.io/datasource-micrometer/docs/current/docs/html/#observability-spans
It would be awesome to see the attributes jdbc.row-affected jdbc.row-count on the db spans.

Describe alternatives you've considered

No response

Additional context

No response

[AlchemyDing]

I think this is a good idea, but the attribute name need to be considered.

[trask]

linking to related: open-telemetry/semantic-conventions#440

[github-actions]

Since there has been no activity on this enhancement for the past year we are closing it to help maintain our backlog. Anyone who would like to work on it is still welcome to do so, and we can re-open it at that time.

[jaydeluca]

re-opening as this has a lot of interest and the semconv PR is still open