File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Scroll  Sensitive ResultSet Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Reply locked New topic

Scroll Sensitive ResultSet

Gourab Guha

Joined: Nov 06, 2006
Posts: 13
Hi Everybody,

I am using a scrollable sensitive result set. What I know about it, if the Data base value has been changed in the mean time when the JDBC application is traversing the result set, the effect will be displayed in the result set. But surprisingly I am not getting the result. Here is the code.

import java.sql.Connection;
//import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

* @author mc11
public class TestScrolableSens
private static Connection connection = null;
private static Statement statement = null;
private static ResultSet rs = null;

public static void main(String args[])
String sql = "SELECT * FROM EMP";
connection = JDBCLoader.getConnection("dbcracle:thin:@off2:1521:VELOZ","scott","tiger");
statement = connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs = statement.executeQuery(sql);
String empNo = rs.getString("EMPNO");
int salary = rs.getInt("SAL");
System.out.println(empNo + " " + salary);
catch(SQLException e)
catch(InterruptedException e)

When this program is running I have changes the value in SAL field but getting no effect in the ResultSet.

I am using Oracle as my DataBase and a type-4 driver. And I have checked that this operation is valid by using
boolean dbMetaData.othersUpdatesAreVisible(ResultSet.TYPE_SCROLL_SENSITIVE) method.

Please help me regarding this.

Subhadip Chatterjee
Ranch Hand

Joined: Dec 12, 2006
Posts: 93
Hi Gourav,
i think you missed the wonder of SCROLLABLE facilitates you with the power to traverse the data to and fro, which wasn't available in prev version of Resultset(OK, i won't bother you with the versions).Now, if you have any SELECT query, that creates an implicit cursor in the DB, as if making a COPY of your desired table, with required field values.mind the copy thing, as it's not a live pointer to your DB, once you ran the query, you get data in resultset, but it's now out of sync if you try changing the data from back-end DB itself. Unless you run the query again (through your class), it won't take the updated value.

Refreshing life every moment...
Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 63866

Please do not post the same question more than once. This instance has been closed.

[Asking smart questions] [About Bear] [Books by Bear]
I agree. Here's the link:
subject: Scroll Sensitive ResultSet
It's not a secret anymore!