Scrollable resultset for prepared statement

[kavitha rama]

Can we define a scrollable resultSet for a prepared statement? If so how? Please help

[Milind Mahajan]

Yes. You can do that by using following method in Connection interface included in JDBC 2.0 API.
prepareStatement(String sql, int resultSetType, int resultSetConcurrency)
set the value of second argument - 'resultSetType' as ResultSet.TYPE_SCROLL_SENSITIVE to get scrollable resultset.
-Milind

[Sujatha Ranganathan]

Refer to this sample to know more about the Scrollable ResultSet functionality - http://otn.oracle.com/sample_code/tech/java/sqlj_jdbc/files/jdbc20/jdbc20.htm

[kavitha rama]

Thanks for the information