]
Steven Hawkins resolved TEIID-3272.
-----------------------------------
Resolution: Rejected
Control of batch commit as written in this enhancement is not something that we can
pursue.
A related and potentially valid approach would be to allow the use of source connections
in a more directly controlled local transaction mode. This would look something like not
automatically starting a global transaction on a Teiid client local transaction and
tracking connections via transaction on the server side. With the issue of course that
when using multiple sources the commits will not be coordinated.
JDBC Translator | Segregation of batch execution and commit mode
-----------------------------------------------------------------
Key: TEIID-3272
URL:
https://issues.jboss.org/browse/TEIID-3272
Project: Teiid
Issue Type: Enhancement
Components: JDBC Connector
Reporter: Shiveeta Mattoo
Assignee: Steven Hawkins
Labels: Batch-Commit, JDBC-Transator
Attachments: batch1.png
In JDBC Translator, the batch execution and commit are coupled together. Hence, we after
every batch execution, a commit is executed.
This enhancement is for providing an ability to support the commit after a configurable
'x' no. of batches has completed, instead of an automatic commit after every
batch.
The no of batches after which a commit is desired should be a configurable option.