Hi,
I've implemented a couple of applications that stored files inside the
database using the Oracle thin driver (we never use any driver type but
the thin). To do so we just used LONG RAW columns and getBinaryStream()
and setBinaryStream(). Even though we also used
ZipInputStream/ZipOutputStream to compress/decompress the files as they
were getting in/out of the database, files were pretty much always
bigger than 4K. Now we started using Blobs because of the advantages
they give you on the database side, even though their handling in Java
is not that simple.
Just my 2c,
D.
The elephantwalker wrote:
> the oracle thin driver can't handle any types larger than 4000 char,
> period. It doesn't matter whether you use long raw or whatever. If you
> have larger stuff, you will need to use clob or blob...these require
> reading and writing the character data or the byte[] data, taking care
> to use the empty_clob() and empty_blob() functions before your do your
> writing.We will be posting an example of how to do this with a slsb on
> our site soon...stay tuned...regards,the
> elephantwalkerwww.elephantwalker.com
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of
> Nusairat, Joseph F.
> Sent: Friday, September 07, 2001 12:10 PM
> To: Orion-Interest
> Subject: RE: ORacle db string over 4000 chars
>
> I do realise oracle has 4000 varchar limits ... but i have
> seen other systems get around this by using LONG or LONG RAW
> data types instead .... however when i use those .... i
> still have it bug out at 4000 chars .... Joseph Faisal
> Nusairat, Sr. Project Manager
> WorldCom
> tel: 614-723-4232
> pager: 888-452-0399
> textmsg: [EMAIL PROTECTED]
>
> -----Original Message-----
> From: Nusairat, Joseph F.
> [mailto:[EMAIL PROTECTED]]
> Sent: Friday, September 07, 2001 11:39 AM
> To: Orion-Interest
> Subject: ORacle db string over 4000 chars
>
> Does anyone know how to handle this oracle 8.x u
> can have a varchar set to 4k ... sooo to do more
> than that i tried using a long and a long raw ....
> and inserting it that way ... however whenver i go
> over 4000 chars it bombs .... any one come across
> this problem?
>
> Joseph Faisal Nusairat, Sr. Project Manager
> WorldCom
> tel: 614-723-4232
> pager: 888-452-0399
> textmsg: [EMAIL PROTECTED]
>
