Docs: Transaction retry guidance for Hibernate

[jseldess]

Hibernate follow-up to https://github.com/cockroachdb/docs/issues/3315.

[jseldess]

As discussed with @awoods187, @rmloveland, and @timveil, moving this to later, pending further Product work.

[rmloveland]

See discussion in https://github.com/cockroachdb/cockroach/issues/27274 for some example code

See also: some good information on explaining that the example code is running in SERIALIZABLE mode as well as a blog post on the topic.

[jseldess]

@rmloveland, is this out of scope for 19.2 at this point, given that we are de-emphasizing savepoint?

[rmloveland]

@jseldess I think integrating the SAVEPOINT protocol with Hibernate will be too large / difficult for 19.2.

However I think it's possible that I can update the Hibernate example with an "app-level retry loop" as part of #5035 (probably the last work item for that ticket we can get in for 19.2 before moving on to product work).

[awoods187]

+1 @rmloveland We should only deemphasize savpoint with hibernate (but show how to do it via #5035 ) for 19.2

[rmloveland]

@awoods187 the Java/Hibernate page shows how to write a retry loop. That work would seem to cover "transaction retry guidance for Hibernate". Any objection to closing this?

[awoods187]

I'm good @rafiss are we missing anything else here?

[rafiss]

This looks fine to close, to me.