[teiid-issues] [JBoss JIRA] (TEIID-3271) JDBC Translator | Incorrect Update count reported on Batched Update Execution

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-3271?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-3271.
-----------------------------------
    Fix Version/s: 8.10
       Resolution: Done


Corrected both the jdbcupdateexecution and the requestworkitem handling.  The requestworkitem would not report all of the counts if the number of values exceeded the batch size.

> JDBC Translator | Incorrect Update count reported on Batched Update Execution
> -----------------------------------------------------------------------------
>
>                 Key: TEIID-3271
>                 URL: https://issues.jboss.org/browse/TEIID-3271
>             Project: Teiid
>          Issue Type: Bug
>          Components: JDBC Connector
>            Reporter: Shiveeta Mattoo
>            Assignee: Steven Hawkins
>              Labels: Batch-Updates, JDBC-Transator
>             Fix For: 8.10
>
>
> Issue is related to Batched updates scenario.
> Typically, the executeBatch() returns an array of integers, and each element of the array represents the update count for the respective update statement.
> However in case of Teiid JDBC Translator, over and above this, we are processing the array to return a sum of all the elements as in seen in JDBCUpdateExecution -> executeTranslatedCommand method
>  int[] results = pstatement.executeBatch();
>  for (int i=0; i<results.length; i++) {
> updateCount += results[i];
> }
> The bug is logged to fix this to meet the standard behaviour
> Refer thread https://developer.jboss.org/message/914596?et=watches.email.thread#914596 for details



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