Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: BFILE or BLOB, that is the question.
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