[CONJ-630] No method returns update counts in batch mode Created: 2018-07-31 Updated: 2018-10-02 Resolved: 2018-10-02 |
|
| Status: | Closed |
| Project: | MariaDB Connector/J |
| Component/s: | batch |
| Affects Version/s: | 2.2.6 |
| Fix Version/s: | 2.3.0 |
| Type: | Bug | Priority: | Major |
| Reporter: | Radek Wikturna | Assignee: | Diego Dupin |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | None | ||
| Environment: |
Java 8, Windows 10, MariaDB 10.2.13 |
||
| Issue Links: |
|
||||||||
| Description |
|
When executing a batch of UPDATE/DELETE statements using PreparedStatement.executeBatch(), there is no method that returns update counts. |
| Comments |
| Comment by Diego Dupin [ 2018-08-09 ] |
|
By default, the driver now uses a new bulk command that executes batch a lot faster. The main default is that connector then just now the total results of the batch. Example for 3 inserts: If update results are important, this new fast batch can be disabled by setting the option "useBulkStmts" to false. |
| Comment by Radek Wikturna [ 2018-08-10 ] |
|
Please read the description carefully. I was talking about UPDATE/DELETE statements, NOT INSERT statements! However, let's say I execute these 3 statements as a batch (by calling PreparedStatement.executeBatch()) How do I set the useBulkStmts option? |
| Comment by Radek Wikturna [ 2018-10-02 ] |
|
I've just discoverd, by complete chance, that |
| Comment by Diego Dupin [ 2018-10-02 ] |
|
closing since solved by |