Two Laptop Bag
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
It's not a secret anymore!