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 How to make pagination? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How to make pagination?" Watch "How to make pagination?" New topic
Author

How to make pagination?

Mishra Anshu
Ranch Hand

Joined: Sep 16, 2003
Posts: 224
Hi,
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.

:roll:


"Ignorance is bliss"
kri shan
Ranch Hand

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

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

Joined: May 26, 2003
Posts: 30136
    
150

Mishra,
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.


[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: 1121

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

Good Luck,
Avi.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to make pagination?
 
Similar Threads
How to get results into same jsp
how to get num of rows in ResultSet
Creating Temp table and querying it
Searching words in VARCHAR2 & CLOB
Paging-Query based