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

Home -> Community -> Usenet -> comp.databases.oracle -> Re: Storing/retrieving BLOBs with JSPs

Re: Storing/retrieving BLOBs with JSPs

From: Ryan Stewart <zaphod_at_no.texas.spam.net>
Date: Thu, 8 Jan 2004 17:08:01 -0600
Message-ID: <h6SdnSjIIbhzf2CiU-KYlg@texas.net>


"bigbinc" <bigbinc_at_hotmail.com> wrote in message news:d1b33313.0401081044.27ac8238_at_posting.google.com... *made bottom post*
> Thomas Schodt <news0310_at_xenoc.$DEMON.co.uk> wrote in message
news:<Xns945592D0EE3A4xenoc_at_158.152.254.254>...
> > "Ryan Stewart" <zaphod_at_no.texas.spam.net> wrote in
> > news:TIadnSzOONjJMkWiRTvUrg_at_texas.net:
> >
> > > and it works for small files,
> > > but larger ones ... give an
> > > error saying that the data is too large for the field.
> > > Any solutions/help/nudges in the right
> > > direction are greatly appreciated
> >
> > As a workaround store big files as several slices of 4k (or whatever the
> > limit is) (maybe in a new table - with a slice-# as part of the key) and
> > reassemble them at retrieval time.
> This is cool stuff, Is there anyway to implement a sort of Network
> File System using Oracle using blobs. The question is, will this kill
> the oracle server?
> Will the performance being in better using File I/O for example using
> servlets?
>
> I would like to try it but I hate to mess up our server for doing so.
> Are there any benchmarks?

That's pretty much what I was/am doing: making a file-sharing system. We managed to get around the 4k limit by bypassing certain things and manually inserting the file data into the database. Received on Thu Jan 08 2004 - 17:08:01 CST

Original text of this message

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