The Java Developers Almanac 1.4


Order this book from Amazon.

   
Home > List of Packages > java.sql  [73 examples] > Batching  [2 examples]

e264. Determining If a Database Supports Batching

With batch updating, a set of SQL statements is assembled and then sent altogether to the database for execution. Batch updating can improve performance.
    try {
        DatabaseMetaData dmd = connection.getMetaData();
        if (dmd.supportsBatchUpdates()) {
            // Batching is supported
        } else {
            // Batching is not supported
        }
    } catch (SQLException e) {
    }

 Related Examples
e265. Executing a Batch of SQL Statements in a Database

See also: Connections    Database Meta Data    Deleting Data    Drivers    Importing and Exporting    Inserting and Updating Data    Oracle OBJECTs    Oracle VARRAYs    Procedures and Functions    Retrieving Data    Scrollable Result Sets    Tables    Updatable Result Sets   


© 2002 Addison-Wesley.