The difference between batchupdateexception in MySQL and Oracle

generally speaking ,BatchUpdateException An error occurred during batch execution , Want to know which data is wrong , At this point, you will use batchUpdateException.getUpdateCounts() Method , According to the returned int Type array to determine .

however MySQL and Oracle Somewhat different ：

MySQL All statements will be executed , Then the array successfully returns 1, If it fails, it returns other values , such as -3.
Oracle Is always executing , When the first failed statement is encountered, it will return , Therefore, all of them are returned 1 Array of .

 Example ： Batch insert 10 Data , The first 3、6 Data entry failed 
MySQL Of batchUpdateException.getUpdateCounts() return ：{
    1,1,-3,1,1,-3,1,1,1,1}

Oracle Of batchUpdateException.getUpdateCounts() return ：{
    1,1}

 therefore ,Oracle If the first piece of data fails , It will return a length of 0 Array of