BFILE or BLOB, that is the question.

From: Thomas Bennett <thb_at_conceptis.com>
Date: Thu, 29 Jul 1999 10:27:26 -0400
Message-ID: <37A064CE.E071C9D8@conceptis.com>

We will be writing a Java app to upload multi-media files into an Oracle repository (database).

Since the files we want to upload/store do not exist already on the server (as files) I would imagine that the most practical thing would be to (A) use the client side Java app to read the
multi-media file and store it into a BLOB column using Oracle JDBC classes.
As opposed to (B) the Java app reading the local file, FTPing it to the server
into a previously defined Oracle Directory object location and then inserting a record containing the BFILE reference.....

The latter (B) seems a bit more convoluted.

Any comments or recommendations ?

Thomas Bennett Received on Thu Jul 29 1999 - 09:27:26 CDT