This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
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
 
Similar Threads
resultset question
JDBC
Scrollable ResultSet
Limiting ResultSet
JDBC