Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes Servlets and the fly likes scrollable resultset with Oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Java » Servlets
Bookmark "scrollable resultset with Oracle" Watch "scrollable resultset with Oracle" New topic
Author

scrollable resultset with Oracle

K Rajesh
Greenhorn

Joined: Jun 09, 2003
Posts: 5
Hi,
I have a situation where I want to display query result in a group of 30 results at a time.
right now I have a button which call same servlet. in the servlet I am checking whether it is firstime call or next Page call. for second call I am running same query skipping first 30 records. so no of click "next button" = no of times I am running the query.
Instead of that I'd like to use scrollable resultset

Please advice.
thanks
KR
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1121

Hi KR,
Are you saying that you don't know how to create a scrollable result set using JDBC?
Have you seen the example code available from Oracle's Technet Web site? There are also examples available in the Oracle documentation, which is available from their Tahiti Web site.
Hope this helps.
Good Luck,
Avi.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: scrollable resultset with Oracle
 
Similar Threads
order by with updatable SCROLL_SENSITIVE gives problem
need help for 10 rows per page just like forum
If stop button clicked after submit , what happned at Servlet side.
paging resultset in servlets
How to retrieve 1 million records in DB2 and write to a file?