This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes Local caching architecture/choices 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 "Local caching architecture/choices" Watch "Local caching architecture/choices" New topic

Local caching architecture/choices

Sameer Thakur

Joined: Sep 23, 2005
Posts: 3
I have a need to cache Oracle blob data locally on disk on the client machine. I am running a plain vanilla java app which connects to Oracle using Type 4 JDBC connectivity.
My problem , what should i use to cache data ? FileSystem or RDBMS? currently i see about 3 blob columns from the same table on server which need to be locally cached. Using a file system caching mechanism developing an file heirarchy strategy is simple enough and i do have the advantage of not increasing complexity on client application by not including a local RDBMS. But i got to do the plumbing for data retreival.
If i use a local RDBMS then i do understand that data reteival plumbing work is not my headache but i am not sure which lightweight Db would support KBs of column data. Any suggestions for lighweight dbs which are free and crossplatform would be useful

Also ar there any known patterns for local disk caching?
thank you

Jeanne Boyarsky
internet detective

Joined: May 26, 2003
Posts: 30124

If it is on the client machine, it makes sense to use the file system. The client may not even have a database available and it is harder maintenance to deal with that choice.

[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
It is sorta covered in the JavaRanch Style Guide.
subject: Local caching architecture/choices
Similar Threads
BLOB file contents as HTML text
Saving Response content to a file.
on UI design :(
Hibernate: Throws Clobs are not cacheable Exception when try to cache
Record Caching, Reading Records