Optimized batching in jConnect

jConnect implements an internal algorithm to speed up batch operations for PreparedStatement objects. This algorithm is invoked when the HOMOGENEOUS_BATCH connection property is set to true.

This example illustrates a PreparedStatement batching operation using the addBatch and executeBatch methods:

String sql = "update members set lastname = ? where member_id = ?";

prep_stmt = connection.prepareStatement(sql);

prep_stmt.setString(1, "Forrester");

prep_stmt.setLong(2, 45129);

prep_stmt.addBatch();

prep_stmt.setString(1, "Robinson");

prep_stmt.setLong(2, 45130);

prep_stmt.addBatch();

prep_stmt.setString(1, "Servo");

prep_stmt.setLong(2, 45131);

prep_stmt.addBatch();

prep_stmt.executeBatch();

Where connection is a connection instance, prep_stmt is a prepared statement instance, and ? denotes parameter placeholders for the prepared statement.