Re: executeBatch() return SUCCESS_NO_INFO values - version 8.0.26

[Filipe Silva]

Hi Gil,

Yes. This happens when the insert query is rewritten to avoid sending multiple calls to the server. So, although you have add five commands to your batch, only one containing all the values was actually executed. As a side effect Connector/J is not able to compute the exact update count for each one of the commands and this is why it returns `SUCCESS_NO_INFO` for all.

You can read more about this in the description of the connection property rewriteBatchedStatements. Setting this property as `false` will make Connector/J return the exact update count for each one of the batched commands, but it will also be much slower executing them as a whole.

IHTH