Re: please confirm something (jdbc)

From:

Thomas Kellerer <YQDHXVLMUBXG@spammotel.com>

Newsgroups:

comp.lang.java.programmer

Date:

Thu, 29 Nov 2007 15:43:58 +0100

Message-ID:

<5r81heFjiugnU1@mid.individual.net>

stc, 29.11.2007 15:35:

I managed to read the BLOB successfully using "getBytes()" method from
ResultSet. Then I tried to store BLOB using "setBytes()" and it worked. So
the summary is as following:

- Oracle 9i, 10g JDBC driver, Java 1.5
- writing BLOBs - both "setBinaryStream()" and "setBytes()" work
- reading BLOBs - works only with "getBytes()"

I would really like to have "getBinaryStream()" working so if you could help
I'd appreciate it...

I'm not sure that getBytes() works for other JDBC drivers as well. I
think get/setBinaryStream() was the only reliable (cross-dbms) way that
I found.

What I do, to read the BLOB (I removed the error handling obviously)

InputStream in = rs.getBinaryStream(1);
ByteArrayOutputStream baos = new ByteArrayOutputStream();
byte[] buffer = new byte[1024];

int bytesRead = in.read(buff);

while (bytesRead > -1)
{
baos.write(buff, 0, bytesRead);
bytesRead = in.read(buff);
}

in.close();
baos.close();

Now you can e.g. use baos.toByteArray() to access the raw data as a byte
array.

Note that using ByteArrayOutputStream.toByteArray() will create a copy
of its internal buffer so that will double the amount of memory that you
need. That's the reason I wrote my own dynamic byte array (where I can
access the byte array without copying it around)

Thomas