Re: BFILE or BLOB, that is the question.

From: C. Ferguson <c_ferguson_at_rationalconcepts.com>
Date: Thu, 29 Jul 1999 12:52:07 -0700
Message-ID: <37A0B0E7.C1A88385@rationalconcepts.com>

I vote for A. It's the cleanest solution. Go with your instincts and don't throw unneccessary steps into a simple solution. You could even write this as a signed applet. Best of luck,
Cindy

Thomas Bennett 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
Received on Thu Jul 29 1999 - 14:52:07 CDT