Java: Clob to byte[]

java sql bytearray clob
Victor picture Victor · Feb 24, 2011 · Viewed 16.8k times · Source

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

Answer

A.Alexander picture A.Alexander · Feb 25, 2011

with commons-io

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

Related questions

Storing UUID as base64 String

I have been experimenting with using UUIDs as database keys. I want to take up the least amount of bytes as possible, while still keeping the UUID representation human readable. I think that I have gotten it down to 22 bytes …

Read More
How to convert java.util.Date to java.sql.Date?

I am trying to use a java.util.Date as input and then creating a query with it - so I need a java.sql.Date. I was surprised to find that it couldn't do the conversion implicitly or explicitly …

Read More
could not extract ResultSet in hibernate

I have a problem with Hibernate. I try to parse to List but It throws an exception: HTTP Status 500 - could not extract ResultSet. When I debug, It fault at line query.list()... My sample code here @Entity @Table(name = "…

Read More