problems in using setAsciiStream() while inserting objects of large sizes

From: Amit Soni <amit.soni_at_oracle.com>
Date: Wed, 29 Oct 2003 13:06:13 +0530
Message-ID: <FdKnb.50$sF1.174@news.oracle.com>

Hi people,
I am using setAsciiStream() to insert data af size about 22MB. But there are two problems in that:
1) A parameter of setAsciiStream() is of type int and it takes the length of the stream available. So 22MB size cannot be specified using int 2) If I use preparedStatement's setAsciiStream() to put data in chunks (in a while loop with the chunk size of 2K), only the data of the last setAsciiStream() is pushed in the db.

Thanks in advance,
Amit. Received on Wed Oct 29 2003 - 01:36:13 CST