File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes How to make pagination? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Customer Requirements for Developers this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "How to make pagination?" Watch "How to make pagination?" New topic

How to make pagination?

Mishra Anshu
Ranch Hand

Joined: Sep 16, 2003
Posts: 224
This is a very common problem for any web application.
I need to make search which may result in thousands of records.
So, accordingly the page will be displayed (say, 10 results per page).

1st Approach:-
I make the query to hit database everytime a search is requested.So, for every page a search is unnecessarily performed.

2nd Approach:--
I store the result in the meory. So, say 1000 record have been searched and stored in the memory. So, not for every page result a new search is
required. But..., here I can't predict the search size, so I may get OutOFMemoryException.

3rd Approach :-
Since my DB is Oracle. I want to make a temp table to store the result od the search. But in Oracle , I think there is only Global Temp table, So, How it can handle the search , if there are multiple persons making the search at the same time.


"Ignorance is bliss"
kri shan
Ranch Hand

Joined: Apr 08, 2004
Posts: 1396
Try thru CachedRowSet
Mishra Anshu
Ranch Hand

Joined: Sep 16, 2003
Posts: 224
Can it avoid the OutOfMemory exception???
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 32328

For Oracle, look into materialized views. It's a caching technology on the db server.

If you are writing your own (options 1/2), consider whether you need all the results. A lot of users abandon the search without paging at all. In that case you only need the first 20 or so records. Getting more is a waste of resources.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1138

Since you are using Oracle, go to the Ask Tom Web site, and do a search for "pagination".

Good Luck,
Don't get me started about those stupid light bulbs.
subject: How to make pagination?
It's not a secret anymore!