> When trying to fetch a BLOB value like this : > InputStream blob = rset.getBinaryStream(3); > > blob.available() always returns 0 : is it normal ?
The specification for InputStream.available () says: Returns the number of bytes that can be read (or skipped over) from this input stream !!!without blocking!!!. Because retrieving the content of the LONG column usually requires an additional network request, returning the value 0 from the method 'available' is the right thing to do. If you're interested in the length of the LONG, you could use the method 'length' of the interfaces java.sql.Clob/Blob instead. Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
