Spring Document the impact of setting a transactionMode on @SqlConfig

Hello Spring Team

The question is available on SO at:

• When is mandatory define each value for SqlConfig.TransactionMode for @SqlConfig?

But the current and unique "answer" is not neither valid nor realistic (AI is involved)

Therefore more details for the SqlConfig.TransactionMode enum would valuable to understand when choice each value explicitly.

Thanks for your understanding.

Comment From: snicoll

I agree that there are a lot of information and rules about how this behaves. The reference guide could perhaps use some more examples.

cc @sbrannen