Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

scrollable resultset with Oracle

 
K Rajesh
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1141
1
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic