Re: Adding huge streams into long raw column via JDBC driver

Guy Loewy wrote:

> Hi,
>
> I'm trying to insert into a long raw field in an Oracle DB huge file
> streams via the JDBC driver. In Oracle's documantation they implemented
> an example of reading in a loop buffer after buffer from the DB into a
> stream and to the hard disk. Since I don't want to use lots of memory
> I'd like to do the same only the other way around, insert a huge file
> into the DB reading buffer after buffer from the hard disk.
>
> All the answers and implementations I found in the newsgroups, read the
> whole file into a byte array (which I can't do) and than executeUpdate
> on a PreparedStatement.
>
> What I'm actually asking is how may I insert small buffers one after the
> other to the same long raw field via the JDBC drivers???
>
> Thanks in advance,
> Guy Loewy.
>
> Optimal technologies, Ltd.
> Atidim Science Park, Building 2
> P.O.Box 58090 Tel-Aviv 61580 Israel
> (Web Site: www.cioware.com)
>
> E-Mail: gloewy_at_cioware.com
> Tel : (972)-3-645-3556
>
> Tel-Aviv University.
> E-Mail: gloewy_at_math.tau.ac.il

Sorry for my misunderstanding,
The "setBinaryStream(?,byte[],length)" allows to add buffer after buffer.

--
Guy Loewy.