Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: BFILE or BLOB, that is the question.

Re: BFILE or BLOB, that is the question.

From: <tedchyn_at_yahoo.com>
Date: Thu, 29 Jul 1999 21:51:08 GMT
Message-ID: <7nqic8$8h5$1@nnrp1.deja.com>

In article <37A064CE.E071C9D8_at_conceptis.com>,   Thomas Bennett <thb_at_conceptis.com> wrote:
> 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
>
>

Thomas, option A is the way to go, if you don't a large amount of binary file. if you do you have to think about performance. Ted

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Jul 29 1999 - 16:51:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US