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, 8.7.3
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