Re: Storing/retrieving BLOBs with JSPs

From: Ryan Stewart (zaphod_at_no.texas.spam.net)
Date: 01/09/04 

Date: Thu, 8 Jan 2004 17:08:01 -0600

"bigbinc" <bigbinc@hotmail.com> wrote in message
news:d1b33313.0401081044.27ac8238@posting.google.com...
*made bottom post*
> Thomas Schodt <news0310@xenoc.$DEMON.co.uk> wrote in message
news:<Xns945592D0EE3A4xenoc@158.152.254.254>...
> > "Ryan Stewart" <zaphod@no.texas.spam.net> wrote in
> > news:TIadnSzOONjJMkWiRTvUrg@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.

Relevant Pages

  • Re: Storing/retrieving BLOBs with JSPs
    ... >> reassemble them at retrieval time. ... Is there anyway to implement a sort of Network ... > File System using Oracle using blobs. ... > the oracle server? ...
    (comp.lang.java.help)
  • Re: [SLE] Missing space on my hard drive, 100% used and deleting files gives back no space.
    ... then reports on the file system that holds those files or directories. ... You can see what's mounted by using the "mount" command or by viewing ... And if the list you need to sort doesn't have ... read about sort's key field selection options. ...
    (SuSE)
  • Re: What does RISC OS mean to you?
    ... To me RISC OS provides a file system and user interface which does ... RAID file system hardware - probably SATA or similar. ... Once these relatively low-level problems are sorted out then perhaps ... Sort out these problems and the rest will follow - updates of good ...
    (comp.sys.acorn.misc)
  • Re: Limits on WSS 3.0 database size?
    ... Even only looking at document libraries. ... Not that I would do that in practice and it's not the sort of limit where 2000 is OK and 2001 isn't but that's the sort of possible figure we are talking about. ... It is however imo bad practice to move everything from an existing file system into a SharePoint system. ... Good practice is to select only the good stuff and let the rest stay in the file system and then use the SP doc libs only for new files. ...
    (microsoft.public.sharepoint.windowsservices)
  • NOTICE: alloc: /var: file system full
    ... NOTICE: alloc: /var: file system full ... This machine is a Oracle server. ... Do you Yahoo!? ...
    (SunManagers)