oracle中图片查询转换成Blob/cannot be cast to java.sql.blob

oracle中图片查询转换成Blob

String sql = " select img1 from tbl_image where wzid='" + tblXywz.getWid() + "' and img1 is not null ";
List list = entityManager.createNativeQuery(sql).getResultList();

//主要解决（cannot be cast to java.sql.blob）异常

SerializableBlobProxy proxy = (SerializableBlobProxy )Proxy.getInvocationHandler(list.get(0));
Blob blob = proxy.getWrappedBlob();

//

BufferedInputStream is = new BufferedInputStream(blob.getBinaryStream());
byte[] autographBytes =  new byte[(int) blob.length()];
int len = autographBytes.length;
int offset = 0;
int read = 0;
while(offset < len && (read = is.read(autographBytes,offset,len - offset)) >= 0){
	offset += read;
}
is.close();