The Java Developers Almanac 1.4


Order this book from Amazon.

   
Home > List of Packages > java.sql  [73 examples] > Scrollable Result Sets  [6 examples]

e266. Determining If a Database Supports Scrollable Result Sets

A scrollable result set allows the cursor to be moved to any row in the result set. This capability is useful for GUI tools that browse result sets.

There are two types of scrollable result sets. An insensitive scrollable result set is one where the values captured in the result set never change, even if changes are made to the table from which the data was retrieved. A sensitive scrollable result set is one where the current values in the table are reflected in the result set. So if a change is made to a row in the table, the result set will show the new data when the cursor is moved to that row.

    try {
        DatabaseMetaData dmd = connection.getMetaData();
        if (dmd.supportsResultSetType(ResultSet.TYPE_SCROLL_INSENSITIVE)) {
            // Insensitive scrollable result sets are supported
        }
        if (dmd.supportsResultSetType(ResultSet.TYPE_SCROLL_SENSITIVE)) {
            // Sensitive scrollable result sets are supported
        }
        if (!dmd.supportsResultSetType(ResultSet.TYPE_SCROLL_INSENSITIVE)
            && !dmd.supportsResultSetType(ResultSet.TYPE_SCROLL_SENSITIVE)) {
            // Updatable result sets are not supported
        }
    } catch (SQLException e) {
    }

 Related Examples
e267. Creating a Scrollable Result Set
e268. Determining If a Result Set Is Scrollable
e269. Moving the Cursor in a Scrollable Result Set
e270. Getting the Cursor Position in a Scrollable Result Set
e271. Getting the Number of Rows in a Table Using a Scrollable Result Set

See also: Batching    Connections    Database Meta Data    Deleting Data    Drivers    Importing and Exporting    Inserting and Updating Data    Oracle OBJECTs    Oracle VARRAYs    Procedures and Functions    Retrieving Data    Tables    Updatable Result Sets   


© 2002 Addison-Wesley.