[teiid-issues] [JBoss JIRA] (TEIID-3272) JDBC Translator | Segregation of batch execution and commit mode

[Shiveeta Mattoo (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3272?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13029870#comment-13029870 ] 

Shiveeta Mattoo edited comment on TEIID-3272 at 1/5/15 8:40 AM:
----------------------------------------------------------------

On debugging the code, I am seeing that the input to : private int[] executeTranslatedCommand(TranslatedCommand translatedComm) 
is a single batch of multiple records. Is that an incorrect expectation for the method?

The executed method  public void execute() throws TranslatorException, recevies each batch one by one, and delegates processing to 
executeTranslatedCommand for each batch which is getting committed by restoreAutoCommit.

As seem in attached screenshot, the batch of 2 records (201,202) is processed by the method in one turn.


was (Author: shiveeta.mattoo):
On debugging the code, I am seeing that the input to : private int[] executeTranslatedCommand(TranslatedCommand translatedComm) 
is a single batch of multiple records. Is that an incorrect expectation for the method?

The executed method  public void execute() throws TranslatorException, recevies each batch one by one, and delegates processing to 
executeTranslatedCommand for each batch which is getting committed by restoreAutoCommit.


> 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.
>  



--
This message was sent by Atlassian JIRA
(v6.3.11#6341)