Don't use transaction in JDBC sink

[fuyufjh]

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

It many cause unnecessary deadlocks

Describe the solution you'd like

No response

Describe alternatives you've considered

No response

Additional context

No response

[StrikeW]

Do you mean enable auto-commit or set the isolation level to the lowest level for the session? I think we can do both in the at-least-once semantic.

[fuyufjh]

Do you mean enable auto-commit or set the isolation level to the lowest level for the session? I think we can do both in the at-least-once semantic.

+1. Good point!

[StrikeW]

As discussion in #12250, transaction (RC level) still preserved for consistency.