Java: defer to bytes []

Question

How can I read java.sql.Clob in bytes []?

Answer 1

with commons-io

byte[] data = IOUtils.toByteArray(clob.getAsciiStream());

Answer 2

int length = clob.getLength();         
 byte[] array = new byte[length];       
 InputStream in = clob.getAsciiStream();       
 int offset = 0;        
 int n;        
 do      
    n = in.read(array, offset, length - offset);        
 while (n != -1);

Try the code snippet above to read the clob into a byte array.

Answer 3

Get the ASCII stream, and then read from the stream into an array of bytes. http://download.oracle.com/javase/1.4.2/docs/api/java/sql/Clob.html#getAsciiStream ()