Checking for Properties of a ResultSet Supported by a JDBC Driver

Description

Demo Code

import static java.sql.ResultSet.CLOSE_CURSORS_AT_COMMIT;
import static java.sql.ResultSet.CONCUR_READ_ONLY;
import static java.sql.ResultSet.CONCUR_UPDATABLE;
import static java.sql.ResultSet.HOLD_CURSORS_OVER_COMMIT;
import static java.sql.ResultSet.TYPE_FORWARD_ONLY;
import static java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE;
import static java.sql.ResultSet.TYPE_SCROLL_SENSITIVE;

import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class Main {
  public static void main(String[] args) {
    Connection conn = null;/*from   w  ww  .ja  v a  2s .co m*/
    try {
      conn = JDBCUtil.getConnection();
      DatabaseMetaData dbmd = conn.getMetaData();

      System.out.println("Supported result set scrollability.");
      printScrollabilityInfo(dbmd);

      System.out.println();
      System.out.println("Supported result set concurrency.");
      printConcurrencyInfo(dbmd);

      System.out.println();
      System.out.println("Supported result set holdability.");
      printHoldabilityInfo(dbmd);
    } catch (SQLException e) {
      e.printStackTrace();
    } finally {
      JDBCUtil.closeConnection(conn);
    }
  }

  public static void printScrollabilityInfo(DatabaseMetaData dbmd) {
    try {
      boolean forwardOnly = dbmd.supportsResultSetType(TYPE_FORWARD_ONLY);

      boolean scrollSensitive = dbmd
          .supportsResultSetType(TYPE_SCROLL_SENSITIVE);

      boolean scrollInsensitive = dbmd
          .supportsResultSetType(TYPE_SCROLL_INSENSITIVE);

      System.out.println("Forward-Only: " + forwardOnly);
      System.out.println("Scroll-Sensitive: " + scrollSensitive);
      System.out.println("Scroll-Insensitive: " + scrollInsensitive);
    } catch (SQLException e) {
      System.out.println("Could not get scrollability information.");
      System.out.println("Error Message:" + e.getMessage());
    }
  }

  public static void printConcurrencyInfo(DatabaseMetaData dbmd) {
    try {
      boolean forwardOnlyReadOnly = dbmd.supportsResultSetConcurrency(
          TYPE_FORWARD_ONLY, CONCUR_READ_ONLY);

      boolean forwardOnlyUpdatable = dbmd.supportsResultSetConcurrency(
          TYPE_FORWARD_ONLY, CONCUR_UPDATABLE);

      boolean scrollSensitiveReadOnly = dbmd.supportsResultSetConcurrency(
          TYPE_SCROLL_SENSITIVE, CONCUR_READ_ONLY);

      boolean scrollSensitiveUpdatable = dbmd.supportsResultSetConcurrency(
          TYPE_SCROLL_SENSITIVE, CONCUR_UPDATABLE);

      boolean scrollInsensitiveReadOnly = dbmd.supportsResultSetConcurrency(
          TYPE_SCROLL_INSENSITIVE, CONCUR_READ_ONLY);

      boolean scrollInsensitiveUpdatable = dbmd.supportsResultSetConcurrency(
          TYPE_SCROLL_INSENSITIVE, CONCUR_UPDATABLE);

      System.out.println("Scroll Forward-Only and " + "Concurrency Read-Only: "
          + forwardOnlyReadOnly);

      System.out.println("Scroll Forward-Only and " + "Concurrency Updatable: "
          + forwardOnlyUpdatable);

      System.out.println("Scroll Sensitive and " + "Concurrency Read-Only: "
          + scrollSensitiveReadOnly);

      System.out.println("Scroll Sensitive and " + "Concurrency Updatable: "
          + scrollSensitiveUpdatable);

      System.out.println("Scroll Insensitive and " + "Concurrency Read-Only: "
          + scrollInsensitiveReadOnly);

      System.out.println("Scroll Insensitive and " + "Concurrency Updatable: "
          + scrollInsensitiveUpdatable);
    } catch (SQLException e) {
      System.out.println("Could not get concurrency information.");
      System.out.println("Error Message:" + e.getMessage());
    }
  }

  public static void printHoldabilityInfo(DatabaseMetaData dbmd) {
    try {
      boolean holdOverCommit = dbmd
          .supportsResultSetHoldability(HOLD_CURSORS_OVER_COMMIT);

      boolean closeAtCommit = dbmd
          .supportsResultSetHoldability(CLOSE_CURSORS_AT_COMMIT);

      System.out.println("Hold Over Commit: " + holdOverCommit);
      System.out.println("Close At Commit: " + closeAtCommit);
    } catch (SQLException e) {
      System.out.println("Could not get concurrency information.");
      System.out.println("Error Message:" + e.getMessage());
    }
  }
}

class JDBCUtil {
  public static Connection getConnection() throws SQLException {
    Driver derbyEmbeddedDriver = null;// new
                                      // org.apache.derby.jdbc.EmbeddedDriver();
    DriverManager.registerDriver(derbyEmbeddedDriver);

    String dbURL = "jdbc:derby:beginningJavaDB;create=true;";
    String userId = "root";
    String password = "password";

    Connection conn = DriverManager.getConnection(dbURL, userId, password);
    conn.setAutoCommit(false);
    return conn;
  }

  public static void closeConnection(Connection conn) {
    try {
      if (conn != null) {
        conn.close();
      }
    } catch (SQLException e) {
      e.printStackTrace();
    }
  }

  public static void closeStatement(Statement stmt) {
    try {
      if (stmt != null) {
        stmt.close();
      }
    } catch (SQLException e) {
      e.printStackTrace();
    }
  }

  public static void closeResultSet(ResultSet rs) {
    try {
      if (rs != null) {
        rs.close();
      }
    } catch (SQLException e) {
      e.printStackTrace();
    }
  }

  public static void commit(Connection conn) {
    try {
      if (conn != null) {
        conn.commit();
      }
    } catch (SQLException e) {
      e.printStackTrace();
    }
  }

  public static void rollback(Connection conn) {
    try {
      if (conn != null) {
        conn.rollback();
      }
    } catch (SQLException e) {
      e.printStackTrace();
    }
  }

  public static void main(String[] args) {
    Connection conn = null;
    try {
      conn = getConnection();
      System.out.println("Connetced to the database.");
    } catch (SQLException e) {
      e.printStackTrace();
    } finally {
      closeConnection(conn);
    }
  }
}
Checking for Properties of a ResultSet Supported by a JDBC Driver - Java JDBC

Description

Demo Code

Related Tutorials
