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 caching data Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "caching data" Watch "caching data" New topic

caching data

dhriti joshi
Ranch Hand

Joined: Aug 13, 2002
Posts: 82
I am fetching the resultset form oracle DB in my java class.

But since I do not want to query each time for performance reasons,I would like to keep the data in cache and call query after every 30 min.

How can I do this?any hints..

Thanks in advance,
Tim LeMaster
Ranch Hand

Joined: Aug 31, 2006
Posts: 226
Well I assume you are going to stuck the data into an object or a bunch of objects whether it been through an ORM or just straight JDBC calls. Stick the object[s] in a persistent state (Application for a web app where the query is the same for all users, Session per user cache, a swing app is naturally persistent if the object remains in scope) with a timestamp and check the timestamp everytime. What more is there to know?
I agree. Here's the link:
subject: caching data
jQuery in Action, 3rd edition