Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
Description
When batching and there is no parameter, Bulk must not be use
example :
try (PreparedStatement prep = sharedConn.prepareStatement("INSERT INTO t1 VALUES (NULL)")) { |
for (int i = 0; i < 100; i++) { |
prep.addBatch();
|
}
|
prep.executeBatch();
|
}
|
will result in Error: 1295-HY000: This command is not supported in the prepared statement protocol yet
best solution would be using FOR loop : https://mariadb.com/kb/en/for/