Home » Core Java » sql » Determine if a database supports Scrollable ResultSets

About Byron Kiourtzoglou

Byron Kiourtzoglou
Byron is a master software engineer working in the IT and Telecom domains. He is an applications developer in a wide variety of applications/services. He is currently acting as the team leader and technical architect for a proprietary service creation and integration platform for both the IT and Telecom industries in addition to a in-house big data real-time analytics solution. He is always fascinated by SOA, middleware services and mobile development. Byron is co-founder and Executive Editor at Java Code Geeks.

Determine if a database supports Scrollable ResultSets

With this example we are going to demonstrate how to determine if a database supports scrollable ResultSets. Values captured in an insentitive scrollable result set never change, even if changes are made to the table from which the data was retrieved, whereas a sensitive scrollable result set is one where the current values in the table are reflected in the result set. In short, to determine if a database supports scrollable ResultSets you should:

  • Load the JDBC Driver, using the forName(String className) API method of the Class. In this example we use the MySQL JDBC driver.
  • Create a Connection to the database. Invoke the getConnection(String url, String user, String password) API method of the DriverManager to create the connection.
  • Create a DatabaseMetaData, using the getMetaData() API method of the Connection. The metadata includes information about the capabilities of this connection.
  • Check if the database supports scrollable ResultSets. Invoke the supportsResultSetType(int type) API method
    of the DatabaseMetaData, for both TYPE_SCROLL_INSENSITIVE and TYPE_SCROLL_SENSITIVE types.

Let’s take a look at the code snippet that follows:

package com.javacodegeeks.snippets.core;

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

public class DetermineScrollableResultSetSupport {
 
  public static void main(String[] args) {

    Connection connection = null;
    try {

  // Load the MySQL JDBC driver

  String driverName = "com.mysql.jdbc.Driver";

  Class.forName(driverName);


  // Create a connection to the database

  String serverName = "localhost";

  String schema = "test";

  String url = "jdbc:mysql://" + serverName +  "/" + schema;

  String username = "username";

  String password = "password";

  connection = DriverManager.getConnection(url, username, password);

  

  System.out.println("Successfully Connected to the database!");

  
    } catch (ClassNotFoundException e) {

  System.out.println("Could not find the database driver " + e.getMessage());
    } catch (SQLException e) {

  System.out.println("Could not connect to the database " + e.getMessage());
    }

    try {


DatabaseMetaData metadata = connection.getMetaData();

if (metadata.supportsResultSetType(ResultSet.TYPE_SCROLL_INSENSITIVE)) {

    System.out.println("Insensitive scrollable result sets are supported");

}

if (metadata.supportsResultSetType(ResultSet.TYPE_SCROLL_SENSITIVE)) {

    System.out.println("Sensitive scrollable result sets are supported");

}

    } catch (SQLException e) {

  System.out.println("Could not get database metadata " + e.getMessage());
    }

  }
}

Example Output:

Successfully Connected to the database!
Insensitive scrollable result sets are supported

 
This was an example of how to determine if a database supports scrollable ResultSets in Java.

Do you want to know how to develop your skillset to become a Java Rockstar?

Subscribe to our newsletter to start Rocking right now!

To get you started we give you our best selling eBooks for FREE!

 

1. JPA Mini Book

2. JVM Troubleshooting Guide

3. JUnit Tutorial for Unit Testing

4. Java Annotations Tutorial

5. Java Interview Questions

6. Spring Interview Questions

7. Android UI Design

 

and many more ....

 

Receive Java & Developer job alerts in your Area

 

Subscribe
Notify of
guest

This site uses Akismet to reduce spam. Learn how your comment data is processed.

0 Comments
Inline Feedbacks
View all comments