Oracle-L: Anyone storing their documents in the database with

From: Arn Klammer <Arn.Klammer_at_austrac.gov.au>
Date: Thu, 16 Jan 2003 20:33:45 -0800
Message-ID: <F001.0053274E.20030116203345@fatcity.com>

This is a question that runs right up alongside the "RTFM" answer, but I have not gleaned this from the Oracle documentation.

I have been able to successfully store a range of documents (Word, Excel, etc) in the database, using Intermedia and the ORDDoc object type and adapting the Photo Album demo JSP application that Oracle supplies. Equally, I have been able to retrieve them via the browser and either open them with a plug-in or save them locally.

My problem now is that of maintaining them - change control, I guess. Now, when a document is retrieved from the database, it's only a copy, and thus changes to the copy need to be reloaded into the database, overwriting the current version.

At this point, it appears I would need to build a versioning application that allows documents to be checked out, making it obvious to the user that changes to the local copy will *NOT* automatically be reflected in the database version, and later checked back in, updating the database version to match the local copy.

Is this correct, or have I completely missed something a whole lot simpler?

How are others handling updates to documents stored in the database?

Thanx for any advice!

Regards,

Arn.

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager.

This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Arn Klammer
INET: Arn.Klammer_at_austrac.gov.au

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Jan 16 2003 - 22:33:45 CST