Determining If a Database Supports Batching : Batch Update « Database SQL JDBC « Java

Determining If a Database Supports Batching


import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;

public class Main {
  public static void main(String[] argv) throws Exception {
    String driverName = "com.jnetdirect.jsql.JSQLDriver";

    String serverName = "";
    String portNumber = "1433";
    String mydatabase = serverName + ":" + portNumber;
    String url = "jdbc:JSQLConnect://" + mydatabase;
    String username = "username";
    String password = "password";

    Connection connection = DriverManager.getConnection(url, username, password);
    DatabaseMetaData dmd = connection.getMetaData();
    if (dmd.supportsBatchUpdates()) {
      // Batching is supported
    } else {
      // Batching is not supported



Related examples in the same category

1.Create a batch update in JDBC
2.Batch Update Insert
3.Batch update: add Batch commands
4.Check Batch Update Result
5.Batch Update Demo
6.Batch update for MySQL
7.Deal with batch update exception and results
8.Demo Prepared Statement Add Batch MySQL
9.Statement Batch Update
10.Prepared Statement With Batch Update