What is the meaning of ResultSet type scroll insensitive?

What is the meaning of ResultSet type scroll insensitive?

Result Set Scroll Insensitive Type ( TYPE_SCROLL_INSENSITIVE ) : specifies that a resultset is scrollable in either direction but is insensitive to changes committed by other transactions or other statements in the same transaction.

How do I make a ResultSet scrollable?

Scrollable ResultSet example

1. Load the JDBC driver, using the forName(String className) API method of the Class.
2. Create a Connection to the database.
3. Create a Statement, using the createStatement() API method of the Connection.
4. Execute the query to the database, using the executeQuery(String sql) API method.

What is difference between Type_scroll_insensitive and Type_scroll_sensitive?

What is difference between TYPE_SCROLL_INSENSITIVE and TYPE_SCROLL_SENSITIVE ResultSet type in java? TYPE_SCROLL_INSENSITIVE is not sensitive to the changes made to the data that underlies the ResultSet. TYPE_SCROLL_SENSITIVE is sensitive to the changes made to the data that underlies the ResultSet.

What is the Scrolltype for the ResultSet that is scrollable and cursor can move forward or backward direction?

However, Scrollable ResultSet allows us to easily move in forward/backward direction. To create scrollable ResultSet, we must use a Statement/PreparedStatement object and provide scroll type to createStatement/prepareStatement method.

What is the difference between type scroll insensitive and type scroll sensitive?

This type of ResultSet is insensitive to the changes that are made in the database i.e. the modifications done in the database are not reflected in the ResultSet. This type of ResultSet is sensitive to the changes that are made in the database i.e. the modifications done in the database are reflected in the ResultSet.

What is scrollable ResultSet in Java?

A scrollable ResultSet is one which allows us to retrieve the data in forward direction as well as backward direction but no updations are allowed.

What are the different types of scrollable ResultSet?

There are 3 basic types of ResultSet.

• Forward-only. As name suggest, this type can only move forward and are non-scrollable.
• Scroll-insensitive. This type is scrollable which means the cursor can move in any direction.
• Scroll-sensitive.
• Forward-only.
• Scroll-insensitive.
• Scroll-sensitive.

What is ResultSet Concur_updatable?

It is a constant of the ResultSet class representing the concurrency mode for a ResultSet object that may be updated. In general, you will pass this as a value to the createStatement() method.

Which one is not a JDBC interface?

ConnectionPool is not a class of JDBC API. JDBC API consists of following interfaces and classes: DriverManager, Driver, Connection, Statement, ResultSet, SQLException.

What is Savepoint in Java?

The representation of a savepoint, which is a point within the current transaction that can be referenced from the Connection. When a transaction is rolled back to a savepoint all changes made after that savepoint are undone. Savepoints can be either named or unnamed.