hi all,

We need a tool that could reflect the content of a table in database.
The table is changed (from outside) about once an hour, so I want to be able to query the table without making a real select on each request but instead query some kind of cache that will be synchronized with the real table.

so my question is whether Hibernate (or other O-R tool) can do that? and how?

Thanks
Anat

Hi Anat,

If I understand your question, you don't really need hibernate.
You only need to creat a good model object with a cache to keep your data and a messaging system who invalidate your data in cache when an update or delete or insert is done.
You could use Hibernate for queries, but this is not the goal of hibernate.
You may use some pattern to do this.
I hope I answer your question.

Hi,

I don't understand what you really want to do...
Hibernate is a tool that helps you storing and querying relationnal databases in Object Oriented Applications. Hiberate gives you many options to do this in a very optimized way. It uses a cache to save the real modifications made on objects and then optimizes the queries.

Tell me more about your need, and I'll see if I could help...

Charles

Thanks for your quick answers, I'll try to clarify my problem.

I have a data that is stored in a table in Oracle.
This data is updated once an hour by a job running in the database.

My application needs to check each user request against this data.
I don't want to make a 'select' on every request (too slow) and instead I want to make the check against a mirror (cache?) located in memory.

But I need the data to be up-to-date as much as possible (I can do with a delay of a few minutes but not more).

Thanks again
Anat

It might be possible to come up with a Hibernate solution, but its certainly not a good scenario. You will probably be much faster writing something yourself than learning Hibernate.