Konstantin Orlov created IGNITE-18985:
-----------------------------------------
Summary: Sql. Jdbc. Integration with transaction
Key: IGNITE-18985
URL: https://issues.apache.org/jira/browse/IGNITE-18985
Project: Ignite
Issue Type: Improvement
Components: jdbc
Reporter: Konstantin Orlov
Current implementation of JDBC misses integration with transactions.
So, new command should be introduced to client-server protocol:
{{{}finishTx(commit: bool){}}}. According handler should be provided on a
server side. This command may be issued by invocation of commit/rollback
methods on {{{}JdbcConnection{}}}.
Also, we need to handle {{setAutoCommit}} method invocation as well.
Finally, depending on current mode of autoCommit and presence of valid
transaction in connection context, the new transaction should or should not be
issued before query execution. It looks like we can rely on implicit
transactions right now, thus if autoCommit set to true, it seems to safe to
provide null instead of actual transaction. However, autoCommit=false mode must
be handled explicitly.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)