> From: John Pedersen [mailto:[EMAIL PROTECTED]
> Maybe I am asking too much ( I chose a long time ago not to store
> images and large files in the db - just store names and urls - maybe
> this was a poor choice.)
A lot depends on your environment. For small projects I tend to store
in database - being able to get a consistent snapshot of database and
filestore is important in some of the applications I work in. Sakai
(www.sakaiproject.org) can be configured to do either - small sites
often store in the database, the large sites (100,000+ users) tend to
store on filestore due to size restrictions on their RDMBSs. Bodington
(www.bodington.org) stores in filestore outside the servlet's URL space,
and has code to parse the request URL, check security, read the file
from filestore and deliver it if desired. Unless you *know* you can
control security in other ways, I'd suggest going down the Bodington
route if you want to use filestore.
Sakai and Bodington are both in Java under suitably free licenses
(Sakai's ESL, Bod is Apache2), so you could probably lift code from
either if it fit your requirements. I've no doubt there are other
projects out there that have the same requirements (and probably cleaner
code); these are merely two I know.
- Peter
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
