web development helpdesk

ByteArrayOutputStream baos = new ByteAttayOutputStream();
byte[] buf = new byte[1024];

InputStream in = blob.getBinaryStream();

int n = 0;
while ((n=in.read(buf))>=0)
{
   baos.write(buf, 0, n);
}

in.close();
byte[] bytes = baos.toByteArray();
String blobString = new String(bytes); 

3 Responses to “How do I convert a JDBC Blob to a String?”

1. Simisani Takobana Says:
   July 22nd, 2009 at 4:49 am

   You can achieve the same results by using this code :

   
java.sql.Blob ablob = rs.getBlob(1);
String str = new String(ablob.getBytes(1l, (int) ablob.length()));


2. Zubair Ahmed Says:
   December 29th, 2010 at 7:27 pm

   @Simisani Takobana: this technique is for small data set in blob field.. if the data size exceeds then there are chances to get OutOfMemoryExceptions….
   Thanks

3. Zubair Ahmed Says:
   December 29th, 2010 at 7:33 pm

   
StringBuffer strOut = new StringBuffer();
String aux;
// We access to stream, as this way we don't have to use the CLOB.length() which is slower...
// assuming blob = resultSet.getBlob("somefield");
BufferedReader br = new BufferedReader(new InputStreamReader(blob.getBinaryStream()));
while ((aux=br.readLine())!=null) {
strOut.append(aux);
}
return strOut.toString();


Leave a Reply