Re: problem with "getAsciiStream" method

From:

=?ISO-8859-1?Q?Arne_Vajh=F8j?= <arne@vajhoej.dk>

Newsgroups:

comp.lang.java.programmer

Date:

Tue, 22 Aug 2006 21:58:52 -0400

Message-ID:

<lDOGg.4029$_q4.1411@dukeread09>

tal wrote:

I am trying to retrieve some data from a db using the "getAsciiStream"
method of the ResultSet class of java language .

My code is like this:

rs = stmt.executeQuery(queryText);
InputStream in = rs.getAsciiStream(1);
boolean eof = false;
while(!eof)
    i = in.read();
    .
    .
    .
    Keep reading the bytes

But the value of i is -1 and when I look at the inputStream, he is
empty!
I have tried all sorts of other versions for this code which I saw at
the internet but all the time the value of i is -1.
Can anyone help me with this?
I can't use getString method because it too slow...

What database type ?

I would expect getAsciiStream only to work with
CLOB and similar database types.

I can really not see why a stream and a loop should
be faster than getString.

(since you are reading one byte at a time, then I
am rather sure that the stream and loop are slower)

If it is slow then the problem must be elsewhere.

It must be a 1000 times faster to move some bytes
(no matter how you do it) than reading data up
from a disk on the database server and send it over
the network to the application.

Arne