Java: Clob to byte[] [closed]

Question

How can I read a java.sql.Clob into a byte[]?

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 above snippet of code for reading a clob into Byte array.