Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Storing/retrieving BLOBs with JSPs
"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
![]() |
![]() |