File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Scrollable resultset for prepared statement Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Scrollable resultset for prepared statement" Watch "Scrollable resultset for prepared statement" New topic
Author

Scrollable resultset for prepared statement

kavitha rama
Ranch Hand

Joined: Jun 18, 2003
Posts: 38
Can we define a scrollable resultSet for a prepared statement? If so how? Please help
Milind Mahajan
Ranch Hand

Joined: Oct 23, 2000
Posts: 77
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
Greenhorn

Joined: May 29, 2003
Posts: 12
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
Ranch Hand

Joined: Jun 18, 2003
Posts: 38
Thanks for the information
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Scrollable resultset for prepared statement