Example usage for java.sql DatabaseMetaData supportsBatchUpdates

Introduction

In this page you can find the example usage for java.sql DatabaseMetaData supportsBatchUpdates.

Prototype

boolean supportsBatchUpdates() throws SQLException;

Source Link

Document

Retrieves whether this database supports batch updates.

Usage

From source file:org.springframework.jdbc.support.JdbcUtils.java

/**
 * Return whether the given JDBC driver supports JDBC 2.0 batch updates.
 * <p>Typically invoked right before execution of a given set of statements:
 * to decide whether the set of SQL statements should be executed through
 * the JDBC 2.0 batch mechanism or simply in a traditional one-by-one fashion.
 * <p>Logs a warning if the "supportsBatchUpdates" methods throws an exception
 * and simply returns {@code false} in that case.
 * @param con the Connection to check//from   w ww .  j a va2 s  .  c o  m
 * @return whether JDBC 2.0 batch updates are supported
 * @see java.sql.DatabaseMetaData#supportsBatchUpdates()
 */
public static boolean supportsBatchUpdates(Connection con) {
    try {
        DatabaseMetaData dbmd = con.getMetaData();
        if (dbmd != null) {
            if (dbmd.supportsBatchUpdates()) {
                logger.debug("JDBC driver supports batch updates");
                return true;
            } else {
                logger.debug("JDBC driver does not support batch updates");
            }
        }
    } catch (SQLException ex) {
        logger.debug("JDBC driver 'supportsBatchUpdates' method threw exception", ex);
    }
    return false;
}