Home » Developer & Programmer » JDeveloper, Java & XML » SQL Cache frame work
SQL Cache frame work [message #377263] Mon, 22 December 2008 03:06 Go to next message
mr.rajeshyadav
Messages: 48
Registered: November 2007
Member
Hi,
I want to develop SQL Cache frame work such that if the query has got same set of conditions the results should be returned from cache instead of from DB and if there is any change in the data base it should get from the data base.

Can any body can suggest some approach to do this.

Thanks in advance,
Raj.
Re: SQL Cache frame work [message #377292 is a reply to message #377263] Mon, 22 December 2008 04:32 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle version?

Regards
Michel
Re: SQL Cache frame work [message #377294 is a reply to message #377292] Mon, 22 December 2008 04:38 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Yes, the version is important as Oracle 11g already has this built-in. It may be easier to upgrade than to develop a complete solution by yourself.
Re: SQL Cache frame work [message #377320 is a reply to message #377294] Mon, 22 December 2008 06:01 Go to previous messageGo to next message
mr.rajeshyadav
Messages: 48
Registered: November 2007
Member
I am using Oracle9i Release 9.2.0.1.0 - Production version
Re: SQL Cache frame work [message #377346 is a reply to message #377320] Mon, 22 December 2008 08:15 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As Franck said there is a built-in result cache in 11g, if you don't want to upgrade to this version then you have to create your own and this has nothing to do with Oracle rdbms.

But in 9.2 JDBC you can use a Cached Row Set, maybe this feature is what you need.

Regards
Michel
Previous Topic: Asking ADF table with popup
Next Topic: How to extract a lengthy XML(98628 bytes) using EXTRACT. Is it possible to extract such a huge XML?
Goto Forum:
  


Current Time: Thu Mar 28 13:11:26 CDT 2024