Java API Tutorial - Java DatabaseMetaData .supportsResultSetHoldability (int holdability)

Syntax

DatabaseMetaData.supportsResultSetHoldability(int holdability) has the following syntax.

boolean supportsResultSetHoldability(int holdability)     throws SQLException

Example

In the following code shows how to use DatabaseMetaData.supportsResultSetHoldability(int holdability) method.

import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
// ww w .  ja va2s .  c  o m
public class Main {

  public static void main(String[] args) throws Exception {
    Connection conn = getHSQLConnection();

    DatabaseMetaData md = conn.getMetaData();
    System.out.println("supportsResultSetHoldability - "+ md.supportsResultSetHoldability(ResultSet.FETCH_FORWARD));


    conn.close();
  }

  private static Connection getHSQLConnection() throws Exception {
    Class.forName("org.hsqldb.jdbcDriver");
    String url = "jdbc:hsqldb:data/tutorial";
    return DriverManager.getConnection(url, "sa", "");
  }

}