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;
// w ww . ja v a2s. 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", "");
}
}