Batch updates use a single operation to process several SQL statements with values for multiple rows. The benefit is reduced network traffic. It takes fewer network round trips to execute a batch update. To do a batch update, a JDBC program enables transaction processing with the Connection.setAutoCommit method before instantiating a Statement . Next, it uses the addBatch method to add each SQL statement to the batch and then it calls the executeBatch method.
Historians argue to what extent failure to adapt caused the demise of the Roman Empire.
Database experts are probably more in agreement about the need to adapt query languages and programming interfaces to changing DBMS capabilities. ODBC 3.0 was a major improvement over version 2.0. For example, it added environment, connection, and statement attributes and improved error handling with diagnostic data structures. This made it easier to identify the offending row when a bulk insert of 100 rows produced an error. This makes it easier to work with time intervals in databases.