What is TYPE_SCROLL_INSENSITIVE ResultSet in JDBC?

This represents a scrollable ResultSet i.e. the cursor moves in forward or backward directions. 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.

Which means if we have established a connection with a database using JDBC program and retrieved a ResultSet holding all the records in a table named SampleTable and, meanwhile if we add some more records to the table (after retrieving getting the ResultSet), these recent changes will not be reflected in the ResultSet object we previously obtained.

Example

Consider we have a table named Employees in the database with the following contents:

+----+---------+--------+----------------+
| Id | Name    | Salary | Location       |
+----+---------+--------+----------------+
| 1  | Amit    | 3000   | Hyderabad      |
| 2  | Kalyan  | 4000   | Vishakhapatnam |
| 3  | Renuka  | 6000   | Delhi          |
| 4  | Archana | 9000   | Mumbai         |
| 5  | Sumith  | 11000  | Hyderabad      |
| 6  | Rama    | 11000  | Goa            |
+----+---------+--------+----------------+

Krantik Chavan

Updated on 30-Jul-2019 22:30:25

• Related Questions & Answers
• What is Type_FORWARD_ONLY ResultSet in JDBC?
• What is TYPE_SCROLL_SENSITIVE ResultSet in JDBC?
• What is ResultSet Concurrency in JDBC?
• What is ResultSet holdability in JDBC?
• What is CONCUR_UPDATABLE ResultSet in JDBC? Explain?
• What is CONCUR_READ_ONLY ResultSet in JDBC? Explain?
• What is Result in JDBC? How to retrieve data from ResultSet object?
• What is JDBC?
• Explain the difference between RowSet and ResultSet in JDBC?
• How to insert rows into a ResultSet in JDBC?
• How do you check if a ResultSet is empty or not in JDBC?
• How do you check if a ResultSet is closed or not in JDBC?
• How to get column count in a ResultSet in JDBC?
• What is Statement in JDBC?
• What is PreparedStatement in JDBC?