标准的hibernate存取blob和clob字段的方法

来源：互联网发布：网络机顶盒app破解版编辑：程序博客网时间：2024/05/22 00:43

昨在颇为郁闷,利用hibernate保存图片到blob字段时出现保存成功,但读出来的确是空数据的问题;

但回家一试,竟然是OK的,不知哪个环节出了问题,但总算是圆满结局~

程序代码

Transaction tx=session.beginTransaction();
byte[] b=new byte[1024];
img.setTitle(title);
img.setAdddate(new Date());
img.setImage(Hibernate.createBlob(b));
img.setComments(Hibernate.createClob(" "));
session.save(img);
session.flush();
session.refresh(img, LockMode.UPGRADE);

SerializableBlob sb = (SerializableBlob)img.getImage();
java.sql.Blob wrapblob = sb.getWrappedBlob();
oracle.sql.BLOB blob = (oracle.sql.BLOB) wrapblob;

SerializableClob sc=(SerializableClob)img.getComments();
java.sql.Clob wrapclob=sc.getWrappedClob();
oracle.sql.CLOB clob=(oracle.sql.CLOB)wrapclob;

java.io.Writer pw=clob.getCharacterOutputStream();
pw.write(content);
pw.close();

java.io.InputStream inStream = new java.io.FileInputStream(path+"/"+newFileName);
byte[] bytes = new byte[fileSize];
java.io.OutputStream outStream = blob.getBinaryOutputStream();
inStream.read(bytes);
outStream.write(bytes);
outStream.flush();
outStream.close();
tx.commit();
session.close();