aspose file tools
The moose likes JDBC and Relational Databases 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 The Software Craftsman this week in the Agile forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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
author & internet detective

Joined: May 26, 2003
Posts: 31668

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.

[OCA 8 book] [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
Don't get me started about those stupid light bulbs.
subject: Local caching architecture/choices